MS Excel Module 5: Quiz!

5 Questions | Attempts: 218
Share

SettingsSettingsSettings
MS Excel Module 5: Quiz! - Quiz

.


Questions and Answers
  • 1. 
    Which Excel feature can summarize the data in a large table?    
    • A. 

      Data Validation

    • B. 

      Conditional Formatting

    • C. 

      AutoFormat

    • D. 

      Pivot Table

    • E. 

      Hyperlink

  • 2. 
    Names are entered in cells A2:A500, and quantities are entered in cells B2:B500. To calculate the total quantity for the person named "Wilson", I would use the ___________________ worksheet function.
  • 3. 
    To create a list of unique items, based on a list that contains many duplicate entries, which Excel feature would you use?
    • A. 

      AutoFilter

    • B. 

      Merge Cells

    • C. 

      Custom Sort

    • D. 

      Data Validation

    • E. 

      Advanced Filter

  • 4. 
    You want to create a drop-down list in a cell so that users can select from a list of products. Which Excel feature should you use?
    • A. 

      Pivot Table

    • B. 

      AutoFormat

    • C. 

      Data Validation

    • D. 

      Insert Comment

    • E. 

      Named Range

  • 5. 
    The sales tax rate is in cell H2. Sales totals are in cells B2:B20. To calculate the tax on each sale, you'll enter a formula in cell C2 to multiply the sales total in B2 by the sales tax rate. Then, you'll copy the formula down to cell B20. Which formula should you use?
    • A. 

      =B2*$H$2

    • B. 

      =$B$2*$H$2

    • C. 

      =B$2*$H$2

    • D. 

      =B2*H2

    • E. 

      =B2*$H2

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.