Question

A B C D 1 Expenses: 2 Wages expense $8,000 3 Rent expense 2,000 4 Insurance expense 800 5 Utilities expense 300 6 Total expenses 7 Which formula in cell C6 would continue to be accurate after a row was inserted between rent expense and insurance expense? Multiple Choice =+B2+B5 =SUM(B2:B5) =SUM(B2:C7) =+B2+B3+B4+B5

          A
B
C
D
1 Expenses:
2 Wages expense
$8,000
3 Rent expense
2,000
4 Insurance expense
800
5 Utilities expense
300
6 Total expenses
7
Which formula in cell C6 would continue to be accurate after a row was inserted
between rent expense and insurance expense?
Multiple Choice
=+B2+B5
=SUM(B2:B5)
=SUM(B2:C7)
=+B2+B3+B4+B5

A
B
C
D
1 Expenses:
2 Wages expense
8,000
3 Rent expense
2,000
4 Insurance expense
800
5 Utilities expense
300
6 Total expenses
7
Which formula in cell C6 would continue to be accurate after a row was inserted
between rent expense and insurance expense?
Multiple Choice
=+B2+B5
=SUM(B2:B5)
=SUM(B2:C7)
=+B2+B3+B4+B5

Added by Michael B.

Horngren’s Cost Accounting

Srikant M. Datar, Madhav V. Rajan 16th Edition

Instant Answer

Solved by Expert Akash M

08/27/2023

Step 1

The formula in cell C6 is currently =SUM(B2:B5), which sums up the values in cells B2 to B5. This formula is accurate for the current range of expenses. Show more…

Show all steps

Thanks for your feedback!

Which formula in cell C6 would continue to be accurate after a row was inserted between rent expense and insurance expense? Multiple Choice =+B2+B5 =SUM(B2:B5) =SUM(B2:C7) =+B2+B3+B4+B5