MS Excel 97 Lesson 1Review

1. Please provide the following contact information:

   First Name
   Last Name

1. Each workbook can have a maximum of one worksheet.

   True False
   

2. A worksheet is composed of horizontal rows and vertical columns.

   True False
   

3. Toolbars can be moved in the Excel window.

   True False
   

4. Text entries can contain spaces.

   True False
   

5. Numbers can only contain the digits 0 - 9 and not other characters.

   True False
   

6. The Undo button lets you reverse up to the last 16 changes.

   True False
   

7. A colon : is used to separate the beginning and ending cells in a range reference.

   True False
   

8. You can select an entire row by clicking the row header.

   True False
   

9. When given a choice, AutoSum will always sum the numbers to the left of the active cell instead of summing the numbers above the active cell..

   True False
   

10. The NEW button lets you open an existing workbook.

    True False
    

Multiple Choice Questions

1. Which of the following keystrokes will always move the highlight to cell A1 ?

   No answer a) Home. b) Ctrl + PageUp. c) Ctrl + Home. d) Ctrl + Insert.
   

2. What happens when you enter a number in a cell that already has a text entry?

   No answer a) The number replaces the text entry. b) Excel rejects the number and keeps the text entry intact. c) The cell contains both the number and text entry. d) The computer overheats and begins smoking.
   

3. What happens when you insert an entry in the cell to the right of a long text entry?

   No answer a) The display of the long entry is truncated. b) Excel rejects the number and keeps the text entry intact. c) The cell contains both the number and text entry. d) The computer overheats and begins smoking.
   

4. What happens when you insert an entry in the cell to the left of a long text entry?

   No answer a) The display of the long entry is truncated. b) The long entry is permanently truncated. c) It has no effect on the long entry. d) None of the above.
   

5. Which button is used to confirm an entry?

   a)

   b)

   c)

   d) None of the above.