Google Sheets Test Google Sheets Formula 5

Question 1

What does the ARRAYFORMULA function allow you to do?

Accepted Answer

Apply a formula across an entire range at once

Answer

ARRAYFORMULA processes a range and returns results across multiple cells.

Question 2

Which function pulls live data from another Google Sheet by its URL?

Accepted Answer

=IMPORTRANGE(url, range)

Answer

IMPORTRANGE imports a specified range from another spreadsheet.

Question 3

What does =QUERY(A1:C10,"SELECT A WHERE B > 100") do?

Accepted Answer

Returns column A rows where column B exceeds 100

Answer

QUERY uses SQL-like syntax to filter and return matching data.

Question 4

Which formula splits "a,b,c" into separate cells by the comma?

Accepted Answer

=SPLIT("a,b,c",",")

Answer

SPLIT divides text into separate cells using the given delimiter.

Question 5

What does =TEXTJOIN("-",TRUE,A1:A3) return if the cells hold 1, blank, 3?

Accepted Answer

1-3

Answer

With TRUE, TEXTJOIN ignores empty cells, joining 1 and 3 with a hyphen.

Google Sheets Test Practice Test