Google Sheets Test Google Sheet Expert 3 — Questions and Answers
Question 1: Which function looks up a value and can search left or right, unlike VLOOKUP?
- HLOOKUP
- XLOOKUP (Correct answer)
- MATCH
- LOOKUP
Correct answer: XLOOKUP
XLOOKUP can return values from a column on either side of the search column.
Question 2: What does the FILTER function return?
- Only the first matching row
- Rows that meet one or more conditions (Correct answer)
- A sorted copy of the range
- The count of matches
Correct answer: Rows that meet one or more conditions
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?
- +
- = (Correct answer)
- @
- #
Correct answer: =
All formulas start with an equals sign to tell Sheets to calculate.
Question 4: What does the ARRAYFORMULA function allow you to do?
- Sort an array
- Apply a formula across an entire range at once (Correct answer)
- Delete duplicate rows
- Freeze array columns
Correct answer: Apply a formula across an entire range at once
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?
- UNIQUE (Correct answer)
- DISTINCT
- DEDUPE
- TRIM
Correct answer: UNIQUE
UNIQUE returns the distinct rows of a range, discarding duplicates.
Question 6: What does SUMIF do that SUM does not?
- Adds numbers faster
- Adds only values meeting a condition (Correct answer)
- Rounds the total
- Averages the values
Correct answer: Adds only values meeting a condition
SUMIF totals only the cells that satisfy a specified criterion.
Question 7: In the formula =IF(A1>10, "High", "Low"), what appears if A1 contains 5?
- High
- Low (Correct answer)
- 5
- An error
Correct answer: Low
Since 5 is not greater than 10, the condition is false and IF returns "Low".
Google Sheets Test Google Sheet Expert 3
Which function looks up a value and can search left or right, unlike VLOOKUP?