Google Sheets Test Google Sheets Statistical Functions

Question 1

Which function calculates the arithmetic average of a range of numbers in Google Sheets?

Accepted Answer

AVERAGE

Answer

SUM

Answer

MEAN

Answer

AVG

Question 2

Which function counts only cells containing numeric values in a range?

Accepted Answer

COUNT

Answer

COUNTA

Answer

COUNTIF

Answer

COUNTBLANK

Question 3

What does the MEDIAN function return for a dataset?

Accepted Answer

The middle value when data is sorted in order

Answer

The most frequently occurring value

Answer

The arithmetic mean of all values

Answer

The sum divided by the count

Question 4

Which Google Sheets function returns the most frequently occurring value in a dataset?

Accepted Answer

MODE

Answer

MEDIAN

Answer

AVERAGE

Answer

MAX

Question 5

Which function returns the largest value in a given range?

Accepted Answer

MAX

Answer

HIGH

Answer

LARGE

Answer

TOP

Question 6

Which function returns the smallest value in a given range?

Accepted Answer

MIN

Answer

MINIMUM

Answer

LOW

Answer

SMALL

Question 7

Which function counts all non-empty cells in a range, including cells containing text?

Accepted Answer

COUNTA

Answer

COUNT

Answer

COUNTBLANK

Answer

COUNTIF