Google Sheets Test Google Sheet Expert 2

Question 1

Which function returns the number of cells in a range that meet a single condition?

Accepted Answer

COUNTIF

Answer

COUNTIF counts cells in a range that satisfy one specified criterion.

Question 2

What does the VLOOKUP function search by default in its lookup range?

Accepted Answer

The first column

Answer

VLOOKUP always searches for the key in the first column of the specified range.

Question 3

To keep both a row and a column fixed when copying a formula, which reference is correct?

Accepted Answer

$A$1

Answer

Placing a dollar sign before both the column letter and row number creates a fully absolute reference.

Question 4

Which function joins text from multiple cells into one string with a chosen separator?

Accepted Answer

TEXTJOIN

Answer

TEXTJOIN combines text with a specified delimiter and can ignore empty cells.

Question 5

What does the IFERROR function do when its first argument evaluates to an error?

Accepted Answer

Returns the alternative value you provide

Answer

IFERROR returns your specified fallback value instead of showing the error.

Google Sheets Test Practice Test