Site MapHelpFeedbackLesson 03 Quiz
Lesson 03 Quiz
(See related pages)

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)?







Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Excel > Lesson 03 Quiz