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.
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
2.
____ 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
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 process of summarizing data included on multiple worksheets on one worksheet is called ____.
 A: joining
 B: gathering
 C: consolidation
 D: merging
6.
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
7.
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
8.
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
9.
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
10.
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
11.
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
12.
A ____ saves information about all the workbooks that are open.
 A: workspace file
 B: temporary file
 C: holding file
 D: windows file
13.
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
14.
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
15.
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
16.
____ 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
17.
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
18.
The ____ command on the Find & Select menu is used to locate a string.
 A: Locate
 B: Find
 C: String
 D: Match
19.
A workbook contains ____ worksheets by default.
 A: 3
 B: 5
 C: 12
 D: 256
20.
A ____ is printed at the bottom of every page in a printout.
 A: header
 B: footer
 C: margin
 D: comment

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