Excel Basics

5 Questions  I  By Ddalgleish
Please take the quiz to rate it.

 Excel Basics
A short test for basic skills in Excel. To see a longer list of basic Excel skills, read 14 Basic Skills for Excel Users

  
Changes are done, please start the quiz.


Questions and Answers

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
  • 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

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.