Google Sheets Test Google Sheets Formulas and Basic Functions 2

Question 1

Which symbol must every formula in Google Sheets begin with?

Accepted Answer

=

Answer

All Google Sheets formulas start with an equals sign.

Question 2

What does =SUM(A1:A5) return?

Accepted Answer

The total of cells A1 through A5

Answer

SUM adds all numeric values in the specified range.

Question 3

Which function returns the number of cells in a range that contain numbers?

Accepted Answer

COUNT

Answer

COUNT counts only cells containing numeric values.

Question 4

What will =AVERAGE(2, 4, 6) return?

Accepted Answer

4

Answer

The average of 2, 4, and 6 is 12 divided by 3, which equals 4.

Question 5

Which function finds the highest value in a range?

Accepted Answer

MAX

Answer

MAX returns the largest number in the given range.

Google Sheets Test Practice Test