Introduction to Functions

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

1. = 2. Function 3. Arguments

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

1. Enter an equal sign into the cell 2. type the function in caps 3. Type an open parenthesis and enter named cells instead of location.

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. Click on the _______ tab on the ribbon and look in the Defined Names gallery. Select the range of cells, including the row that includes the name you wish to use. Select ________. Select ____________ and click OK.

1. Formula 2. Create from Selection 3. Top row

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.

1. Formula 2. Defined Names 3. Name Manager

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.

1. Formula 2. Name Manager 3. Edit

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

1. Help tab 2. F1 3. searching in the Tell Me bar

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

1. top row 3. Left column 5. Right column 6. Bottom row

What is unique about the date calculations from other formulas?

A. Some do not require any arguments.

What is the purpose of the Excel Function Reference?

A. to look up functions and their purposes

What is a benefit of the Name Manager feature?

A: add, edit, filter names you have created

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

B. =NOW()

What is the quick key to highlighting a column?

B: Ctrl + Shift + down arrow

What is a benefit of naming cells and ranges?

C: Using names in formulas makes it clearer to see what the function is.

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

D: Defined Names

Where should a range name be entered?

D: in the name box in the formula bar

Which part of the formula is the argument?

E. A1:E59