MS Excel 97 Lesson 4 Review

1. Please provide the following contact information:

   First Name
   Last Name

1. When you enter a date, Excel converts it to a number.

   True False
   

2. Excel applies a date format to dates after it converts them to numbers.

   True False

3. The TODAY function returns the current time.

   True False
   

4. You cannot combine a hard return and automatic text wrapping in the same cell.

   True False
   

5. The AutoFit command changes the column width to fit the narrowest entry in the column.

   True False
   

6. Row heights cannot be changed.

   True False
   

7. The AutoFit command cannot be used to adjust row heights.

   True False
   

8. New columns are inserted to the left of the selected columns.

   True False
   

9. New rows are inserted above the selected rows.

   True False
   

10. A column can be deleted by selecting it and issuing the Edit-->Delete command.

    True False
    

Multiple Choice Questions

1. Which keystroke combination creates a hard return in a cell?

   No answer a)Shift + Enter b)Shift + Tab c)Alt + Enter d)Ctrl + Enter
   

2. Which command displays a dialog box that can be used to set the Wrap Text option?

   No answer a)Format-->Cells b)Edit-->Cells c)Format-Alignment d)None of the above.
   

3. Which spell checker option skips over a word for the remainder of the spell check?

   No answer a)Ignore b)Ignore All c)Skip d)Skip All
   

4. Which statement most accurately describes the effect that inserting a row directly above a formula would have on the formula?

   No answer a)The formula would continue to reference the same cells. b)The formula references would change to include the new row. c)A row cannot be inserted directly above a formula. d)None of the above.
   

5. How many columns would be inserted if you had three columns selected and you issued the Insert-->Columns command.

   No answer a)1 b)3 c)0 d)None of the above.