CIS 105 - 1.11

In cell F13, the balance looks correct for the inflow minus outflow, but is the formula correct?

• Yes

• No

If the money inflow was zero for Week 6, should a 0 be entered into the spreadsheet? Or did the user forget to input the value? What steps should be taken to correct the issue?

• Enter 1 in G6

• Enter 0 in G6

• Enter 2 in G6

• Leave the cell empty

In Week 8, the balance is too low. Is the formula correct?

• Yes

• No

The balance for week 8 is too low, evaluate the formula provided and enter the correct formula.

Does the balance for Week 10 follow money inflow minus money outflow?

• Yes, it adds them

• No, it adds them

• Yes, it multiplies them

• No, it subtracts them

In cell C13, the balance seems more than what it should be. Is the formula correct?

• Yes

• No

What is the correct formula to arrive at the total in cell F13? Evaluate the cells and enter the correct formula.