Introduction to Functions

Question 1

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

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 2

Define Name Use in Formula ✔ Name ManagerCreate from Selection

Revolt · Accepted Answer

✔ Name Manager

Question 3

New ✔ EditDelete Filter

Revolt · Accepted Answer

✔ Edit

Question 4

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 5

Function Library ✔ Defined NamesFormula Auditing Calculation

Revolt · Accepted Answer

✔ Defined Names

Question 6

Define Name Use in Formula ✔ Name ManagerCreate from Selection

Revolt · Accepted Answer

✔ Name Manager

Question 7

What is a benefit of the Name Manager feature?

Revolt · Accepted Answer

add, edit, filter names you have created

Question 8

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 9

What is the purpose of the Excel Function Reference?

Revolt · Accepted Answer

to look up functions and their purposes

Question 10

Which part of the formula is the argument?

Revolt · Accepted Answer

A1:E59

Introduction to Functions Answers

More from this Course

TRY EDGENUITY HACKS