2
AssignmentDropdown

Cell and Range Names

Question 2 • GA-Business and Technology B Ammons 2025-2026

2. On the tab, in the Defined Names group, click .

Answer
A
Format Cells
B
Create from Selection
C
Range Names
D
Use in Formula

Explanation

To create named ranges from nearby row or column labels in Excel, use Create from Selection in the Defined Names group on the Formulas tab. Format Cells is for cell appearance, and Use in Formula inserts an existing defined name into a formula.

AI-written and checked against the verified answer.