Google Sheets Formula 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 Sheets Formula flashcards as text
What does =AVERAGEIF(A1:A10,">50") calculate?
Answer: The average of values greater than 50
AVERAGEIF averages only the cells meeting the criterion.
Which formula returns the number of non-empty cells in A1:A100?
Answer: =COUNTA(A1:A100)
COUNTA counts all non-empty cells, including text.
What does =LEFT("Google",3) return?
Answer: Goo
LEFT extracts the first 3 characters from the text.
Which function removes extra spaces from a text string?
Answer: =TRIM(A1)
TRIM removes leading, trailing, and duplicate spaces.
What does =LEN(A1) return?
Answer: The number of characters in A1
LEN returns the length (character count) of the text.
Which formula converts text in A1 to all uppercase letters?
Answer: =UPPER(A1)
UPPER converts every letter in the text to uppercase.
What does =SUBSTITUTE("2023-2024","-","/") return?
Answer: 2023/2024
SUBSTITUTE replaces each hyphen with a slash.
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