Google Sheet Expert 1 — Questions and Answers

Question 1: ____ is the name of a single Google sheet.

Google Shareware
Worksheet (Correct answer)
Workbook
Document

Correct answer: Worksheet

In Google Sheets, a 'worksheet' refers to a single page or tab within a larger spreadsheet file. A 'workbook' is the entire file containing one or more worksheets, while 'Google Shareware' and 'Document' are incorrect terms in this context. Therefore, 'worksheet' is the precise term for an individual sheet.

Question 2: Does Google Sheets automatically save changes?

Yes (Correct answer)
No

Correct answer: Yes

Google Sheets, like other Google Workspace applications, features automatic saving. All changes made to a sheet are continuously saved to Google Drive in real-time. This eliminates the need for users to manually click a save button, ensuring work is never lost.

Question 3: ___ refers to a collection of cells in Google Sheets.

Collection
Cell range (Correct answer)
Cells group
Multi cells

Correct answer: Cell range

A 'cell range' is the correct term used in spreadsheet applications like Google Sheets to describe a contiguous group of selected cells. It is typically denoted by the starting and ending cell references, such as A1:B5. This allows users to apply operations or formulas to multiple cells simultaneously.

Question 4: Any formula begins with the symbol ___.

Equal (=) (Correct answer)
Column (:)
Underscore (_)
Dollar ($)

Correct answer: Equal (=)

In Google Sheets, as with most spreadsheet programs, all formulas must begin with an equal sign (=). This symbol signals to the software that the input is a calculation or function, rather than plain text or a number. Without the equal sign, the spreadsheet would treat the entry as literal text.

Question 5: Columns in a Google sheet are denoted by ____.

Letters and Numbers
Cells
Numbers
Letters (Correct answer)

Correct answer: Letters

Columns in Google Sheets are uniquely identified by letters of the alphabet, starting with A, B, C, and so on. When the alphabet is exhausted (Z), it continues with two-letter combinations like AA, AB, AC, etc. Rows, conversely, are denoted by 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)?

Equal (=)
Column (:)
Underscore (_)
Dollar ($) (Correct answer)

Correct answer: Dollar ($)

The dollar sign ($) is used in spreadsheet cell references to create an absolute reference. Placing a dollar sign before the column letter (e.g., $A1) locks the column, and placing it before the row number (e.g., A$1) locks the row. Using both ($A$1) locks both the column and the row, preventing them from changing when the formula is copied to other cells.

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.

$(B)11
"=B11"
$B$11 (Correct answer)
$B11

Correct answer: $B$11

To create an absolute reference that completely locks both the column and the row, a dollar sign ($) must precede both the column letter and the row number. This ensures that when the formula is copied or filled to other cells, the reference to B11 remains fixed. Therefore, $B$11 is the correct syntax to prevent the fill function from changing the reference.

Google Sheet Expert 1

____ is the name of a single Google sheet.