Practice q - self contradictory - project management- last topic


4 Answer(s)


Regarding first question
A1 = 200 (actual)
A2 = 500 (projected)
if you want the deficit in cell A3 then the formula in A3 should be =A1-A2

The first option A3=A1-A2: is a wrong formula and excel does not support this formula

The second option =A2-A1 is not right since you have to subtract the projected from the actual to get deficit and not the other way round.

The 3rd option =A1*A2 is multiplying the 2 numbers and that result is irrelevant to calculating the deficit


If your deficit is a -ve number, that means that your budgeted amount is less than what you spent.

Does this answer your question or are you still confused?

Just read your answer,
thanks for posting them