Excel 2010 Chapter 1

Answer Key for Matching and Multiple Choice

Matching

O Workbook 1. An Excel file that contains one or more worksheets.

M Spreadsheet 2. Another name for a worksheet.

A Cell 3. The intersection of a column and a row.

L Sheet tabs 4. The labels along the lower border of the Excel window that identify each worksheet.

E Column 5. A vertical group of cells in a worksheet.

K Row 6. A horizontal group of cells in a worksheet.

C Cell content 7. Anything typed into a cell.

G Data 8. Information such as numbers, text, dates, or times of day that you type into a cell.

F Constant value 9. Text or numbers in a cell that are not a formula.

I Formula 10. An equation that performs mathematical calculations on values in a worksheet.

J Number value 11. A constant value consisting of only numbers.

B Cell address 12. Another name for a cell reference.

N Value 13. Another name for a constant value.

H Fill handle 14. The small black square in the lower right corner of a selected cell.

D Chart15. The graphic representation of data in a worksheet.

Multiple Choice

1. On startup, Excel displays a new blank: B. workbook

2. An Excel window element that displays the value or formula contained in the active cell is the: C. formula bar

3. An Excel window element that displays the name of the selected cell, table, chart, or object is the: A. name box

4. A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the: B. select all box

5. A cell surrounded by a black border and ready to receive data is the: A. active cell

6. The feature that generates and extends values into adjacent cells based on the values of

selected cells is: B. Auto Fill

7. The default format that Excel applies to numbers is the: C. general format

8. The data that displays in the Formula Bar is referred to as the: C. underlying value

9. The type of cell reference that refers to cells by their fixed position in a worksheet is: A. absolute

10. Tiny charts embedded in a cell that give a visual trend summary alongside your data are: B. sparklines