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 create a workspace file, click the Save Workspace button on the ____ tab on the Ribbon.
 A: File
 B: View
 C: Data
 D: Worksheet
2.
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
3.
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
4.
A WordArt design is called a(n) ____.
 A: tool
 B: object
 C: placeholder
 D: graphic
5.
The ____ define(s) the appearance and format of a page.
 A: header
 B: footer
 C: page setup
 D: margins
6.
A ____ saves information about all the workbooks that are open.
 A: workspace file
 B: temporary file
 C: holding file
 D: windows file
7.
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
8.
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
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.
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
11.
The linked workbooks are called the ____.
 A: primary workbooks
 B: original workbooks
 C: dependent workbooks
 D: source workbooks
12.
A series of format symbols that defines how a format displays is called a ____.
 A: format sequence
 B: format key
 C: format rule
 D: format code
13.
A(n) ____ reference is a formula that depends on its own value.
 A: nested
 B: braced
 C: circular
 D: absolute
14.
A series of Jan, Feb, Mar, Apr, etc. would be considered a ____.
 A: data series
 B: date series
 C: fill series
 D: growth series
15.
A ____ is printed at the bottom of every page in a printout.
 A: header
 B: footer
 C: margin
 D: comment
16.
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
17.
The ____ serves as a digit placeholder in format codes.
 A: ampersand (&)
 B: number sign (#)
 C: dollar sign ($)
 D: question mark (?)
18.
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
19.
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
20.
Excel inserts ____ that show the boundaries of what will print on each page.
 A: page limits
 B: page breaks
 C: solid lines
 D: tags

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