25
QuizMultiple Choice

Budget — Test

Question 25 • Financial Math

What is the correct formula for calculating total assets in cell B6?

Answer
A
=B3+B5
B
=B3+B4+B5+B6
C
=SUM(B3:B6)
D
=SUM(B3:B5)

Explanation

To calculate total assets in B6, add the asset amounts listed in cells B3 through B5. The formula =SUM(B3:B5) includes all three cells and leaves the total cell B6 out of the sum, avoiding a circular reference. Therefore, the correct choice is D.

AI-written and checked against the verified answer.

Previous
Next