Google Sheets Test Google Sheet Expert 2 — Questions and Answers
Question 1: Which function returns the number of cells in a range that meet a single condition?
- COUNTIF (Correct answer)
- COUNTA
- SUMIF
- COUNT
Correct answer: COUNTIF
COUNTIF counts cells in a range that satisfy one specified criterion.
Question 2: What does the VLOOKUP function search by default in its lookup range?
- The last column
- The first column (Correct answer)
- The active cell's column
- Every column at once
Correct answer: The first column
VLOOKUP always searches for the key in the first column of the specified range.
Question 3: To keep both a row and a column fixed when copying a formula, which reference is correct?
- A1
- $A1
- A$1
- $A$1 (Correct answer)
Correct answer: $A$1
Placing a dollar sign before both the column letter and row number creates a fully absolute reference.
Question 4: Which function joins text from multiple cells into one string with a chosen separator?
- CONCAT
- TEXTJOIN (Correct answer)
- SPLIT
- JOIN
Correct answer: TEXTJOIN
TEXTJOIN combines text with a specified delimiter and can ignore empty cells.
Question 5: What does the IFERROR function do when its first argument evaluates to an error?
- Stops the spreadsheet
- Returns the alternative value you provide (Correct answer)
- Deletes the cell
- Repeats the formula
Correct answer: Returns the alternative value you provide
IFERROR returns your specified fallback value instead of showing the error.
Question 6: Which keyboard shortcut inserts the current date into a cell in Google Sheets?
- Ctrl+; (Correct answer)
- Ctrl+D
- Ctrl+T
- Ctrl+/
Correct answer: Ctrl+;
Ctrl+; (semicolon) inserts today's static date into the selected cell.
Question 7: What is the result of the formula =AVERAGE(2, 4, 6)?
- 12
- 6
- 4 (Correct answer)
- 3
Correct answer: 4
The average of 2, 4, and 6 is 12 divided by 3, which equals 4.
Google Sheets Test Google Sheet Expert 2
Which function returns the number of cells in a range that meet a single condition?