Question 1. To enter a number as text, you should precede it with:
A. a comma.
B. a period.
C. a parenthesis.
D. an apostrophe.
Question 2. The shortcut for Repeat is:
A. Ctrl+Y.
B. Ctrl+R.
C. Ctrl+N.
D. Ctrl+H.
Question 3. 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 4. Which of the following CANNOT be used to exit Microsoft Excel?
A. Ctrl+Z
B. keyboard
C. arrow keys
D. mouse
Question 5. 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 6. The shortcut Ctrl+A means:
A. Copy.
B. Select All.
C. New Workbook.
D. Undo.
Question 7. __________ is the shortcut for the Repeat command.
A. Ctrl+H
B. Ctrl+Y
C. Ctrl+R
D. Ctrl+P
Question 8. The shortcut Ctrl+K means:
A. Repeat.
B. Cut.
C. Insert Hyperlink.
D. New Workbook.
Question 9. __________ 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 10. A file may be saved by pressing:
A. Ctrl+V.
B. Ctrl+C.
C. Ctrl+S.
D. Ctrl+N.
Question 11. 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 12. 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 13. Using either the Toolbar or the __________ saves the worksheet.
A. Shortcut list
B. Menu bar
C. Enter box
D. Confirm box
Question 14. A __________ works the same way that a formula does.
A. function
B. calculation
C. command
D. shortcut
Question 15. The shortcut Ctrl+W means:
A. Close.
B. Cut.
C. Undo.
D. New Workbook.
Question 16. The result of the __________ will change when values in the worksheet change.
A. calculations
B. numeric entries
C. formula
D. data
Question 17. __________ is the shortcut for the Cut command.
A. Ctrl+X
B. Ctrl+C
C. Ctrl+H
D. Ctrl+T
Question 18. The __________ has several shortcuts for changing the appearance of data.
A. Shortcut list
B. Menu bar
C. Toolbar
D. Title bar
Question 19. Using the __________ icon saves the worksheet.
A. clipboard
B. underlined U
C. paintbrush
D. diskette
Question 20. The power of Excel is the ability to create and use formulas, which can be very long and complex. To simplify this process, Excel has some built-in formulas called:
A. functions.
B. syntaxes.
C. commands.
D. mathematical operators.