5
QuizMultiple Choice

Quiz — Quiz

Question 5 • Quiz

In the spreadsheet, if the total assets are in cell B1 and the total liabilities are in cell B2, which formula should be used to calculate the net worth in cell B3?

Answer
A
is equal to SUM times open paren cap b 1 close paren
B
is equal to cap b 2 minus cap b 1
C
is equal to cap b 1 plus cap b 2
D
is equal to cap b 1 minus cap b 2

Explanation

Net worth is calculated as total assets minus total liabilities. With assets in B1 and liabilities in B2, enter =B1-B2 in cell B3. This matches choice D; choice B subtracts assets from liabilities, reversing the calculation.

AI-written and checked against the verified answer.

Previous
Next