Jeannine uses Excel to track her check register. Column A is the date, Column B is the check number, Column C is the transaction description, Column D is the check amount, Column E is the deposit amount, and Column F is the balance. Which formula could be used in the balance column that would give a correct balance regardless of whether the transaction was a withdrawal or a deposit? Assume the starting balance is located in Cell F4 and the transaction is in Row 5.

Question

Quizplus · Accepted Answer

The formula =F4-D5+E5 would give a correct balance regardless of whether the transaction was a withdrawal or a deposit because it subtracts the check amount from the previous balance and adds the deposit amount.

Jeannine Uses Excel to Track Her Check Register