Google Sheets Test Google Sheet Expert 4

Question 1

Which feature highlights cells automatically based on rules you define?

Accepted Answer

Conditional formatting

Answer

Data validation

Answer

Named ranges

Answer

Protected ranges

Question 2

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

Accepted Answer

A SQL-like language

Answer

Regular expressions

Answer

Python scripts

Answer

Pivot syntax

Question 3

Which function converts a delimited text string into separate cells?

Accepted Answer

SPLIT

Answer

TEXTJOIN

Answer

CONCAT

Answer

SUBSTITUTE

Question 4

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

Accepted Answer

Keep it visible while scrolling

Answer

Prevent editing the row

Answer

Hide the row

Answer

Lock its formulas

Question 5

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

Accepted Answer

MATCH

Answer

INDEX

Answer

OFFSET

Answer

ROW

Question 6

What does the ROUND function =ROUND(3.14159, 2) return?

Accepted Answer

3.14

Answer

3.1

Answer

3.142

Answer

3

Question 7

Which menu lets you restrict what values a user can enter in a cell?

Accepted Answer

Data validation

Answer

Format menu

Answer

Insert menu

Answer

View menu