Question 1

What formula is used to add up a range of cells in Google Sheets?

Accepted Answer

SUM

Answer

PLUS

Answer

TOTAL

Answer

ADD

Question 2

What formula is used to find the average of a range of cells in Google Sheets?

Accepted Answer

AVERAGE

Answer

MEAN

Answer

MODE

Answer

MEDIAN

Question 3

What formula is used to multiply a range of cells in Google Sheets?

Accepted Answer

PRODUCT

Answer

TIMES

Answer

X

Answer

MULTIPLY

Question 4

What formula is used to divide a range of cells in Google Sheets?

Accepted Answer

QUOTIENT

Answer

RATIO

Answer

FRACTION

Answer

DIVIDE

Question 5

What formula is used to find the maximum value in a range of cells in Google Sheets?

Accepted Answer

MAX

Answer

HIGHEST

Answer

PEAK

Answer

TOP

Question 6

What formula is used to find the minimum value in a range of cells in Google Sheets?

Accepted Answer

MIN

Answer

BOTTOM

Answer

SMALLEST

Answer

LOWEST

Question 7

What formula is used to count the number of cells in a range that contain a specific value in Google Sheets?

Accepted Answer

COUNTIF

Answer

HAS

Answer

HASVALUE

Answer

INCLUDES

Question 8

What formula is used to count the number of cells in a range that meet multiple specified conditions in Google Sheets?

Accepted Answer

COUNTIFS

Answer

COUNTMANY

Answer

COUNT

Answer

MULTIPLECOUNT

Question 9

What formula is used to calculate the percentage of a total in Google Sheets?

Accepted Answer

PERCENTAGE

Answer

PORTION

Answer

FRACTION

Answer

RATIO

Question 10

What formula is used to concatenate two or more strings in Google Sheets?

Accepted Answer

CONCATENATE

Answer

JOIN

Answer

MERGE

Answer

COMBINE

Related quizzes

Related quizzes