Google Sheets Test Google Sheets Formulas and Basic Functions 4

Question 1

Which function looks up a value in the first column of a range and returns a value from another column?

Accepted Answer

VLOOKUP

Answer

VLOOKUP searches vertically down the first column and returns a value from a specified column.

Question 2

In =VLOOKUP(D2, A2:B10, 2, FALSE), what does FALSE specify?

Accepted Answer

An exact match is required

Answer

FALSE tells VLOOKUP to find an exact match rather than an approximate one.

Question 3

What does the CONCATENATE function do?

Accepted Answer

Joins multiple text strings into one

Answer

CONCATENATE combines several strings into a single text value.

Question 4

Which function removes extra spaces from text, leaving single spaces between words?

Accepted Answer

TRIM

Answer

TRIM strips leading, trailing, and duplicate internal spaces.

Question 5

What does =TODAY() return?

Accepted Answer

The current date

Answer

TODAY returns the current date and updates automatically.

Google Sheets Test Practice Test