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.
The ____ allows you to create shadowed, skewed, rotated, and stretched text on a chart.
 A: Edit menu
 B: Customize command
 C: ChartWizard
 D: WordArt tool
2.
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
3.
A(n) ____ is printed at the top of every page in a printout.
 A: brace
 B: arrow
 C: footer
 D: header
4.
Which of the following can you drill an entry down through a workbook?
 A: Formula
 B: Function
 C: Format
 D: All of the above
5.
To find a string using shortcut keys, press CTRL+ ____.
 A: L
 B: S
 C: F
 D: B
6.
____ 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
7.
A ____ is a group of format specifications that are assigned to a name.
 A: style
 B: normal
 C: workbook
 D: format
8.
A series of Jan, Feb, Mar, Apr, etc. would be considered a ____.
 A: data series
 B: date series
 C: fill series
 D: growth series
9.
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
10.
The ____ define(s) the appearance and format of a page.
 A: header
 B: footer
 C: page setup
 D: margins
11.
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
12.
The ____ command on the Find and Select menu is used to locate one string and then replace it with another.
 A: Fix
 B: Switch
 C: Remove
 D: Replace
13.
If you are summing numbers on contiguous sheets, hold down the ____ key when selecting the sheets.
 A: ALT
 B: CTRL
 C: SHIFT
 D: Page Down
14.
The process of summarizing data included on multiple worksheets on one worksheet is called ____.
 A: joining
 B: gathering
 C: consolidation
 D: merging
15.
____ are used to describe the function of a cell, a range of cells, a sheet, or the entire workbook.
 A: Boxes
 B: Comments
 C: Remarks
 D: Annotations
16.
A(n) ____ in a format code ensures that a decimal point will display in the number.
 A: asterisk (*)
 B: comma (,)
 C: period (.)
 D: number sign (#)
17.
Excel inserts ____ that show the boundaries of what will print on each page.
 A: page limits
 B: page breaks
 C: solid lines
 D: tags
18.
A(n) ____ reference is a formula that depends on its own value.
 A: nested
 B: braced
 C: circular
 D: absolute
19.
The linked workbooks are called the ____.
 A: primary workbooks
 B: original workbooks
 C: dependent workbooks
 D: source workbooks
20.
A WordArt design is called a(n) ____.
 A: tool
 B: object
 C: placeholder
 D: graphic

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