Spreadsheet Basics Quiz

The reference to a specific cell in a spreadsheet is called a ________.

• cell reference

• cell locator

• cell identifier

• cell marker

The name of the worksheet appears on the ________ tab at the bottom of the screen.

• sheet

• file

• edit

• view

The cell that is currently highlighted or selected is called the ________ cell.

• active

• inactive

• selected

• highlighted

To enter data into a spreadsheet, you must first click on the ________ cell.

• active

• inactive

• last

• first

The ________ of a worksheet helps users quickly identify the content or purpose of the sheet.

• title

• footer

• margin

• border

To refer to a cell in column C, row 5, you would write the cell reference as ________.

• C5

• 5C

• C-5

• 5-C

If you want to rename a worksheet, you need to ________ on the worksheet tab and select “Rename.”

• right-click

• double-click

• hover

• drag

To select a group of cells from A1 to D4, you would use the range ________ to ________.

• A1:D4

• A1:B2

• B1:D4

• A2:D3

An absolute cell reference in Excel uses the symbol ________ before the column and row.

• $

• #

• &

• %

When managing large datasets, it is helpful to divide the data into multiple ________, each with a meaningful name.

• worksheets

• pages

• sections

• chapters