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.
A printed version of a worksheet is called a ____.
 A: hard copy
 B: copy
 C: file
 D: worksheet copy
2.
To split a merged cell, select the cell and click the ____ button.
 A: Split
 B: Center
 C: Merge and Center
 D: Split and Merge
3.
A file name can have a maximum of ____ characters.
 A: 25
 B: 100
 C: 255
 D: 32,676
4.
The ____ is a central location for managing and sharing workbooks.
 A: Ribbon
 B: Office Button
 C: ScreenTip
 D: Share toolbar
5.
Each worksheet in a workbook has ____ rows.
 A: 100
 B: 32,767
 C: 65,536
 D: 1,048,576
6.
The default view in Excel is ____ view.
 A: Work
 B: Auto
 C: Normal
 D: Roman
7.
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
8.
The ____ command in the AutoCalculate area displays the highest value in the selected range.
 A: Large
 B: Highest
 C: Most
 D: Maximum
9.
The vertical axis of a chart is called the ____ axis.
 A: long
 B: range
 C: value
 D: floating
10.
To enter a number as text, start the entry with a(n) ____.
 A: asterisk
 B: hyphen
 C: semicolon
 D: apostrophe
11.
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
12.
The horizontal and vertical lines on a worksheet are called ____.
 A: cells
 B: sheets
 C: blocklines
 D: gridlines
13.
Excel opens a new workbook with ____ worksheets.
 A: one
 B: two
 C: three
 D: five
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.
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
16.
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
17.
Excel's ____ function allows you to add all of the numbers in a range of cells.
 A: MIN
 B: MAX
 C: SUM
 D: ADD
18.
By default, Excel positions text in a cell ____.
 A: left-aligned
 B: right-aligned
 C: centered
 D: justified
19.
A ____ is a set of choices, often graphical, arranged in a grid or in a list.
 A: gallery
 B: table
 C: ribbon
 D: tab
20.
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

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