Question

9. Jose and Lisa Sanchez created a spreadsheet to chart their income and expenses for the month. The sum of their fixed expenses is in cell B10, the sum of their variable expenses is in cell B23,

the sum of their pro-rated non-monthly expenses is in cell B40. What formula should be entered in the spreadsheet cell that contains
All changes saved
and
their total expenses?
=SUM(B10-B40)
O O
=SUM(B10:B23:B40)
=SUM(B10*B23*B40)
=SUM(B10+B23+B40)

Answer 1

To calculate the total expenses of Jose and Lisa Sanchez in the given scenario, the formula that should be entered in the spreadsheet cell is =SUM(B10+B23+B40). This formula will sum up the fixed expenses in cell B10, variable expenses in cell B23, and the pro-rated non-monthly expenses in cell B40 to give the total expenses for the month. Therefore, the answer is option D: =SUM(B10+B23+B40).