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,and the sum of their pro-rated non-monthly expenses is in cell B40.What formula should be entered in the spreadsheet cell that contains their total expenses?
A) =SUM(B10-B40)
B) =SUM(B10:B23:B40)
C) =SUM(B10*B23*B40)
D) =SUM(B10+B23+B40)

Question

Quizplus · Accepted Answer

The formula for calculating the total expenses in this case would be to sum up their fixed, variable, and pro-rated non-monthly expenses, which are stored in cells B10, B23, and B40 respectively. Therefore, the correct formula would be to add the values in these cells together, which is represented by option D: =SUM(B10+B23+B40). Option A is incorrect because subtracting the pro-rated non-monthly expenses from the fixed expenses would not accurately represent their total expenses. Option B is incorrect because the sum function only takes one range of cells as its input, not multiple ranges. Option C is incorrect because multiplying the expenses together would not represent their total expenses.

Jose and Lisa Sanchez Created a Spreadsheet to Chart Their