Be able to use named cells and named ranges

What are Named Cells & Ranges?

Think of a spreadsheet as a giant city map. Cells are like individual houses (A1, B2, etc.). A named cell is a house with a nickname so you can call it later without remembering its exact address. A named range is a whole block of houses that share a single nickname.

Why Use Names?

• Readability: formulas like =TotalSales are easier to understand than =SUM(B2:B10).
• Flexibility: if the data moves, the name stays linked.
• Collaboration: teammates can instantly know what a name refers to.

Creating a Named Cell

1. Select the cell (e.g., A1).
2. Go to Formulas > Name Manager (or click the Name Box left of the formula bar).
3. Enter a name (no spaces, start with a letter): TaxRate.
4. Click OK.

Now =TaxRate returns the value in A1.

Creating a Named Range

1. Select a block (e.g., B2:D10).
2. Use the Name Box or Name Manager to give it a name: SalesData.
3. Now =AVERAGE(SalesData) calculates the average of that block.

Practical Example

Formula example: =SUM(SalesData)*TaxRate → total tax on sales.

Exam Tips

• Identify the task: If the question asks for “the average of the sales data”, use the named range directly.
• Check naming rules: No spaces, no starting with a number, and unique within the workbook.
• Use the Name Manager: It lists all names and their references – handy for debugging.
• Practice: Create a workbook with at least 3 named cells and 2 named ranges, then build formulas that reference them.

Quick Practice

Given the following data:

1. Name cell B2 as TaxRate with value 0.15.
2. Name the range B2:B4 as MonthlyRevenue.
3. Write a formula to calculate the total tax for the quarter.

Answer: =SUM(MonthlyRevenue)*TaxRate