Introduction to Functions

Put the pieces of a function into the correct order as if you were writing a formula

= Function Arguments

What function text would you use to put today's date and time in a cell?

=NOW()

Which part of the formula is the argument?

A1:E59

What is the quick key to highlighting a column?

Ctrl + Shift + down arrow

Where in the Formula tab on the ribbon would you find the Use in Formula function?

Defined Names

Order the steps for the correct path to adding defined names into a formula.

Enter an equal sigh into the cell Type the function into caps Type an open parenthesis and enter named cells instead of location

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

Fomula Defined Names Name Manager

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.

Formula Create from Selection Top row

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

Formula Name Manager Edit

How can you get to the Excel Function Reference information? Check all that apply.

Help tab F1 Searching in the Tell Me bar

What is unique about the date calculations from other formulas?

Some do not require any arguments.

What is the purpose of the Excel Function Reference?

To look up functions and their purposes

Which areas can be used to create names in the Create from Selection feature in the Formula tab? Check all that apply.

Top row Left column Right column Bottom row

What is a benefit of the Name Manager feature?

add, edit, filter names you have created

Where should a range name be entered?

in the name box in the formula bar