Google Sheets Test Google Sheet Expert 4

Question 1

Which feature highlights cells automatically based on rules you define?

Accepted Answer

Conditional formatting

Answer

Conditional formatting changes a cell's appearance when it meets defined conditions.

Question 2

What does the QUERY function use to retrieve and manipulate data?

Accepted Answer

A SQL-like language

Answer

QUERY uses a SQL-like query language to select, filter, and aggregate data.

Question 3

Which function converts a delimited text string into separate cells?

Accepted Answer

SPLIT

Answer

SPLIT divides text around a specified delimiter into multiple cells.

Question 4

What is the purpose of freezing a row in Google Sheets?

Accepted Answer

Keep it visible while scrolling

Answer

Freezing keeps header rows visible on screen as you scroll through data.

Question 5

Which function returns the position of an item within a range?

Accepted Answer

MATCH

Answer

MATCH returns the relative position of a searched value within a range.

Google Sheets Test Practice Test