Excel 2000 Basic Quiz
Click the answer button to see the answer.
You're going to the bank on Monday and somehow loose the the daily receipts that you're supposed to deposit at the end of every day. When you complete the daily receipts summary worksheet on Friday how can you add a note to the Monday cell to explain what happened to your superior ?
a. Don't add a note.
b. Print out the worksheet and add a Post-it note by the Monday receipt cell.
c. Who cares about a note ? Prepare for punishment.
d. Select the Monday receipt cell and select Insert > Comment from the menu to add a comment.
e. ----- ---
Answer
d
How do you delete a column ? (Select all that apply)
a. Right-click the column heading you want to delete and select Delete from teh shortcut menu.
b. Select the column heading you want to delete and select Insert>Delete from the menu.
c. Select the column heading you want to delete and select Edit>Delete from the menu
d. Select the column heading you want to delete and select the Delete Row button on the Standard toolbar.
e. All of the above
Answer
a + c
Which is the fastest method of replacing the contents of a cell ?
a. Click the formula bar to ecit the cell contents , press Backspace to erase the old contents, and enter the new contents.
b. Enter the new contents and they will will replace the old contents.
c. Prress Delete to clear the cell's contents and enter the new contents.
d. Double-click the cell to edit it in place, press Backspace to erase the old contents, and enter the new contents.
e. None of the above
Answer
b
Which of the following will NOT cut information ?
a. Selecting Edit > Cut from the menu
b. Clicking the Cut button on the Standard toolbar.
c. Press Ctrl + X
d. Prerss Ctrl + C
e. None of the above
Answer
d
How can you print three copies of a workbook ?
a. Select File > Print from the menu and type 3 in the Number of copies in the text box.
b. Select File >Properties from the menu and type 3 in the copies to print text box.
c. Press Ctrl +P +3
d. Click the Print button on the Standard toolbar to print the document and then make 2 more copies using xerox machine.
e. None of the above
Answer
a
Relative references always refer to a particular cell address. They do not change if they are mvoed to a new location.
a. True
b. False
c. Not sure
d. ---
e. ---
Answer
b
You can use the Copy button on the Standard toolbar to copy a worksheet's values but not its formulas.
a. True
b. False
c. Not Sure
d. --
e. --
Answer
b
Which of the following statements is NOT true ?
a. When you delete a cell range, row, or column, you must shift any existing cell to take the place of the deleted cells.
b. The Undo function can only undo the most recent action you performed.
c. To find information in a worksheet select Edit>Find from the menu.
d. You can spell check your worksheets by clicking the Spelling button on the Standard toolbar.
e. All of the above
Answer
b
You can edit a cell by :(Select all that apply)
a. Selecting Edit>Edit Workbook>Edit Worksheet>Edit Cell from the menu
b. Double-clicking the cell to edit in place.
c. You can't- you're just going to have to retype all that information over again.
d. Clicking the Formula bar.
e. None of the above
Answer
b+d
How do you insert a row ? (Select all that apply)
a. Select the row heading where you want to insert the new row and select Insert >Row from the menu.
b. Right click the row heading where you want to insert the new row and select Insert from the shortcut menu.
c. Select the row heading where you want to insert the new row and click the Insert Row button on the Standard toolbar.
d. Select the row heading where you want to insert the new row and select Edit >Insert Row from the menu.
e. All of the above.
Answer
a+b
Copyright 2002 by
JA Chang
(
[email protected]
)
Self-Study Quizzes for ESL Students
is at http://www.aitech.ac.jp/~iteslj/quizzes/