# Using Named Ranges in Formulas - Exercise

Using Named Ranges in Formulas - Exercise

# Using Named Ranges in Formulas

Duration: 10 to 20 minutes.

In this exercise, you will practice naming cells and will use named cells in a formula.

1. Open Using Names.xlsx from your Excel2013.2/Exercises folder.
2. Name cell B1 "QuarterlyIncome".
3. Use the Create from Selection command to name cells in the range A3:E8.
4. Using only names in your formulas, answer the questions in column A of the worksheet.

## Solution:

1. To name cell B1:
1. Select cell B1.
2. Type "QuarterlyIncome" in the Name Box and press Enter:.
2. To name cells A3:E8:
1. Select cells A3:E8.
2. On the FORMULAS tab, in the Defined Names group, click the Create from Selection command:
3. In the Create Names from Selection dialog box, check Top row and Left column and click OK:
3. To answer the questions in column A of the worksheet:
1. How much was spent on Clothes and Fun Stuff in January? Type "=Jan Clothes+Jan Fun_Stuff".
2. How much was spent on Groceries in Jan and Mar? Type "=Jan Groceries+Mar Groceries".
3. What % of Quarterly Income did Electric account for from Jan to Mar? Type "=Total Electric/QuarterlyIncome".

Hint: If step 3 isn't working for you, make sure that you named cell B1 "QuarterlyIncome" with no space and that you did not include a space within "QuarterlyIncome" in the formula for B13.