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.
The process of summarizing data included on multiple worksheets on one worksheet is called ____.
 A: joining
 B: gathering
 C: consolidation
 D: merging
2.
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
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 formulas and formats from the source area, but switch the columns and rows.
 A: Formulas
 B: Paste Special
 C: Switch
 D: Transpose
6.
A ____ saves information about all the workbooks that are open.
 A: workspace file
 B: temporary file
 C: holding file
 D: windows file
7.
A(n) ____ reference is a formula that depends on its own value.
 A: nested
 B: braced
 C: circular
 D: absolute
8.
A(n) ____ is a reference to a cell or range of cells in another workbook.
 A: object
 B: arrow
 C: link
 D: drill down
9.
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
10.
The ____ command on the Find & Select menu is used to locate a string.
 A: Locate
 B: Find
 C: String
 D: Match
11.
Which of the following can you drill an entry down through a workbook?
 A: Formula
 B: Function
 C: Format
 D: All of the above
12.
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
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.
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
16.
____ 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
17.
A special workbook you can create and then use as a pattern to create new, similar workbooks or worksheets is called a(n) ____.
 A: sample sheet
 B: template
 C: formatted worksheet
 D: example
18.
A series of Jan, Feb, Mar, Apr, etc. would be considered a ____.
 A: data series
 B: date series
 C: fill series
 D: growth series
19.
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
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.