Cell and Range Names Answers

4 verified answers1 views
1
Free Preview

Complete each sentence to describe how to add range names to existing formulas.

Answers:
Click the tab.:Formulas
In the group, click the Define Names drop-down arrow.:Defined Names
Click . Use the dialog box to select the names.:Apply Names
2
Free Preview

Range NamesFormulas✔ Defined Names

A
Range Names
B
Formulas
C
✔ Defined Names
3

Existing Names✔ Apply NamesFormat Names

A
Existing Names
B
✔ Apply Names
C
Format Names
88322

Complete each sentence to describe how to work with range names.

Answers:
A range name should be entered in the .:name box in the formula bar
To move the selection to a specific range by its name, click the .:name box drop-down arrow
Then, click the .:range name

Did you find these answers helpful?

Cell and Range Names Answers — GA-Business and…