Google Sheets Test Google Sheets Formulas and Basic Functions 2 — Questions and Answers
Question 1: Which symbol must every formula in Google Sheets begin with?
- = (Correct answer)
- +
- @
- #
Correct answer: =
All Google Sheets formulas start with an equals sign.
Question 2: What does =SUM(A1:A5) return?
- The total of cells A1 through A5 (Correct answer)
- The count of non-empty cells
- The largest value in the range
- The average of the range
Correct answer: The total of cells A1 through A5
SUM adds all numeric values in the specified range.
Question 3: Which function returns the number of cells in a range that contain numbers?
- COUNT (Correct answer)
- COUNTA
- SUM
- TOTAL
Correct answer: COUNT
COUNT counts only cells containing numeric values.
Question 4: What will =AVERAGE(2, 4, 6) return?
- 4 (Correct answer)
- 12
- 6
- 3
Correct answer: 4
The average of 2, 4, and 6 is 12 divided by 3, which equals 4.
Question 5: Which function finds the highest value in a range?
- MAX (Correct answer)
- TOP
- HIGH
- LARGEST
Correct answer: MAX
MAX returns the largest number in the given range.
Question 6: What does the & operator do in a formula?
- Joins (concatenates) text values (Correct answer)
- Adds two numbers
- Compares two values
- Divides values
Correct answer: Joins (concatenates) text values
The ampersand concatenates strings, such as =A1&" "&B1.
Question 7: Which function counts the number of non-empty cells in a range regardless of type?
- COUNTA (Correct answer)
- COUNT
- COUNTIF
- SUM
Correct answer: COUNTA
COUNTA counts every cell that is not empty, including text.
Google Sheets Test Google Sheets Formulas and Basic Functions 2
Which symbol must every formula in Google Sheets begin with?