Jeannine uses Excel to track her check register. Column A is the ...

[Sufayan.ah]

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.
 A) =F4-D5+E5
  B) =F4+D5-E5
  C) =F4-D5
  D) =F4+E5

Question 2

Mary Rutledge has a checkbook balance of 1,527.09. Her bank statement shows an unexpected direct deposit of 623.18 and ATM fees that total 5.50. There are no outstanding checks or deposits. What should her adjusted checkbook balance be?
 A) 2,150.27
  B) 2,144.77
  C) 903.91
  D) 898.41

[annierak]

Answer to Question 1

A

Answer to Question 2

B