Question

maximilianos net worth spreadsheet
maximiliano is reviewing his personal finance spreadsheet. he has entered his assets and liabilities, but there are
mistakes in some of the formulas. here is what the spreadsheet looks like:
what is the correct formula for calculating net worth in cell b11?
=sum(b6:b10)
=b6+b10
=b6 - b10
=b5 - b8

Explanation:

Step1: Recall the formula for net worth

Net worth is calculated as total assets minus total liabilities. In the spreadsheet, cell B6 contains the formula for total assets (\(=\text{SUM}(B3:B5)\)) and cell B10 contains the formula for total liabilities (\(=B8 + B9\)).

Step2: Determine the correct formula

The formula for net worth should be \(=\text{Total Assets}-\text{Total Liabilities}\), which in terms of cell references is \(=B6 - B10\).

Answer:

\(=B6 - B10\)