Google Sheet Expert

Question 1

____ is the name of a single Google sheet.

Accepted Answer

Worksheet

Answer

Google Shareware

Answer

Workbook

Answer

Document

Question 2

Does Google Sheets automatically save changes?

Accepted Answer

Yes

Answer

No

Question 3

___ refers to a collection of cells in Google Sheets.

Accepted Answer

Cell range

Answer

Collection

Answer

Cells group

Answer

Multi cells

Question 4

Any formula begins with the symbol ___.

Accepted Answer

Equal (=)

Answer

Column (:)

Answer

Underscore (_)

Answer

Dollar ($)

Question 5

Columns in a Google sheet are denoted by ____.

Accepted Answer

Letters

Answer

Letters and Numbers

Answer

Cells

Answer

Numbers

Question 6

Which symbol is used in a spreadsheet cell reference to create an absolute reference (locking the row and/or column when copied)?

Accepted Answer

Dollar ($)

Answer

Equal (=)

Answer

Column (:)

Answer

Underscore (_)

Question 7

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

Accepted Answer

$B$11

Answer

$(B)11

Answer

"=B11"

Answer

$B11