MOS Excel Quiz 2

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 first 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 of cells.

• 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