Practice Test Chapter 6
INSTRUCTIONS: Answer each question below. Enter your name and click the 'Grade Test' button to receive a graded study guide. You will not get a grade until all questions are answered.
1.
When you create a template, you should use ____ to verify the formulas in the template.
 A: dummy data
 B: custom format code
 C: comments
 D: format styles
2.
To find a string using shortcut keys, press CTRL+ ____.
 A: L
 B: S
 C: F
 D: B
3.
A series of Jan, Feb, Mar, Apr, etc. would be considered a ____.
 A: data series
 B: date series
 C: fill series
 D: growth series
4.
A(n) ____ allows you to point out a large item or a group of items that you want to annotate.
 A: bracket
 B: brace
 C: arrow
 D: drill
5.
The process of summarizing data included on multiple worksheets on one worksheet is called ____.
 A: joining
 B: gathering
 C: consolidation
 D: merging
6.
Excel inserts ____ that show the boundaries of what will print on each page.
 A: page limits
 B: page breaks
 C: solid lines
 D: tags
7.
A WordArt design is called a(n) ____.
 A: tool
 B: object
 C: placeholder
 D: graphic
8.
A workbook contains ____ worksheets by default.
 A: 3
 B: 5
 C: 12
 D: 256
9.
Which of the following file formats does Excel allow you to distribute as an electronic version of the printed pages?
 A: PDF
 B: WRK
 C:  EXL
 D: All of the above
10.
The default top and bottom margins in Excel for both portrait and landscape orientation is ____.
 A: .5 inches
 B: .75 inches
 C: 1 inch
 D: 2 inches
11.
Which of the following can be used to annotate other objects or elements in a worksheet or chart?
 A: Brace
 B: Arrow
 C: Text box
 D: All of the above
12.
Excel assigns the ____ style to all cells when you open a new workbook.
 A: Normal
 B: Comma
 C: Percent
 D: Standard
13.
The ____ command on the Paste Button Menu pastes the value of the formula from the source area, but not the formulas or formats.
 A: Values Only
 B: Paste Values
 C: Data
 D: Paste Special
14.
When a Page Break preview appears, you can drag the ____ boundaries to new locations to move them.
 A: blue
 B: red
 C: green
 D: yellow
15.
The ____ option on the Paste menu will paste the cell reference of the source area in the destination area.
 A: Paste Link
 B: Paste Special
 C: Values
 D: Transpose
16.
The ____ serves as a digit placeholder in format codes.
 A: ampersand (&)
 B: number sign (#)
 C: dollar sign ($)
 D: question mark (?)
17.
A ____ saves information about all the workbooks that are open.
 A: workspace file
 B: temporary file
 C: holding file
 D: windows file
18.
A(n) ____ is printed at the top of every page in a printout.
 A: brace
 B: arrow
 C: footer
 D: header
19.
____ means that you select multiple sheets and enter information into a cell so that Excel will duplicate the entry in the same cell on all selected sheets.
 A: Combining an entry
 B: Duplicating an entry
 C: Drilling an entry
 D: Copying an entry
20.
To copy the contents of a cell to the cell directly below it, click in the destination cell and press ____.
 A: CTRL+D
 B: CTRL+C
 C: ALT+D
 D: ALT+C

Enter your name and click the 'Grade Test' button.