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)

Question

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)

Quizplus · Accepted Answer

The Answer of 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)

A College Student Is Developing a Spreadsheet Model of a Budget