 |
| 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. |
|
|
.