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 feature highlights cells automatically based on rules you define?
Answer: Conditional formatting
Conditional formatting changes a cell's appearance when it meets defined conditions.
What does the QUERY function use to retrieve and manipulate data?
Answer: A SQL-like language
QUERY uses a SQL-like query language to select, filter, and aggregate data.
Which function converts a delimited text string into separate cells?
Answer: SPLIT
SPLIT divides text around a specified delimiter into multiple cells.
What is the purpose of freezing a row in Google Sheets?
Answer: Keep it visible while scrolling
Freezing keeps header rows visible on screen as you scroll through data.
Which function returns the position of an item within a range?
Answer: MATCH
MATCH returns the relative position of a searched value within a range.
What does the ROUND function =ROUND(3.14159, 2) return?
Answer: 3.14
Rounding 3.14159 to two decimal places gives 3.14.
Which menu lets you restrict what values a user can enter in a cell?
Answer: Data validation
Data validation defines rules controlling which entries are allowed in a cell.
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