Quiz 5 - Excel

What function in Excel totals all of the cells in a range?

• AVERAGE

• AutoSum

• COUNT

• MAX

Which function should be used to determine the mean value of a range of cells?

• MIN

• AVERAGE

• COUNT

• MAX

Which function should be used to calculate the number of nonblank cells in a worksheet?

• SUM

• COUNTA

• MIN

• MAX

What is the default selection for AutoSum in Excel?

• 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.

Which category of functions do the COUNT and MIN functions belong to?

• Text

• Statistical

• Financial

• Logical

The AVERAGE function calculates the average score of a group of students. (True/False)

• True

• False

The COUNT function returns the total number of cells in the selected range that contain both text and numbers. (True/False)

• True

• False

The MAX function returns the total of all cells in the selected range. (True/False)

• True

• False

The MIN function returns the smallest value in a range of cells. (True/False)

• True

• False

In a spreadsheet program, is it necessary to use the AutoSum button to enter a SUM function, or can it be typed manually in a cell? (True/False)

• True

• False