 |
| 1 | |
With three rows and five columns of labels selected, which of the following Excel commands would center all labels across a selected range? |
| | A) | Center |
| | B) | Center Across Range |
| | C) | Center Across Selection |
| | D) | Merge and Center |
|
|
|
| 2 | |
Which of the following alignment commands moves data away from the cell's edge for better readability of values and labels in an Excel worksheet? |
| | A) | Align |
| | B) | Indent |
| | C) | Wrap |
| | D) | Move |
|
|
|
| 3 | |
What are three data visualization types available for an Excel worksheet? |
| | A) | Align, Merge, and Wrap |
| | B) | Charts, Shapes, and SmartArt |
| | C) | Data bars, Color scales, and Icon sets |
| | D) | Borders, fill, and patterns |
|
|
|
| 4 | |
Which of the following commands combines a range of cells into one cell that occupies the same amount of space in an Excel worksheet? |
| | A) | Merge |
| | B) | Merge and Center |
| | C) | Center Across |
| | D) | Center All |
|
|
|
| 5 | |
In an Excel worksheet, how do you display the drag-and-drop pointer for a cell? |
| | A) | Click inside the cell |
| | B) | Right-click the cell's border |
| | C) | Hover over the cell's border |
| | D) | Point at the cell's intersection |
|
|
|
| 6 | |
How many cut or copied items can be stored in the Office Clipboard for an Excel worksheet? |
| | A) | 1 |
| | B) | 12 |
| | C) | 24 |
| | D) | 36 |
|
|
|
| 7 | |
Which of the following statements is true about cells to be merged using the Merge and Center command in an Excel worksheet? |
| | A) | The same number of cells must be selected as there are labels. |
| | B) | The range should be empty except for the top-right cell. |
| | C) | The range should be empty except for the top-left cell. |
| | D) | The cell contents must be first centered. |
|
|
|
| 8 | |
In an Excel worksheet, which of the following objects is checked by the Spelling command? |
| | A) | Menus |
| | B) | Labels |
| | C) | Values |
| | D) | Charts |
|
|
|
| 9 | |
If a zero in a value does not affect the actual number in a cell, which of the following terms is used to describe the zero in an Excel worksheet? |
| | A) | Null |
| | B) | Inconsequential |
| | C) | Insignificant |
| | D) | Empty |
|
|
|
| 10 | |
In a custom Excel number format, which of the following characters or symbols signify that a digit is required? |
| | A) | 0 |
| | B) | # |
| | C) | * |
| | D) | ? |
|
|
.