Basic Excel Skills Test Quiz!

5 Questions | Total Attempts: 2704

SettingsSettingsSettings
Please wait...
Basic Excel Skills Test 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 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