Excel Chapter 5

What does the SUM function do?

• finds the total of the closest four cells

• totals all of the cells in the selected range

• the sum function adds and subtracts cell values

• counts the number of cells selected

What does the COUNT function do?

• counts the number of cells in a range

• counts the numbers in the cell

• totals all of the cells in the selected range

• counts the number of cells in a range that contain a number

What does the AVERAGE function do?

• Finds the average of the selected numbers

• Finds the average of dollar values only

• Finds the average of percentages only

• Finds the average of the entire worksheet

If you wanted to find the smallest number in a range of cells what function would you use?

• MIN

• MAX

• AVERAGE

• COUNTA

If you wanted to find the largest number in a range of cells what function would you use?

• MIN

• MAX

• AVERAGE

• COUNTA

If you want to add a range of cells and then divide by the number of cell entries, determine the mean value of all values in the range which function should you use?

• MIN

• MAX

• AVERAGE

• COUNTA

If you want to determine the number of non-blank cells in your worksheet which function should you use?

• MIN

• MAX

• AVERAGE

• COUNTA

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

• Text

• Statistical

• Financial

• Logical

If you want to know the number of empty cells in a range the function you should use is:

• COUNTA

• COUNTB

• COUNTC

• COUNTBLANK

Why is it beneficial to use a function instead of typing the math equation in the formula bar?

• If the data points change, a formula will automatically adjust the answer

• Excel only recognizes formulas, not math equations

• There are no benefits

• Both ways always result in the same answers