Google Sheets Test Google Sheet Expert 3

Question 1

Which function looks up a value and can search left or right, unlike VLOOKUP?

Accepted Answer

XLOOKUP

Answer

XLOOKUP can return values from a column on either side of the search column.

Question 2

What does the FILTER function return?

Accepted Answer

Rows that meet one or more conditions

Answer

FILTER returns all rows from a range that satisfy the given condition(s).

Question 3

Which symbol must every formula begin with in Google Sheets?

Accepted Answer

=

Answer

All formulas start with an equals sign to tell Sheets to calculate.

Question 4

What does the ARRAYFORMULA function allow you to do?

Accepted Answer

Apply a formula across an entire range at once

Answer

ARRAYFORMULA applies a single formula to a whole range, outputting an array of results.

Question 5

Which function removes duplicate rows from a range and returns only unique entries?

Accepted Answer

UNIQUE

Answer

UNIQUE returns the distinct rows of a range, discarding duplicates.

Google Sheets Test Practice Test