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

INDEX returns the value located at the specified row and column within a range.

Question 2

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

Accepted Answer

COUNTA

Answer

COUNTA counts all non-empty cells, including text and numbers.

Question 3

What does the TRIM function do to a text value?

Accepted Answer

Removes extra spaces

Answer

TRIM removes leading, trailing, and repeated spaces from text.

Question 4

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

Accepted Answer

IMPORTRANGE

Answer

IMPORTRANGE imports a range of cells from a specified external Google Sheet.

Question 5

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

Accepted Answer

Google

Answer

CONCATENATE joins the two strings directly to produce "Google".

Google Sheets Test Practice Test