Google Sheets Test

FREE Google Sheet Expert Questions and Answers

0%

Columns in a Google sheet are denoted by ____.

Correct! Wrong!

Correct Answer: Letters
Columns in Google Sheets are denoted by letters. As an illustration, the first column is A, the second is B, and so forth.

What is the appropriate dress code for a health club interview?

Correct! Wrong!

Correct Answer: Dollar ($)
The dollar sign ($) is used in the formula to use absolute reference.

Example: Absolute reference for row and column: $A$1

____ is the name of a single Google sheet.

Correct! Wrong!

Correct Answer: Worksheet
Worksheet is the name of a single Google sheet.

Does Google Sheets automatically save changes?

Correct! Wrong!

Correct Answer: Yes
Yes, the changes are automatically saved in the Google Sheet.

We use ____ to lock it if the tax (any value) reference is B11 and you do not want the fill function to change this.

Correct! Wrong!

Correct Answer: $B$11
This formula, $B$11, completely locks the reference.

Any formula begins with the symbol ___.

Correct! Wrong!

Correct Answer: Equal (=)
Formulas in Google Sheets always begin with the equal sign (=).

___ refers to a collection of cells in Google Sheets.

Correct! Wrong!

Correct Answer: Cell range
Cell range refers to the collection of cells in Google Sheets.

Related Post