Named ranges in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a named range in Excel?

A named range is a friendly name given to a cell or group of cells. It helps you easily refer to those cells in formulas instead of using cell addresses like A1 or B2.

beginner

How do you create a named range in Excel?

Select the cells you want to name, then type the name in the Name Box (left of the formula bar) and press Enter. Or use the 'Define Name' option from the Formulas tab.

beginner

Why use named ranges instead of cell references?

Named ranges make formulas easier to read and understand. For example, =SUM(Sales) is clearer than =SUM(B2:B10). It also helps avoid mistakes when cells move.

intermediate

Can named ranges refer to cells on different sheets?

Yes, named ranges can refer to cells on any sheet in the workbook. The name works everywhere, so you don’t need to write sheet names in formulas.

beginner

How do you use a named range in a formula?

Simply type the name of the range in the formula instead of cell addresses. For example, =AVERAGE(Expenses) calculates the average of the cells named 'Expenses'.

What is the main benefit of using named ranges in Excel formulas?

A Slows down calculation speed

B Prevents saving the workbook

C Makes formulas easier to read and understand

D Deletes data automatically

Named ranges help make formulas clearer by replacing cell addresses with meaningful names.

Where do you type a name to create a named range quickly?

A Name Box next to the formula bar

B Status bar at the bottom

C Cell comment box

D Page layout tab

The Name Box is located to the left of the formula bar and is used to name selected cells.

Can a named range refer to multiple cells on different sheets?

A Yes, named ranges can include cells from different sheets

B No, named ranges must be on the same sheet

C Only if the sheets are hidden

D Only if the workbook is shared

Named ranges cannot refer to multiple cells across different sheets; they must be on the same sheet or refer to a single cell on another sheet.

Which of these is a valid named range name?

A Sales2024

B 2024Sales

C Sales Total

D Total-Sales

Named ranges cannot start with a number or contain spaces or special characters like hyphens.

How do you use a named range in a formula?

A Save the workbook

B Use the cell address instead

C Insert a chart first

D Type the name directly in the formula

You use named ranges by typing their name in formulas, making them easier to read.

Explain what a named range is and why it is useful in Excel.

Think about how naming a group of cells can help you work faster and clearer.

Describe the steps to create and use a named range in a formula.

Remember the quick way using the Name Box near the formula bar.