Using Named Ranges in Formulas - Exercise

Contact Us or call 1-877-932-8228
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:QuarterlyIncome Text.
  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:Create from Selection Command
    3. In the Create Names from Selection dialog box, check Top row and Left column and click OK:Top row and Left column Options
  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.

Next