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

HLOOKUP

Answer

MATCH

Answer

LOOKUP

Question 2

What does the FILTER function return?

Accepted Answer

Rows that meet one or more conditions

Answer

Only the first matching row

Answer

A sorted copy of the range

Answer

The count of matches

Question 3

Which symbol must every formula begin with in Google Sheets?

Accepted Answer

=

Answer

+

Answer

@

Answer

#

Question 4

What does the ARRAYFORMULA function allow you to do?

Accepted Answer

Apply a formula across an entire range at once

Answer

Sort an array

Answer

Delete duplicate rows

Answer

Freeze array columns

Question 5

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

Accepted Answer

UNIQUE

Answer

DISTINCT

Answer

DEDUPE

Answer

TRIM

Question 6

What does SUMIF do that SUM does not?

Accepted Answer

Adds only values meeting a condition

Answer

Adds numbers faster

Answer

Rounds the total

Answer

Averages the values

Question 7

In the formula =IF(A1>10, "High", "Low"), what appears if A1 contains 5?

Accepted Answer

Low

Answer

High

Answer

5

Answer

An error