Excel Chapter 5: Exploring Data Tools, Data Types, and Illustrations

Questions

Multiple Choice

1. To edit an Excel worksheet that is marked as final and therefore should not be edited, click:
   1. Admin.
   2. Revert.
   3. Undo Final.
   4. Ignore.
   5. Edit Anyway.
2. To create a consolidated worksheet by position, both documents must have the same:
   1. Layout.
   2. Data time frame.
   3. Page theme.
   4. Categories.
   5. Values.
3. If you wish to make formatting changes to identical worksheets in a workbook, simply do this before applying the changes.
   1. Consolidate the worksheets.
   2. Create a new blank worksheet.
   3. Reformat the worksheets.
   4. Group the worksheets.
   5. Publish the worksheets.
4. A static consolidation shows calculated values that:
   1. Have dynamic links.
   2. Do not automatically update.
   3. Recalculate when values change.
   4. Cannot be copied.
   5. Can never be recalculated.
5. If the data on your source worksheets might be edited after you have created your consolidation, you should:
   1. Make a copy.
   2. Recalculate.
   3. Create a dynamic consolidation.
   4. Hyperlink your data.
   5. Make the consolidation read only.
6. You can build a data consolidation by category as long as the:
   1. Layout matches.
   2. Order of columns is identical.
   3. Values match.
   4. Timeline matches.
   5. Labels match.
7. For workbooks to be linked, they must all be accessible over a network, on the same computer, or
   1. In the same workbook.
   2. On a mobile device.
   3. In the cloud.
   4. In the same documents folder.
   5. None of the above.
8. A character such as an exclamation point that marks or signifies a component of an external reference is called a(n):
   1. Argument.
   2. Identifier.
   3. Marker.
   4. Hyperlink.
   5. Variable.
9. If a workbook refers to data in another workbook, it is a:
   1. Static workbook.
   2. Source workbook.
   3. Consolidated workbook.
   4. Dependent workbook.
   5. Dynamic workbook.
10. Organization charts, matrices, pyramids, bulleted lists, and other similar diagrams available within Office applications are called:
    1. WordArt.
    2. ClipArt.
    3. SmartArt.
    4. ChartArt.
    5. Shapes.
11. The rectangle that surrounds a SmartArt graphic is called a(n):
    1. Outline.
    2. Shape.
    3. Bounding frame.
    4. Canvas.
    5. Border.
12. The keyboard shortcut to insert a hyperlink is:
    1. Ctrl+H.
    2. Ctrl+K.
    3. Alt+L.
    4. F4.
    5. F10
13. Once you place a screenshot in a worksheet, it becomes:
    1. Static.
    2. A text block.
    3. A picture object.
    4. Consolidated.
    5. Dynamic.
14. The Link button is located on this tab:
    1. Home
    2. Developer
    3. Page Layout
    4. Insert
    5. Data
15. The Mark as Final command results in a(n):
    1. Encrypted workbook.
    2. Password-protected workbook.
    3. Security message.
    4. Protected worksheet.
    5. File that cannot be edited.