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 printed at the top of every page in a printout.
 A: brace
 B: arrow
 C: footer
 D: header
2.
A WordArt design is called a(n) ____.
 A: tool
 B: object
 C: placeholder
 D: graphic
3.
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
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.
You can display tomorrow's date in a cell by using ____.
 A: NEXT DAY ( )
 B: NOW ( ) + 1
 C: TODAY ( )
 D: TOMORROW ( )
6.
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
7.
To find a string using shortcut keys, press CTRL+ ____.
 A: L
 B: S
 C: F
 D: B
8.
____ can be changed to increase or decrease the white space surrounding the printed worksheet or chart.
 A: Footers
 B: Margins
 C: Braces
 D: Annotation
9.
A rectangular area of variable size in which you can add text is called a(n) ____.
 A: text box
 B: object
 C: text area
 D: text holder
10.
____ 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
11.
A workbook contains ____ worksheets by default.
 A: 3
 B: 5
 C: 12
 D: 256
12.
To save a template using shortcut keys, press ____, type file name, select Excel Template in the Save as type box, select the save location, and click the Save button in the Save As dialog box.
 A: ALT+S
 B: CTRL+F
 C: CTRL+F4
 D: CTRL+S
13.
A ____ is a group of format specifications that are assigned to a name.
 A: style
 B: normal
 C: workbook
 D: format
14.
____ 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
15.
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
16.
A series of Jan, Feb, Mar, Apr, etc. would be considered a ____.
 A: data series
 B: date series
 C: fill series
 D: growth series
17.
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
18.
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
19.
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
20.
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

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