Google Sheets Test Google Sheet Expert 5 — Questions and Answers
Question 1: What does the INDEX function return when given a range, row, and column number?
- A count of cells
- The value at that position (Correct answer)
- The sum of the range
- The column header
Correct answer: The value at that position
INDEX returns the value located at the specified row and column within a range.
Question 2: Which function counts the total number of non-empty cells in a range?
- COUNT
- COUNTA (Correct answer)
- COUNTIF
- COUNTBLANK
Correct answer: COUNTA
COUNTA counts all non-empty cells, including text and numbers.
Question 3: What does the TRIM function do to a text value?
- Deletes the text
- Removes extra spaces (Correct answer)
- Capitalizes letters
- Reverses the string
Correct answer: Removes extra spaces
TRIM removes leading, trailing, and repeated spaces from text.
Question 4: Which function would you use to pull live data from another Google Sheet?
- IMPORTRANGE (Correct answer)
- IMPORTDATA
- IMPORTHTML
- GETDATA
Correct answer: IMPORTRANGE
IMPORTRANGE imports a range of cells from a specified external Google Sheet.
Question 5: What is the result of the formula =CONCATENATE("Go", "ogle")?
- Go ogle
- Google (Correct answer)
- Go ogle
Correct answer: Google
CONCATENATE joins the two strings directly to produce "Google".
Question 6: Which function returns the current date and time, updating automatically?
- TODAY
- NOW (Correct answer)
- DATE
- TIME
Correct answer: NOW
NOW returns the current date and time and recalculates on each update.
Question 7: What does a #REF! error typically indicate in a formula?
- A misspelled function
- An invalid or deleted cell reference (Correct answer)
- Division by zero
- A missing equals sign
Correct answer: An invalid or deleted cell reference
#REF! appears when a formula points to a cell reference that is invalid or has been deleted.
Google Sheets Test Google Sheet Expert 5
What does the INDEX function return when given a range, row, and column number?