Introduction to Functions Answers

6 verified answers1 views
1
Free Preview

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.

Answers:
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
2
Free Preview

Define Name Use in Formula ✔ Name ManagerCreate from Selection

A
Define Name
B
Use in Formula
C
✔ Name Manager
D
Create from Selection
3

New ✔ EditDelete Filter

A
New
B
✔ Edit
C
Delete
D
Filter
146188

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

Answers:
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
146189

Function Library ✔ Defined NamesFormula Auditing Calculation

A
Function Library
B
✔ Defined Names
C
Formula Auditing
D
Calculation
146190

Define Name Use in Formula ✔ Name ManagerCreate from Selection

A
Define Name
B
Use in Formula
C
✔ Name Manager
D
Create from Selection

Did you find these answers helpful?

Introduction to Functions Answers — TX-Business…