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 basic unit of a worksheet into which you enter data is called a ____.
 A: tab
 B: cell
 C: box
 D: range
2.
A file name can have a maximum of ____ characters.
 A: 25
 B: 100
 C: 255
 D: 32,676
3.
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
4.
A cell is referred to by its unique address, called a(n) ____, which is the coordinates of the intersection of a column and a row.
 A: cell reference
 B: name box
 C: unit
 D: active cell
5.
To enter a number as text, start the entry with a(n) ____.
 A: asterisk
 B: hyphen
 C: semicolon
 D: apostrophe
6.
____ cells involves creating a single cell by combining two or more selected cells.
 A: Formatting
 B: Merging
 C: Embedding
 D: Splitting
7.
Each worksheet in a workbook has ____ columns.
 A: 100
 B: 256
 C: 16,384
 D: unlimited
8.
Excel's ____ function allows you to add all of the numbers in a range of cells.
 A: MIN
 B: MAX
 C: SUM
 D: ADD
9.
____ allow users to enter, calculate, manipulate, and analyze data.
 A: Charts
 B: Lists
 C: Worksheets
 D: Databases
10.
Each worksheet in a workbook has ____ rows.
 A: 100
 B: 32,767
 C: 65,536
 D: 1,048,576
11.
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
12.
The ____ on a Worksheet is one in which you can enter data.
 A: cell
 B: active cell
 C: home cell
 D: reference cell
13.
The horizontal and vertical lines on a worksheet are called ____.
 A: cells
 B: sheets
 C: blocklines
 D: gridlines
14.
The range of cells receiving a copy is called the ____ area.
 A: source
 B: destination
 C: copy
 D: reference
15.
Which of the following is not a valid entry into a cell that requires numbers?
 A: +
 B: E
 C: #
 D: $
16.
A ____ is a set of choices, often graphical, arranged in a grid or in a list.
 A: gallery
 B: table
 C: ribbon
 D: tab
17.
The small black square located in the lower-right corner of the heavy border around the active cell is called the ____.
 A: relative reference
 B: source area
 C: range
 D: fill handle
18.
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
19.
The mouse pointer turns to a ____ whenever you move it outside the worksheet.
 A: hand
 B: block arrow
 C: double-headed arrow
 D: crosshair
20.
To emphasize certain entries and make the worksheet easier to read and understand, you ____ the worksheet.
 A: format
 B: edit
 C: print
 D: proofread

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