Question 1 of 20 5.0 Points
The __________ command will add new rows or columns to the worksheet:
A. new
B. add
C. find
D. Insert
Question 2 of 20 5.0 Points
The result of the __________ will change when values in the worksheet change.
A. calculations
B. numeric entries
C. formula
D. Data
Question 3 of 20 5.0 Points
The sum of cells E2, E3, E4, and E5 may be found by typing any of the formulas below EXCEPT:
A. =SUM(E2,E3,E4,E5).
B. =SUM(E2-E5).
C. =SUM(E2:E5).
D. =(E2+E3+E4+E5).
Question 4 of 20 5.0 Points
__________ an object deletes the data from the original area and transfers it to the new area.
A. Resizing
B. Copying
C. Deleting
D. Moving
Question 5 of 20 5.0 Points
A file may be saved by pressing:
A. Ctrl+V.
B. Ctrl+C.
C. Ctrl+S.
D. Ctrl+N.
Question 6 of 20 5.0 Points
Using the __________ icon saves the worksheet.
A. clipboard
B. underlined U
C. paintbrush
D. diskette
Question 7 of 20 5.0 Points
Which of the following numerical formats is appropriate for showing a total on a financial statement?
A. general
B. accounting
C. date
D. percentage
Question 8 of 20 5.0 Points
The very first application most businesses implemented for the electronic spreadsheet was:
A. tracking sales.
B. data analysis.
C. tax preparation.
D. budgeting.
Question 9 of 20 5.0 Points
To Cancel a Formula after pressing the ENTER key:
A. press ESC.
B. select Cancel from the Edit menu.
C. click the Cancel box.
D. click the Undo button on the Toolbar.
Question 10 of 20 5.0 Points
The first electronic spreadsheet to be sold for personal computers was:
A. Lotus 1-2-3.
B. Microsoft Excel.
C. Visicalc.
D. DataStar.
Question 11 of 20 5.0 Points
How many cells are there in an Excel 2003 spreadsheet?
A. 65,536
B. 148,576
C. 1,250,000
D. 16,777,216
Question 12 of 20 5.0 Points
A value is a numeric quantity or it can be a:
A. symbol.
B. formula.
C. calculation.
D. command.
Question 13 of 20 5.0 Points
For a function to work, it must be in the proper format, called the:
A. data structure.
B. internal calculations.
C. syntax.
D. formulas.
Question 14 of 20 5.0 Points
A __________ works the same way that a formula does.
A. function
B. calculation
C. command
D. shortcut
Question 15 of 20 5.0 Points
The shortcut Ctrl+A means:
A. Copy.
B. Select All.
C. New Workbook.
D. Undo.
Question 16 of 20 5.0 Points
The shortcut Ctrl+W means:
A. Close.
B. Cut.
C. Undo.
D. New Workbook.
Question 17 of 20 5.0 Points
To enter a number as text, you should precede it with:
A. a comma.
B. a period.
C. a parenthesis.
D. an apostrophe.
Question 18 of 20 5.0 Points
The first thing you must do when entering a formula is:
A. Start the formula with an equal sign.
B. Select the cell where the formula is to be located.
C. Type the formula.
D. Click the Enter box or press the ENTER key.
Question 19 of 20 5.0 Points
Ctrl+R is the shortcut for the __________ command.
A. Repeat
B. Fill Right
C. Resize
D. Replace
Question 20 of 20 5.0 Points
The shortcut for Replace is:
A. Ctrl+Y.
B. Ctrl+R.
C. Ctrl+N.
D. Ctrl+H.
