Microsoft Excel Questions... 9 pages of questions.

Name _________________________ Date ___________

Excel 2010: Chapter 6 – Multiple Choice

Instructions: Circle the correct response.

1. The process of summarizing data included on multiple worksheets on one worksheet is called ____________ .

a. merging b. consolidation c. formula linking d. format code

2. If a date does not fit in the width of a cell, which of the following will be displayed?

a. ?????? b. ****** c. ###### d. --------

3. Which of the following represents a linear series?

a. 2, 4, 6, 8, etc. b. 1, 1, 1, 1, etc. c. Jan, Feb, Mar, etc. d. 2, 4, 8, 16, 32, etc.

4. A format code can have which of the following sections?

a. Positive numbers b. Zeros c. Text d. All of the above

5. The ___________ style is the format style that Excel initially assigns to all cells in a workbook.

a. Normal b. Basic

c. Easy d. Standard

6. To reference cells in other sheets in a workbook, you use the ___________, which serves as the sheet reference, and the cell reference.

a. absolute link b. relative link c. sheet name d. cell number

7. You can change the ____________ to increase or decrease the white space surrounding the printed worksheet or chart.

a. ranges b. margins c. footers d. headers

8. When pasting, which of the following will copy formulas and format for numbers and formulas of the source area, but not the contents?

a. CTRL+A b. CTRL+V c. CTRL+F d. CTRL+O

9. Excel inserts ____________ that show the boundaries of what will print on each page of the printed workbook.

a. keywords b. page breaks c. links d. format codes

10. A ____________ is a reference to a cell or range of cells in another workbook.

a. style b. keyword c. link d. code