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 WordArt design is called a(n) ____.
 A: tool
 B: object
 C: placeholder
 D: graphic
2.
A(n) ____ can be a single character, a word, or a phrase in a cell on a worksheet.
 A: string
 B: object
 C: page setup
 D: form page
3.
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
4.
A ____ is a group of format specifications that are assigned to a name.
 A: style
 B: normal
 C: workbook
 D: format
5.
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
6.
The linked workbooks are called the ____.
 A: primary workbooks
 B: original workbooks
 C: dependent workbooks
 D: source workbooks
7.
____ 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
8.
To create a workspace file, click the Save Workspace button on the ____ tab on the Ribbon.
 A: File
 B: View
 C: Data
 D: Worksheet
9.
A(n) ____ reference is a formula that depends on its own value.
 A: nested
 B: braced
 C: circular
 D: absolute
10.
A(n) ____ is a reference to a cell or range of cells in another workbook.
 A: object
 B: arrow
 C: link
 D: drill down
11.
You can have up to ____ worksheets in a workbook.
 A: 30
 B: 60
 C: 255
 D: limited only by the amount of memory in your computer
12.
To find a string using shortcut keys, press CTRL+ ____.
 A: L
 B: S
 C: F
 D: B
13.
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
14.
Excel inserts ____ that show the boundaries of what will print on each page.
 A: page limits
 B: page breaks
 C: solid lines
 D: tags
15.
Which of the following can you drill an entry down through a workbook?
 A: Formula
 B: Function
 C: Format
 D: All of the above
16.
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
17.
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 (#)
18.
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
19.
A series of format symbols that defines how a format displays is called a ____.
 A: format sequence
 B: format key
 C: format rule
 D: format code
20.
A(n) ____ is printed at the top of every page in a printout.
 A: brace
 B: arrow
 C: footer
 D: header

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