MS Excel 97 Lesson 2Review

1. Please provide the following contact information:

   First Name
   Last Name

1. The Office Assistant button is used to display the Office Assistant.

   True False
   

2. The fill handle cannot be used to copy formulas.

   True False
   

3. The Merge and Center button can only be used with numbers.

   True False
   

4. Formulas must always begin with an open parenthesis (.

   True False
   

5. Formulas can include both cell and range references.

   True False
   

6. The * is used to represent multiplication in formulas.

   True False
   

7. Point mode can be used to insert cell and range references in formulas.

   True False
   

8. The Comma number style inserts a dollar sign in front of the number.

   True False
   

9. You can set a typeface and size for both text and numbers.

   True False
   

10. The Format Painter copies text formats but not number formats.

    True False
    

Multiple Choice Questions

1. What should you do before clicking the Merge and Center button?

   No answer a)Click the cell that contains the entry you wish to center. b)Select the cells you wish to center the entry across while making sure the entry is included in the selection. c)Select the entire row that contains the entry you wish to center. d)None of the above.
   

2. Which of the following symbols can be used to begin a formula?

   No answer a)+ b)- c)= d)All of the above.
   

3. Which of the following characters can be used in formulas?

   No answer a)+ b)% c)blank space d)All of the above
   

4. How would the number 10000.367 be displayed if you format it as comma with 2 decimals?

   No answer a)10,000.38 b)$10,000.38 c)10,000 d)None of the above.
   

5. How is the dollar sign positioned with the Accounting number style?

   No answer a)Floats to the immediate left of the number. b)Fixed on the left edge of the cell. c)The Accounting style does not place a dollar sign in front of the number. d)It depends on whether the number has a decimal point.