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.
If you are summing numbers on contiguous sheets, hold down the ____ key when selecting the sheets.
 D: Page Down
A WordArt design is called a(n) ____.
 A: tool
 B: object
 C: placeholder
 D: graphic
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
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
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
A ____ is printed at the bottom of every page in a printout.
 A: header
 B: footer
 C: margin
 D: comment
To find a string using shortcut keys, press CTRL+ ____.
 A: L
 B: S
 C: F
 D: B
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
The linked workbooks are called the ____.
 A: primary workbooks
 B: original workbooks
 C: dependent workbooks
 D: source workbooks
Which of the following file formats does Excel allow you to distribute as an electronic version of the printed pages?
 C:  EXL
 D: All of the above
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
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.
The ____ serves as a digit placeholder in format codes.
 A: ampersand (&)
 B: number sign (#)
 C: dollar sign ($)
 D: question mark (?)
Which of the following can you drill an entry down through a workbook?
 A: Formula
 B: Function
 C: Format
 D: All of the above
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
A(n) ____ reference is a formula that depends on its own value.
 A: nested
 B: braced
 C: circular
 D: absolute
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
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
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
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.