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.
To enter a number as text, start the entry with a(n) ____.
 A: asterisk
 B: hyphen
 C: semicolon
 D: apostrophe
2.
Each worksheet has a sheet name that appears on a(n) ____ at the bottom of the workbook.
 A: name indicator
 B: active tab
 C: title tab
 D: sheet tab
3.
The AutoCorrect feature works behind the scenes correcting which of the following mistakes?
 A: Corrects two initial capital letters by changing the second one to lowercase
 B: Capitalizes the names of the days
 C: Replaces commonly misspelled words with their correct spelling
 D: All of the above
4.
The ____ is a central location for managing and sharing workbooks.
 A: Ribbon
 B: Office Button
 C: ScreenTip
 D: Share toolbar
5.
____ cells involves creating a single cell by combining two or more selected cells.
 A: Formatting
 B: Merging
 C: Embedding
 D: Splitting
6.
The mouse pointer turns to a ____ whenever you move it outside the worksheet.
 A: hand
 B: block arrow
 C: double-headed arrow
 D: crosshair
7.
A printed version of a worksheet is called a ____.
 A: hard copy
 B: copy
 C: file
 D: worksheet copy
8.
Each worksheet in a workbook has ____ columns.
 A: 100
 B: 256
 C: 16,384
 D: unlimited
9.
To move the insertion point to the beginning of data in a cell, press ____.
 A: Begin
 B: Page Up
 C: End
 D: Home
10.
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
11.
To emphasize certain entries and make the worksheet easier to read and understand, you ____ the worksheet.
 A: format
 B: edit
 C: print
 D: proofread
12.
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
13.
Excel's ____ function allows you to add all of the numbers in a range of cells.
 A: MIN
 B: MAX
 C: SUM
 D: ADD
14.
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
15.
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
16.
____ allow users to enter, calculate, manipulate, and analyze data.
 A: Charts
 B: Lists
 C: Worksheets
 D: Databases
17.
The ____ is a blinking vertical line that indicates where the next typed character will appear.
 A: insertion point
 B: Key Tip
 C: active cell
 D: Ribbon
18.
A ____ is a list of commands.
 A: tab
 B: Key Tip
 C: menu
 D: dialog box
19.
The ____ command in the AutoCalculate area displays the highest value in the selected range.
 A: Large
 B: Highest
 C: Most
 D: Maximum
20.
Each worksheet in a workbook has ____ rows.
 A: 100
 B: 32,767
 C: 65,536
 D: 1,048,576

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