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) ____ reference is a formula that depends on its own value.
 A: nested
 B: braced
 C: circular
 D: absolute
2.
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
3.
A series of Jan, Feb, Mar, Apr, etc. would be considered a ____.
 A: data series
 B: date series
 C: fill series
 D: growth series
4.
A(n) ____ is printed at the top of every page in a printout.
 A: brace
 B: arrow
 C: footer
 D: header
5.
A ____ is printed at the bottom of every page in a printout.
 A: header
 B: footer
 C: margin
 D: comment
6.
A(n) ____ is a reference to a cell or range of cells in another workbook.
 A: object
 B: arrow
 C: link
 D: drill down
7.
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
8.
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
9.
Excel assigns the ____ style to all cells when you open a new workbook.
 A: Normal
 B: Comma
 C: Percent
 D: Standard
10.
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
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 WordArt design is called a(n) ____.
 A: tool
 B: object
 C: placeholder
 D: graphic
13.
____ 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
14.
The ____ define(s) the appearance and format of a page.
 A: header
 B: footer
 C: page setup
 D: margins
15.
To find a string using shortcut keys, press CTRL+ ____.
 A: L
 B: S
 C: F
 D: B
16.
A ____ saves information about all the workbooks that are open.
 A: workspace file
 B: temporary file
 C: holding file
 D: windows file
17.
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
18.
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
19.
The ____ serves as a digit placeholder in format codes.
 A: ampersand (&)
 B: number sign (#)
 C: dollar sign ($)
 D: question mark (?)
20.
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

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