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.

____ is the name of a single Google sheet.

Correct! Wrong!

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

___ 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.

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.

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

Any formula begins with the symbol ___.

Correct! Wrong!

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