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.
A(n) ____ is a reference to a cell or range of cells in another workbook.
 A: object
 B: arrow
 C: link
 D: drill down
2.
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
3.
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
4.
The ____ serves as a digit placeholder in format codes.
 A: ampersand (&)
 B: number sign (#)
 C: dollar sign ($)
 D: question mark (?)
5.
A series of numbers that are 1,2,3,4,5,etc. are an example of a ____ series.
 A: fill
 B: linear
 C: growth
 D: data
6.
A range that spans two or more worksheets in a workbook is called a ____.
 A: double range
 B: 3-D range
 C: extended range
 D: multiple range
7.
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
8.
Which of the following is used to resize a text box or a WordArt object?
 A: WordArt handles
 B: Resize handles
 C: Formatting handles
 D: Picture handles
9.
____ can be changed to increase or decrease the white space surrounding the printed worksheet or chart.
 A: Footers
 B: Margins
 C: Braces
 D: Annotation
10.
Excel inserts ____ that show the boundaries of what will print on each page.
 A: page limits
 B: page breaks
 C: solid lines
 D: tags
11.
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
12.
A ____ is a group of format specifications that are assigned to a name.
 A: style
 B: normal
 C: workbook
 D: format
13.
You can display tomorrow's date in a cell by using ____.
 A: NEXT DAY ( )
 B: NOW ( ) + 1
 C: TODAY ( )
 D: TOMORROW ( )
14.
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 (#)
15.
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
16.
____ 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
17.
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
18.
To connect an object to an item that you want to annotate, you can use a(n) ____.
 A: blue line
 B: dotted line
 C: WordArt object
 D: arrow
19.
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
20.
The ____ command on the Find & Select menu is used to locate a string.
 A: Locate
 B: Find
 C: String
 D: Match

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