Quiz: Excel Basics


1. What is a spreadsheet workbook?

A. An individual spreadsheet page
Incorrect. One or more spreadsheet pages are in a workbook.
B. A collection of spreadsheet pages
Correct. A workbook is a collection of spreadsheet pages.
C. A data cell within a spreadsheet
Incorrect. There are many data cells in a worksheet. Several worksheets are in a workbook.

2. What is a spreadsheet worksheet?

A. An individual spreadsheet page
Correct. A worksheet is an individual page in a workbook.
B. A collection of spreadsheet pages
Incorrect. A workbook is a collection of spreadsheet pages or worksheets.
C. A data cell within a spreadsheet
Incorrect. There are many data cells in a worksheet.

3. What is the symbol to create an absolute cell reference?

A. The hash symbol (#)
Incorrect. The $ sign before the row or column coordinates makes an absolute cell reference.
B. The dollar symbol ($)
Correct. The $ sign before the row or column coordinates makes an absolute cell reference.
C. An exclamation mark (!)
Incorrect. The $ sign before the row or column coordinates makes an absolute cell reference.

💬