5th Six Weeks Game

Which of the following is a function?

• =Average

• (C4:C10)

• =

• ()

Which function gives the lowest number?

• Max

• Min

• Median

• Average

Which function counts the cells containing numbers in a range of cells?

• =average

• =max

• =count

• =counta

Which function removes extra spaces in a cell?

• Concatenate

• Trim

• Lower

• Right

An identifying label assigned to a group of cells.

• Name Box

• Range Name

• Function

• Cell

Sorting is when arrange data in order by column headings.

• True

• False

A command that displays the formulas in a worksheet so you can check them.

• Scale

• Show Formulas

• Orientation

• Filter

To hide non-matching rows in a table or list of data according to criteria you specify.

• Sort

• Filter

• Scale

• Show Formulas

Total rows are placed below the table.

• True

• False

The fill handle is used to select cells not to copy.

• True

• False