A College Student Is Developing a Spreadsheet Model of a Budget

Multiple Choice

A college student is developing a spreadsheet model of a budget. To calculate the monthly surplus (or deficit) , the student subtracts living expenses, entertainment costs, and savings from income. Entering which of the following formulas into cell B5 will perform the proper calculation?

A) =Monthly Income − Expenses
B) =B1 − B2 − B3 − B4
C) =B2 + B3 + B4 − B1
D) =B1 + (B2 − B3 − B4)
E) =B1 − (B2 − B3 − B4)