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 ____ is a group of format specifications that are assigned to a name.
 A: style
 B: normal
 C: workbook
 D: format
2.
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
3.
A(n) ____ is printed at the top of every page in a printout.
 A: brace
 B: arrow
 C: footer
 D: header
4.
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
5.
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
6.
____ can be changed to increase or decrease the white space surrounding the printed worksheet or chart.
 A: Footers
 B: Margins
 C: Braces
 D: Annotation
7.
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
8.
A(n) ____ reference is a formula that depends on its own value.
 A: nested
 B: braced
 C: circular
 D: absolute
9.
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
10.
The process of summarizing data included on multiple worksheets on one worksheet is called ____.
 A: joining
 B: gathering
 C: consolidation
 D: merging
11.
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
12.
The ____ define(s) the appearance and format of a page.
 A: header
 B: footer
 C: page setup
 D: margins
13.
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
14.
____ 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
15.
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
16.
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
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 ____ is printed at the bottom of every page in a printout.
 A: header
 B: footer
 C: margin
 D: comment
19.
You can display tomorrow's date in a cell by using ____.
 A: NEXT DAY ( )
 B: NOW ( ) + 1
 C: TODAY ( )
 D: TOMORROW ( )
20.
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

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