Prove Your Knowledge On Microsoft Office Knowledge

10 Questions

Settings
Please wait...
Microsoft Office Quizzes & Trivia

This test serves as an evaluation of how far you have learned in our previous lesson.  You are given 10 minutes to complete this test.  


Questions and Answers
  • 1. 
    Write text here
  • 2. 
    How do you turn Excel's Fixed Decimal Places feature on?
    • A. 

      File > Options > Advanced > Editing Options > Click Automatically Insert a Decimal Point > Put a check mark

    • B. 

      File > Options > Advanced > Editing Options > Click Automatically Insert a Decimal Point > OK

    • C. 

      File > Options > Advanced > Editing Options > Click Automatically Insert a Decimal Point

    • D. 

      Alt+F > Alt+T > Advanced > Editing Options > Click Automatically Insert a Decimal Point > Put a Check Mark > OK

  • 3. 
    When Excel's Fixed Decimal Places feature is on and you want to enter a number without a decimal point, you need to type a comma at the end of the value
    • A. 

      True

    • B. 

      False

  • 4. 
    When you _______________ data in Excel, you pre-select the empty cells where the data entries need to be made and then enter the data in the selected range.
    • A. 

      Select

    • B. 

      Constrain

    • C. 

      Highlight

    • D. 

      Copy

  • 5. 
    This feature of Excel restricts the type of data that should go in a cell.
    • A. 

      AutoCorrect

    • B. 

      Data Validation

    • C. 

      AutoFill

    • D. 

      AutoComplete

  • 6. 
    What are the different kinds of warning styles you can put in the data validation of your cell?
    • A. 

      Stop, warning, information

    • B. 

      Alert, critical, access denied

    • C. 

      Error, warning, update needed

    • D. 

      None of the above

  • 7. 
    Excel's Fixed Decimal Places feature places decimal point in all the numbers that you enter in the worksheet
    • A. 

      True

    • B. 

      False

  • 8. 
    Excel's AutoFill feature enables you to fill out a series of entries in a data table or list -- all by entering only the last item in the series in the spreadsheet.
    • A. 

      True

    • B. 

      False

  • 9. 
    When position the mouse pointer on the Fill Handle of AutoFill feature, it changes from the normal thick, white cross pointer to a
    • A. 

      Thin black-cross pointer

    • B. 

      Four arrowhead pointer

    • C. 

      I-beam pointer

    • D. 

      Double arrowhead pointer