Author Question: Jeannine uses Excel to track her check register. Column A is the date, Column B is the check number, ... (Read 91 times)

Sufayan.ah

  • Hero Member
  • *****
  • Posts: 512
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

  • Sr. Member
  • ****
  • Posts: 340
Answer to Question 1

A

Answer to Question 2

B



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

The types of cancer that alpha interferons are used to treat include hairy cell leukemia, melanoma, follicular non-Hodgkin's lymphoma, and AIDS-related Kaposi's sarcoma.

Did you know?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

For a complete list of videos, visit our video library