Introduction to Functions Answers

What is a benefit of the Name Manager feature?

Function Library✔ Defined NamesFormula AuditingCalculation

Define NameUse in Formula✔ Name ManagerCreate from Selection

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.

Click the [___] tab on the ribbon and look in the [___] gallery.

Select [___].

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

Define NameUse in Formula✔ Name ManagerCreate from Selection

Select the name you wish to edit, then select the [___] button. Make corrections and save.

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.

Define NameUse in FormulaName Manager✔ Create from Selection

✔ Top rowLeft columnBottom rowRight column

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.

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

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

New✔ EditDeleteFilter

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

Select [___] to get into the manager.

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.