|
1 | | In Excel, when data is consolidated among worksheets, we refer to it as being: |
| | A) | Linked. |
| | B) | Incorporated. |
| | C) | Combined. |
| | D) | Summarized. |
|
|
|
2 | | To create a consolidated worksheet by position, both documents must have: |
| | A) | The same data layout. |
| | B) | The same data time frame. |
| | C) | The same page theme. |
| | D) | The same workbook. |
|
|
|
3 | | Consolidation worksheets are based on: |
| | A) | A copy of a source worksheet. |
| | B) | A new worksheet. |
| | C) | A consolidated workbook. |
| | D) | A consolidation template. |
|
|
|
4 | | A static consolidation shows calculated values that: |
| | A) | Have dynamic links. |
| | B) | Do not update. |
| | C) | Recalculated when changed. |
| | D) | Cannot be copied. |
|
|
|
5 | | If the data on your source worksheets might be edited after you have created your consolidation, you should: |
| | A) | Make a copy. |
| | B) | Recalculate. |
| | C) | Create a dynamic consolidation. |
| | D) | Hyperlink your data . |
|
|
|
6 | | You can build a consolidated worksheet by category as long as: |
| | A) | The layout matches. |
| | B) | The labels match. |
| | C) | The values match. |
| | D) | The timeline matches. |
|
|
|
7 | | For workbooks to be linked, they must all be accessible over a network, on the same computer, or |
| | A) | In the same workbook. |
| | B) | On a mobile device. |
| | C) | In the cloud. |
| | D) | In the same documents folder. |
|
|
|
8 | | A character such as an exclamation point that marks or signifies a component of an external reference is called: |
| | A) | An argument. |
| | B) | An identifier. |
| | C) | A marker. |
| | D) | A hyperlink. |
|
|
|
9 | | To view open workbooks side by side or horizontally tiled , use: |
| | A) | The Tab key. |
| | B) | A dual screen. |
| | C) | View tab, Freeze pane. |
| | D) | The Arrange All button. |
|
|
|
10 | | Organization charts, matrices, pyramids, bulleted lists, and other similar diagrams available within Office applications are called: |
| | A) | WordArt. |
| | B) | ClipArt. |
| | C) | SmartArt. |
| | D) | ChartArt. |
|
|
|
11 | | The rectangle that surrounds a SmartArt graphic is called: |
| | A) | An outline. |
| | B) | A shape. |
| | C) | A bounding box. |
| | D) | A canvas. |
|
|
|
12 | | The keyboard shortcut to insert a hyperlink is: |
| | A) | Ctrl+H. |
| | B) | Ctrl+K. |
| | C) | Alt+L. |
| | D) | F4. |
|
|
|
13 | | Once you place a screenshot in a worksheet, it becomes: |
| | A) | Static. |
| | B) | A text block. |
| | C) | A picture object. |
| | D) | Consolidated. |
|
|
|
14 | | The Hyperlink button is located on this tab: |
| | A) | References |
| | B) | Layout |
| | C) | Insert |
| | D) | Data |
|
|
|
15 | | The Take a Screenshot button displays small images of open windows called: |
| | A) | icons. |
| | B) | thumbnails. |
| | C) | logos. |
| | D) | clips. |
|
|