Excel Functions - Statistical, Mathematical calculations, Round

Which of the following functions calculates the sum of a range of values?

• =AVERAGE(range)

• =SUM(range)

• =MAX(range)

• =COUNT(range)

What is the result of the function =MEDIAN(range)?

• The smallest value in a range

• The middle value when the range is arranged from smallest to largest

• The largest value in a range

• The most frequent value in the range

Which function would you use to find the N-th largest value in a range of numbers?

• =LARGE(range, N)

• =MODE(range)

• =SMALL(range, N)

• =MAX(range)

Which function returns the number of cells in a range that contain text or numerical data, excluding empty cells?

• =COUNTBLANK(range)

• =COUNTA(range)

• =COUNT(range)

• =SUM(range)

What does the =RANDBETWEEN(bottom, top) function do?

• Generates a random value between 0 and 1

• Returns a random whole number between the specified bottom and top values

• Generates a random decimal between 0 and 1

• Returns a random value between two specified text values

Which of the following will always round a number DOWN to the nearest integer, no matter what the decimal is?

• =ROUND(value, N)

• =ROUNDUP(value, N)

• =ROUNDDOWN(value, N)

• =INT(value)

What is the purpose of the =TRUNC(value, N) function?

• To round the value to the nearest whole number

• To round the value down to the nearest whole number

• To remove numbers beyond the N-th decimal without rounding

• To round the value up to the nearest whole number

If you want to find the mode of a range (the value that appears most often), which function would you use?

• =MAX(range)

• =MODE(range)

• =MEDIAN(range)

• =SUM(range)

Which function would return a random decimal number between 0 and 1?

• =RANDBETWEEN(bottom, top)

• =RAND()

• =POWER(value, exponent)

• =COUNTBLANK(range)

What does the =INT(value) function do?

• Rounds the value to the nearest whole number

• Rounds the value to the next integer

• Truncates the value to the nearest decimal

• Removes the decimal part and returns the integer portion of the value