Google Sheet Expert

Question 1

____ is the name of a single Google sheet.

Accepted Answer

Worksheet

Answer

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?

Accepted Answer

Yes

Answer

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.

Accepted Answer

Cell range

Answer

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

Accepted Answer

Equal (=)

Answer

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

Accepted Answer

Letters

Answer

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.

Google Sheets Test Practice Test

Google Sheets Test Practice Test

Google Sheet Expert