Jeannine Uses Excel to Track Her Check Register

question 39

Multiple Choice

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

---

Definitions:

Family and Medical Leave Act

A United States law that provides eligible employees with unpaid, job-protected leave for certain family and medical reasons.

Private Employers

Individuals or entities that operate businesses or hire workers in the private sector, as opposed to government entities.

Eligible Employees

Workers who meet certain criteria set by their employers or government regulations, qualifying them for specific benefits or rights.

Family and Medical Leave Act

A U.S. federal law that provides eligible employees with unpaid, job-protected leave for family and medical reasons.