Take Another Quiz

Excel Basics

5 Questions
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

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. 
  • 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