24
QuizMultiple Choice

Budget — Test

Question 24 • Financial Math

What is the correct formula for calculating total liabilities in cell B10?

Answer
A
=SUM(B8:B11)
B
=B8+B11
C
=B8+B9
D
=B7+B8+B9

Explanation

Total liabilities are calculated by adding the liability amounts listed above the total. Here, those amounts are in cells B8 and B9, so the formula is =B8+B9. Choice C gives that formula; summing through B11 would include the total cell itself and could create a circular reference.

AI-written and checked against the verified answer.

Previous
Next