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

COUNTA

Answer

SUMIF

Answer

COUNT

Question 2

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

Accepted Answer

The first column

Answer

The last column

Answer

The active cell's column

Answer

Every column at once

Question 3

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

Accepted Answer

$A$1

Answer

A1

Answer

$A1

Answer

A$1

Question 4

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

Accepted Answer

TEXTJOIN

Answer

CONCAT

Answer

SPLIT

Answer

JOIN

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

Stops the spreadsheet

Answer

Deletes the cell

Answer

Repeats the formula

Question 6

Which keyboard shortcut inserts the current date into a cell in Google Sheets?

Accepted Answer

Ctrl+;

Answer

Ctrl+D

Answer

Ctrl+T

Answer

Ctrl+/

Question 7

What is the result of the formula =AVERAGE(2, 4, 6)?

Accepted Answer

4

Answer

12

Answer

6

Answer

3