Google Sheets Test Google Sheets Syntax 4

Question 1

Which function syntax correctly looks up a value: VLOOKUP(search_key, range, index, [is_sorted])?

Accepted Answer

VLOOKUP(search_key, range, index, is_sorted)

Answer

VLOOKUP takes the search key first, then the range, the column index, and an optional sort flag.

Question 2

What does the # in a spilled reference like A1# indicate in newer Sheets syntax?

Accepted Answer

It refers to the entire spilled array range

Answer

The hash after a cell reference points to the whole array that spilled from it.

Question 3

In an IF statement IF(logical_expression, value_if_true, value_if_false), what is the second argument?

Accepted Answer

The value returned when the condition is true

Answer

The second argument is the result returned if the logical test evaluates to true.

Question 4

Which syntax correctly uses a wildcard to match any characters in functions like COUNTIF?

Accepted Answer

An asterisk *

Answer

The asterisk acts as a wildcard matching any sequence of characters.

Question 5

How do you escape a literal wildcard character so it is treated as plain text?

Accepted Answer

Precede it with a tilde ~

Answer

A tilde before a wildcard tells Sheets to treat it literally.

Google Sheets Test Practice Test