Introduction to Functions

Question 1

What is a benefit of the Name Manager feature?

Revolt · Accepted Answer

add, edit, filter names you have created

Question 2

Function Library✔ Defined NamesFormula AuditingCalculation

Revolt · Accepted Answer

Formula Auditing

Question 3

Define NameUse in Formula✔ Name ManagerCreate from Selection

Revolt · Accepted Answer

Create from Selection

Question 4

Select the correct navigational path to set the name for a cell range. Click the tab on the ribbon and look in the gallery. Select the range of cells. Select . Add the name and click OK.

Revolt · Accepted Answer

Formula; Selection 1: Formula; Selection 2: Defined Names; Selection 3: Name Manager

Question 5

Function Library✔ Defined NamesFormula AuditingCalculation

Revolt · Accepted Answer

✔ Defined Names

Question 6

Define NameUse in Formula✔ Name ManagerCreate from Selection

Revolt · Accepted Answer

✔ Name Manager

Question 7

Select the correct navigational path to edit the name of a cell range using Name Manager.

Revolt · Accepted Answer

✔ Formula; Click the tab on the ribbon to enter the Defined Names gallery.: Formula; Select to get into the manager.: Name Manager; Select the name you wish to edit, then select the button. Make corrections and save.: Edit

Question 8

Define NameUse in Formula✔ Name ManagerCreate from Selection

Revolt · Accepted Answer

Create from Selection

Question 9

New✔ EditDeleteFilter

Revolt · Accepted Answer

✔ Edit

Question 10

Kristofer needs to create cell names that match the column headings he has already created. Select the correct navigational path to set those names using the Create from Selection command.

Revolt · Accepted Answer

Click on the tab on the ribbon and look in the Defined Names gallery.: Formula; Select .: Create from Selection; Select and click OK.: Top row

Introduction to Functions Answers

More from this Course

TRY EDGENUITY HACKS