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.
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
2.
The ____ command in the AutoCalculate area displays the highest value in the selected range.
 A: Large
 B: Highest
 C: Most
 D: Maximum
3.
The vertical axis of a chart is called the ____ axis.
 A: long
 B: range
 C: value
 D: floating
4.
To enter a number as text, start the entry with a(n) ____.
 A: asterisk
 B: hyphen
 C: semicolon
 D: apostrophe
5.
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
6.
The horizontal and vertical lines on a worksheet are called ____.
 A: cells
 B: sheets
 C: blocklines
 D: gridlines
7.
Excel opens a new workbook with ____ worksheets.
 A: one
 B: two
 C: three
 D: five
8.
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
9.
The ____ command in the AutoCalculate area displays the number of non blank cells in the selected range.
 A: Count
 B: Blank
 C: Zero
 D: Fill
10.
In ____ mode, as you type a character, Excel inserts the character and moves all characters to the right of the typed character one position to the right.
 A: Insert
 B: Overtype
 C: Right-Align
 D: Push Right
11.
Excel's ____ function allows you to add all of the numbers in a range of cells.
 A: MIN
 B: MAX
 C: SUM
 D: ADD
12.
By default, Excel positions text in a cell ____.
 A: left-aligned
 B: right-aligned
 C: centered
 D: justified
13.
A ____ is a set of choices, often graphical, arranged in a grid or in a list.
 A: gallery
 B: table
 C: ribbon
 D: tab
14.
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
15.
You view the portion of the worksheet displayed on the screen through a(n) ____.
 A: active window
 B: worksheet window
 C: cell
 D: active cell menu
16.
The process of editing a cell contents directly in the cell is called ____.
 A: Edit mode
 B: in-cell editing
 C: cell editing
 D: internal editing
17.
To move the insertion point to the beginning of data in a cell, press ____.
 A: Begin
 B: Page Up
 C: End
 D: Home
18.
A(n) ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.
 A: area
 B: range
 C: section
 D: list
19.
The ____ feature of Excel works behind the scenes, correcting common mistakes.
 A: AutoCorrect
 B: Spelling
 C: Help
 D: Ribbon
20.
The mouse pointer turns to a ____ whenever you move it outside the worksheet.
 A: hand
 B: block arrow
 C: double-headed arrow
 D: crosshair

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