Practice Test Project 1
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.
The mouse pointer turns to a ____ whenever you move it outside the worksheet.
 A: hand
 B: block arrow
 C: double-headed arrow
 D: crosshair
2.
A printed version of a worksheet is called a ____.
 A: hard copy
 B: copy
 C: file
 D: worksheet copy
3.
The horizontal and vertical lines on a worksheet are called ____.
 A: cells
 B: sheets
 C: blocklines
 D: gridlines
4.
To save a workbook using the shortcut keys, press ____.
 A: ALT+S
 B: CTRL+S
 C: SHIFT+S
 D: CTRL+F2
5.
Each worksheet in a workbook has ____ columns.
 A: 100
 B: 256
 C: 16,384
 D: unlimited
6.
To move the insertion point to the beginning of data in a cell, press ____.
 A: Begin
 B: Page Up
 C: End
 D: Home
7.
The basic unit of a worksheet into which you enter data is called a ____.
 A: tab
 B: cell
 C: box
 D: range
8.
The vertical axis of a chart is called the ____ axis.
 A: long
 B: range
 C: value
 D: floating
9.
The number of worksheets that you can add to a workbook is ____.
 A: 100
 B: 256
 C: 1,067,456
 D: limited by the amount of memory on the computer
10.
To emphasize certain entries and make the worksheet easier to read and understand, you ____ the worksheet.
 A: format
 B: edit
 C: print
 D: proofread
11.
The default view in Excel is ____ view.
 A: Work
 B: Auto
 C: Normal
 D: Roman
12.
The range of cells receiving a copy is called the ____ area.
 A: source
 B: destination
 C: copy
 D: reference
13.
The ____ bar presents information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of Excel.
 A: function
 B: indicator
 C: chart
 D: status
14.
Excel's ____ function allows you to add all of the numbers in a range of cells.
 A: MIN
 B: MAX
 C: SUM
 D: ADD
15.
A(n) ____ is a window that contains additional commands and can stay open and visible while you work on a worksheet.
 A: Ready window
 B: task pane
 C: Excel pane
 D: action window
16.
A file name can have a maximum of ____ characters.
 A: 25
 B: 100
 C: 255
 D: 32,676
17.
The four major parts of Excel are ____.
 A: Worksheets, Charts, Tables, and Web Support
 B: Workbooks, Charts, Lists, and Databases
 C: Workbooks, Charts, Wizards, and Templates
 D: Worksheets, Charts, Graphs, and Databases
18.
In Excel, any set of characters containing a letter, hyphen, or space is considered ____ .
 A: a formula
 B: text
 C: a name
 D: a title
19.
Which of the following is not a valid entry into a cell that requires numbers?
 A: +
 B: E
 C: #
 D: $
20.
The ____ feature of Excel works behind the scenes, correcting common mistakes.
 A: AutoCorrect
 B: Spelling
 C: Help
 D: Ribbon

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