Google Sheets Test Google Sheet Expert 5

Question 1

What does the INDEX function return when given a range, row, and column number?

Accepted Answer

The value at that position

Answer

A count of cells

Answer

The sum of the range

Answer

The column header

Question 2

Which function counts the total number of non-empty cells in a range?

Accepted Answer

COUNTA

Answer

COUNT

Answer

COUNTIF

Answer

COUNTBLANK

Question 3

What does the TRIM function do to a text value?

Accepted Answer

Removes extra spaces

Answer

Deletes the text

Answer

Capitalizes letters

Answer

Reverses the string

Question 4

Which function would you use to pull live data from another Google Sheet?

Accepted Answer

IMPORTRANGE

Answer

IMPORTDATA

Answer

IMPORTHTML

Answer

GETDATA

Question 5

What is the result of the formula =CONCATENATE("Go", "ogle")?

Accepted Answer

Google

Answer

Go ogle

Answer

Go ogle

Answer

GOOGLE

Question 6

Which function returns the current date and time, updating automatically?

Accepted Answer

NOW

Answer

TODAY

Answer

DATE

Answer

TIME

Question 7

What does a #REF! error typically indicate in a formula?

Accepted Answer

An invalid or deleted cell reference

Answer

A misspelled function

Answer

Division by zero

Answer

A missing equals sign