Introduction to Functions

Question 1

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 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

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

Select .: Create from Selection; Select and click OK.: Top row

Question 5

Define NameUse in FormulaName Manager✔ Create from Selection

Revolt · Accepted Answer

✔ Create from Selection

Question 6

✔ Top rowLeft columnBottom rowRight column

Revolt · Accepted Answer

✔ Top row

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. Click the tab on the ribbon to enter the Defined Names gallery. Select to get into the manager. Select the name you wish to edit, then select the button. Make corrections and save.

Revolt · Accepted Answer

Formula; Selection 1: Formula; Selection 2: Name Manager; Selection 3: Edit

Question 9

How can you get to the Excel Function Reference information? Check all that apply.Help tabEscF1searching in the Tell Me barCtrl + R

Revolt · Accepted Answer

Help tab; F1; searching in the Tell Me bar

Question 10

Which part of the formula =COUNTIF(A1:E59,"Greene City”) is the argument?

Revolt · Accepted Answer

A1:E59

Introduction to Functions Answers

More from this Course

TRY EDGENUITY HACKS