Question

Create a named range called, "Savings" that references the cell that calculates the monthly savings in your budget. The savings calculation should be the difference between the total income and total expenses in your budget. Be sure to reference the named ranges for income and expenses in your calculations. [4 points]

Answer 1

Answer:

In Microsoft Excel, we can follow the steps as below to create a named range:

1. Pick a target cell or target range of cells
2. There will be a Name Box shown up and we shall type the name "Savings" into the box.
3. Press Enter
4. In the Formula bar, we set the formula =(Income - Expenses). This is based on the presumption that there are also two other named ranges, "Income" and "Expenses" which already been defined.

Answer 2

Is this to be done in excel?