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

Select the correct navigational path to set the name for a cell range.

Revolt · Accepted Answer

✔ Formula; Click the tab on the ribbon and look in the gallery.: Formula; Click the tab on the ribbon and look in the gallery.: Defined Names; Select .: Name Manager

Question 3

Function Library ✔ Defined NamesFormula Auditing Calculation

Revolt · Accepted Answer

✔ Defined Names

Question 4

Define Name Use in Formula ✔ Name ManagerCreate from Selection

Revolt · Accepted Answer

✔ Name Manager

Question 5

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 6

Define Name Use in Formula ✔ Name ManagerCreate from Selection

Revolt · Accepted Answer

✔ Name Manager

Question 7

New ✔ EditDelete Filter

Revolt · Accepted Answer

✔ Edit

Question 8

Kristoffer 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

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

Question 9

Define Name Use in Formula Name Manager ✔ Create from Selection

Revolt · Accepted Answer

✔ Create from Selection

Question 10

✔ Top rowLeft column Bottom row Right column

Revolt · Accepted Answer

✔ Top row

Introduction to Functions Answers

More from this Course

TRY EDGENUITY HACKS