Google Sheets I: Unit 1 Quiz

How would you MOVE a row without overwriting any other part of the spreadsheet?

• Cut the row and paste it at the desired location.

• Click on the row and drag it at the desired location.

• Copy the row and paste it at the desired location.

Answer explanation

To move a row without overwriting, click on the row and drag it to the desired location. This method allows you to reposition the row seamlessly, unlike cutting or copying, which can lead to overwriting or duplicating data.

Which method is best for selecting the cells highlighted in red?

• Click and drag the mouse to select the cells.

• Press the Shift key and click on the cells.

• Press the Ctrl key and click on the cells.

• Press the Alt key and click on the cells.

Answer explanation

Clicking and dragging the mouse allows you to easily select multiple adjacent cells highlighted in red. This method is efficient for selecting a range, unlike the other options which are better for non-adjacent selections.

Which method is best for selecting the cells highlighted in red?

• Press the Ctrl key and click on the cells.

• Click and drag the mouse to select the cells.

• Press the Shift key and click on the cells.

• Press the Alt key and click on the cells.

Answer explanation

Pressing the Ctrl key while clicking allows you to select multiple non-adjacent cells, making it the best method for selecting the highlighted red cells without affecting others.

In a spreadsheet, what is the currently selected cell called?

• The active cell

• The chosen cell

• The blue cell

• The outlined cell

Answer explanation

The currently selected cell in a spreadsheet is called the active cell. It is highlighted to indicate that it is ready for data entry or editing, distinguishing it from other cells.

Where would you click to select a column?

• A

• B

• C

• D

Answer explanation

To select a column, you would click on the header of that column. In this case, option C represents the correct column header to click on.

Which letter on the image is a Row?

• A

• B

• C

• D

Answer explanation

In the image, a row is typically represented horizontally. The letter C is positioned horizontally, indicating it is the row, while A, B, and D are not aligned in that manner.

Which letter on the image is a Column?

• A

• B

• C

• D

Answer explanation

The correct answer is D, as it represents the Column in the image. Columns are typically vertical structures, and D is the only option that fits this description.

Which Menu tab would you use to access the command to clear a cell's format?

• File

• Edit

• Format

• View

Answer explanation

To clear a cell's format, you would use the 'Format' menu tab. This tab contains options related to cell formatting, making it the correct choice for accessing the command to clear formats.

What is the address of the indicated cell?

• B4

• 4B

• C4

• B5

Answer explanation

The address of a cell in a spreadsheet is denoted by a letter followed by a number. In this case, 'B4' correctly indicates column B and row 4, making it the correct answer. The other options do not follow this format.

Which letter on the image is a Cell?

• A

• B

• C

• D

Answer explanation

The letter B represents a Cell in the image, as it is labeled and visually distinct from the other letters, which do not correspond to cellular structures.