Google Sheets Basics Quiz

What symbol do all formulas in Google Sheets begin with?

• $

• +

• =

• @

Answer explanation

All formulas in Google Sheets start with the '=' symbol, indicating that the following text is a formula. The other options do not serve this purpose.

What is a cell reference?

• A way to name text

• A way to name a cell using its column and row

• A formula

• A math function

Answer explanation

A cell reference identifies a specific cell in a spreadsheet by combining its column letter and row number, such as A1. This allows users to easily locate and manipulate data within the spreadsheet.

What is the reference for the top-left cell in a Google Sheet?

• A0

• A1

• 1A

• Cell A

Answer explanation

The top-left cell in a Google Sheet is referenced as A1. In spreadsheet terminology, columns are labeled with letters and rows with numbers, making A1 the correct reference for the first cell.

What is a range in Google Sheets?

• A cell’s name

• A function

• A group of adjacent cells

• A math operator

Answer explanation

In Google Sheets, a range refers to a group of adjacent cells. This allows users to perform operations on multiple cells at once, making data management more efficient.

How is a range written?

• A1,A2,A3

• A1:A2

• Range(A1-A2)

• A1::A2

Answer explanation

A range is written using a colon to separate the start and end points, as in A1:A2. This indicates all cells from A1 to A2. The other options do not represent a valid range format.

What is the range for the rectangle from cell A1 to B2?

• A1:B2

• A1-A2-B1-B2

• A1, B2

• A1:B1

Answer explanation

The range for a rectangle defined by two corners is given by the top-left corner to the bottom-right corner. In this case, A1 is the top-left and B2 is the bottom-right, making the correct range A1:B2.

What function adds up numbers or ranges?

• =ADD

• =TOTAL

• =SUM

• =PLUS

Answer explanation

The correct function to add up numbers or ranges in spreadsheets is =SUM. The other options, =ADD, =TOTAL, and =PLUS, are not valid functions for this purpose.

What is the result of =SUM(2, 3, 4)?

• 7

• 8

• 9

• 10

Answer explanation

The formula =SUM(2, 3, 4) adds the numbers 2, 3, and 4 together. Calculating this gives 2 + 3 + 4 = 9. Therefore, the correct answer is 9.

What happens if you type A1,A2,A3 without a function?

• It works

• It adds them

• It gives a #VALUE! error

• It gives a #ERROR!

Answer explanation

Typing A1,A2,A3 without a function results in a #VALUE! error because the system cannot interpret the input as a valid formula or operation. Therefore, the correct answer is that it gives a #VALUE! error.

What data type is TRUE or FALSE?

• Text

• Logic

• Boolean

• Numeric

Answer explanation

The correct answer is 'Boolean' because TRUE and FALSE represent binary values, which are the essence of Boolean data types. They are used in logic operations and programming to denote truth values.