CGS Excel Chapter 3

An example of the AVERAGE function is ____.

=AVERAGE(B3:D3)

An example of a valid concatenate formula is ______.

=CONTACT(B2, " ",A2)

An accurate IF function is _____.

=IF(C2>D2, "no", "yes")

An example of a MIN statistical function formula is ____.

=MIN (B4:H8)

An example of the NOW function is _____.

=NOW()

An accurate example of a PMT function is ____.

=PMT(4%/12,36,2500)

A formula using the TODAY function looks like ____.

=TODAY()

Every function in Excel can be entered using its ___dialog.

Function Arguments

If you are not sure of the name of the function you want, open the _____ dialog and type keywords describing the function in the Search for and click go.

Insert Function

Excel displays a ____ to help you resolve errors.

Smart Tag

COUNT,COUNTA,COUNTBLANK are three basic counting functions in Excel.

True

Both the NOW and Today functions use the date and time from your ____.

computers clock

A ____ is the cell containing a formula that references the value or formula in the selected cell.

dependent

#DIV/0 is an example of a worksheet _____ that can display in a cell.

error

Cell references like A4 and B34 provide much information about that data contained in the cell.

false

Formula AutoComplete is the long method for entering functions.

false

Formula AutoComplete is a shortcut for entering ___.

functions

Excel will automatically create _____ ranges for the groups of cells associated with each label in a table format.

named

Cell references do not always provide much information about what data the cell contains; only the location in the worksheet. You can assign ____ to cells to makes the cells more user-friendly.

names

COUNTBLANK accepts ____.

only a single argument.

A ____ is the cell containing the formula or value the selected cell refers to.

precedent

A named range refers to a _____ in your formula.

range of cells

Functions can do more than perform calculations. Excel includes a special group of functions to modify _____.

text

Cells that include potential errors are marked with a green _____.

triangle

Because names may not include spaces, Excel will replace the spaces with ___ characters if you use the Create Names from Selection command.

underscore