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 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
2.
A(n) ____ is printed at the top of every page in a printout.
 A: brace
 B: arrow
 C: footer
 D: header
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.
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
5.
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
6.
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
7.
The ____ option on the Paste menu will paste the formulas and formats from the source area, but switch the columns and rows.
 A: Formulas
 B: Paste Special
 C: Switch
 D: Transpose
8.
A ____ saves information about all the workbooks that are open.
 A: workspace file
 B: temporary file
 C: holding file
 D: windows file
9.
You use the ____ function on formulas that potentially can result in more decimal places than the format display in a given cell.
 A: ROUND
 B: AVERAGE
 C: FIT
 D: DECIMAL
10.
____ means that the cell contents must match the word exactly the way it is typed.
 A: Match case
 B: Match entire cell contents
 C: Replace
 D: Match as typed
11.
A workbook contains ____ worksheets by default.
 A: 3
 B: 5
 C: 12
 D: 256
12.
A ____ is printed at the bottom of every page in a printout.
 A: header
 B: footer
 C: margin
 D: comment
13.
The ____ serves as a digit placeholder in format codes.
 A: ampersand (&)
 B: number sign (#)
 C: dollar sign ($)
 D: question mark (?)
14.
____ can be changed to increase or decrease the white space surrounding the printed worksheet or chart.
 A: Footers
 B: Margins
 C: Braces
 D: Annotation
15.
You can display tomorrow's date in a cell by using ____.
 A: NEXT DAY ( )
 B: NOW ( ) + 1
 C: TODAY ( )
 D: TOMORROW ( )
16.
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
17.
A WordArt design is called a(n) ____.
 A: tool
 B: object
 C: placeholder
 D: graphic
18.
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
19.
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
20.
The linked workbooks are called the ____.
 A: primary workbooks
 B: original workbooks
 C: dependent workbooks
 D: source workbooks

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