Excel Chapter 6 - Working with Multiple Worksheets and Workbooks

1
Excel Chapter 6 - Working with Multiple Worksheets and
Workbooks
MULTIPLE CHOICE
1. The process of summarizing data included on multiple worksheets on one worksheet is called _____.
a. summarization c. encapsulation
b. consolidation d. recapitulation
ANS: B PTS: 1 REF: EX 362
2. _____ format codes allow you to specify how a cell entr y assigned a format will appear.
a. Individual c. Custom
b. Specific d. Duplicate
ANS: C PTS: 1 REF: EX 362
3. You document a workbook by adding _____ to cells that con tain complex formulas.
a. totals c. decimal points
b. formatting d. comments
ANS: D PTS: 1 REF: EX 364
4. Excel allows you to work with separate workbooks in a _____ and then link the workbooks to provide a consolidated view of the data in the workbooks.
a. workspace c. presentation
b. database d. document
ANS: A PTS: 1 REF: EX 365
5. _____ often are used when creating an initial consolid ated worksheet to guide users of the worksheet regarding what type of data to enter in cells.
a. Rows c. Placeholders
b. Columns d. Titles
ANS: C PTS: 1 REF: EX 366
6. In consolidated worksheets with more complex formul as, you may want to use _____ that test the extreme boundaries of valid data.
a. text c. placeholders
b. formatting d. numbers
ANS: D PTS: 1 REF: EX 367
7. Which of the following keyboard shortcuts allows y ou to select a range of cells with entries surrounded by blank cells?
a. ALT+SHIFT+ASTERISK (*) c. TAB+SHIFT+ASTERISK (*)
b. CTRL+SHIFT+ASTERISK (*) d. SHIFT+HOME+ASTERISK (*)
ANS: B PTS: 1 REF: EX 367
2
8. You can enter _____ in a cell to display tomorrow’s dat
e.
a.
=NOW()+1
c.
=NOW()-14
b. =NOW()-1 d. =NOW()+14
ANS: A PTS: 1 REF: EX 368
9. You can use the _____ function to change a year, month, and day to a serial number.
a. NOW c. TODAY
b. DATE d. SERIAL
ANS: B PTS: 1 REF: EX 368
10. You should create good _____ to ensure your workbooks are free of errors.
a. color contrast c. test data
b. range