Google Sheet Expert Flashcards
7 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Google Sheet Expert flashcards as text
Which function looks up a value and can search left or right, unlike VLOOKUP?
Answer: XLOOKUP
XLOOKUP can return values from a column on either side of the search column.
What does the FILTER function return?
Answer: Rows that meet one or more conditions
FILTER returns all rows from a range that satisfy the given condition(s).
Which symbol must every formula begin with in Google Sheets?
Answer: =
All formulas start with an equals sign to tell Sheets to calculate.
What does the ARRAYFORMULA function allow you to do?
Answer: Apply a formula across an entire range at once
ARRAYFORMULA applies a single formula to a whole range, outputting an array of results.
Which function removes duplicate rows from a range and returns only unique entries?
Answer: UNIQUE
UNIQUE returns the distinct rows of a range, discarding duplicates.
What does SUMIF do that SUM does not?
Answer: Adds only values meeting a condition
SUMIF totals only the cells that satisfy a specified criterion.
In the formula =IF(A1>10, "High", "Low"), what appears if A1 contains 5?
Answer: Low
Since 5 is not greater than 10, the condition is false and IF returns "Low".
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy