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.
Excel inserts ____ that show the boundaries of what will print on each page.
 A: page limits
 B: page breaks
 C: solid lines
 D: tags
2.
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
3.
A ____ is a group of format specifications that are assigned to a name.
 A: style
 B: normal
 C: workbook
 D: format
4.
You can display tomorrow's date in a cell by using ____.
 A: NEXT DAY ( )
 B: NOW ( ) + 1
 C: TODAY ( )
 D: TOMORROW ( )
5.
A(n) ____ in a format code ensures that a decimal point will display in the number.
 A: asterisk (*)
 B: comma (,)
 C: period (.)
 D: number sign (#)
6.
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
7.
____ 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
8.
The ____ allows you to create shadowed, skewed, rotated, and stretched text on a chart.
 A: Edit menu
 B: Customize command
 C: ChartWizard
 D: WordArt tool
9.
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
10.
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
11.
The ____ command on the Find & Select menu is used to locate a string.
 A: Locate
 B: Find
 C: String
 D: Match
12.
To create a workspace file, click the Save Workspace button on the ____ tab on the Ribbon.
 A: File
 B: View
 C: Data
 D: Worksheet
13.
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
14.
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
15.
Excel assigns the ____ style to all cells when you open a new workbook.
 A: Normal
 B: Comma
 C: Percent
 D: Standard
16.
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
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 WordArt design is called a(n) ____.
 A: tool
 B: object
 C: placeholder
 D: graphic
19.
____ 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
20.
The ____ define(s) the appearance and format of a page.
 A: header
 B: footer
 C: page setup
 D: margins

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