Excel Lessons 5 & 6

1.  Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?

• AVERAGE
• AutoSum
• COUNT
• MAX

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?

• MIN
• AVERAGE
• COUNT
• MAX

You want to calculate the number of nonblank cells in your worksheet. Which function should be used?

• SUM
• COUNTA
• MIN
• MAX

Which of the following statements accurately describes the default selection for AutoSum?

• You must make the selection before clicking AutoSum.
• By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content.
• By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.
• AutoSum does not have a default selection.

The COUNT and MIN functions are examples of which category of functions?

• text
• statistical
• financial
• logical

The AVERAGE function returns the mean value in a range of selected cells.

• True
• False

The COUNT function returns the total number of cells in the selected range that contain both text and numbers.

• True
• False

The MAX function returns the total of all cells in the selected range.

• True
• False

The MIN function returns the smallest value in a range of cells.

• True
• False

You must use the AutoSum button to enter a SUM function—you cannot type it manually in a cell.

• True
• False