Cell and Range Names

Question 1

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

Revolt · Accepted Answer

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

Question 2

Range NamesFormulas✔ Defined Names

Revolt · Accepted Answer

✔ Defined Names

Question 3

Existing Names✔ Apply NamesFormat Names

Revolt · Accepted Answer

✔ Apply Names

Question 4

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

Revolt · Accepted Answer

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

Question 5

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

Revolt · Accepted Answer

✔ Formulas; 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

Question 6

What are two examples of information displayed in the Name Manager?

Revolt · Accepted Answer

all range names in the workbook and the cell references to which the range names refer

Question 7

What is the first step when creating a 3-D range name?

Revolt · Accepted Answer

Open the Name Manager, and click New.

Cell and Range Names Answers

More from this Course

TRY EDGENUITY HACKS