Excel Chapter 5

Front

What does the SUM function do?

Back

totals all of the cells in the selected range

Front

What does the COUNT function do?

Back

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

Front

What does the AVERAGE function do?

Back

Finds the average of the selected numbers

Front

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

Back

MIN

Front

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

Back

MAX

Front

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?

Back

AVERAGE

Front

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

Back

COUNTA

Front

The COUNT and MIN functions are examples of which category of functions? Options: Text, Statistical, Financial, Logical

Back

Statistical

Front

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

Back

COUNTBLANK

Front

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

Back

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