Excel Functions Quiz

What function would you use to find the average of a range?

• =min()

• =count()

• =average()

• =sum()

Which function returns the current date?

• =now()

• =mode()

• =today()

• =randbetween()

What does the function =countif() do?

• Counts the total number of cells

• Counts the number of blank cells

• Counts the number of cells in a range given a certain criteria

• Counts the number of cells that are not empty

Which function would you use to get the largest value in a range?

• =countblank()

• =small()

• =median()

• =max()

What does the function =randbetween() return?

• A random date

• A random number between the values entered

• The current time

• The smallest value in a range

Which function would you use to count the number of non-empty cells in a range?

• =count()

• =countif()

• =countblank()

• =sum()

Which function counts the amount of empty cells in a range?

• =count()

• =counta()

• =countblank()

• =countempty()