Excel Vocabulary

What is the difference between a workbook and a worksheet?

• A worksheet is a spreadsheet file and a workbook is a page within excel.

• A worksheet is a type of spreadsheet file and a workbook isn't.

• A workbook is a spreadsheet file and a worksheet is contained within a workbook.

• None of the above

Which of the following is true about sheet tabs?

• they are located at the top of a workbook file

• they cannot be renamed

• they represent the worksheets within the workbook

• they represent the workbook within the worksheets

What is a label?

• the identifying name that reflects the information contained in a column or row in a worksheet.

• the identifying letters and numbers for columns and rows.

• the name of the cell

• what a worksheet file is saved as

What is a column?

• the horizontal spaces with the headings 1, 2, 3

• in a worksheet, the vertical spaces with headings A,B,C, and so on

• rectangular shaped area on a worksheet

• the active area that you work in

What is a formula?

• a combination of letters and numbers used to express a calculation

• something a baby drinks

• a combination of numbers and symbols used to express a calculation

• a combination of letters and symbols used to express a calculation

The Microsoft Office program that has spreadsheets is...

• Word

• Excel

• Powerpoint

• Access

What is a heading?

• the name of a cell

• a document that is stored on your computer

• the identifying letters and numbers for columns and rows

• a feature that allows you to name your worksheet

What is a row?

• in a worksheet, the vertical spaces with the headings A,B,C, and so on.

• the rectangular shaped area on a worksheet

• one of the things that go up and down

• in a worksheet, the horizontal spaces with the headings 1, 2, 3, and so on.

Which of the following is selected when you drag (most accurate response)?

• columns

• rows

• a range of cells

• the active cell

Which of the following are features?

• autofill

• autosum

• fill down

• fill right

• none of the above