Author Question: Jeannine uses Excel to track her check register. Column A is the date, Column B is the check number, ... (Read 101 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?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

On average, the stomach produces 2 L of hydrochloric acid per day.

Did you know?

The U.S. Pharmacopeia Medication Errors Reporting Program states that approximately 50% of all medication errors involve insulin.

Did you know?

The most common childhood diseases include croup, chickenpox, ear infections, flu, pneumonia, ringworm, respiratory syncytial virus, scabies, head lice, and asthma.

Did you know?

More than one-third of adult Americans are obese. Diseases that kill the largest number of people annually, such as heart disease, cancer, diabetes, stroke, and hypertension, can be attributed to diet.

For a complete list of videos, visit our video library