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.
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
2.
A WordArt design is called a(n) ____.
 A: tool
 B: object
 C: placeholder
 D: graphic
3.
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
4.
The ____ button on the Design contextual tab on the Ribbon can be used to move a chart from a chart sheet to a worksheet.
 A: Move Chart
 B: Paste Chart
 C: Insert Object
 D: Link Chart
5.
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
6.
A ____ is printed at the bottom of every page in a printout.
 A: header
 B: footer
 C: margin
 D: comment
7.
To find a string using shortcut keys, press CTRL+ ____.
 A: L
 B: S
 C: F
 D: B
8.
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
9.
The linked workbooks are called the ____.
 A: primary workbooks
 B: original workbooks
 C: dependent workbooks
 D: source workbooks
10.
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
11.
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
12.
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
13.
The ____ serves as a digit placeholder in format codes.
 A: ampersand (&)
 B: number sign (#)
 C: dollar sign ($)
 D: question mark (?)
14.
Which of the following can you drill an entry down through a workbook?
 A: Formula
 B: Function
 C: Format
 D: All of the above
15.
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
16.
A(n) ____ reference is a formula that depends on its own value.
 A: nested
 B: braced
 C: circular
 D: absolute
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.
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
19.
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
20.
To connect an object to an item that you want to annotate, you can use a(n) ____.
 A: blue line
 B: dotted line
 C: WordArt object
 D: arrow

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