MS Excel Module 5: Quiz!

5 Questions | By Learn IT | Updated: Mar 21, 2022 | Attempts: 218

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