Excel Basics

To create a list of unique items, based on a list that contains many duplicate entries, which Excel feature would you use?

Which Excel feature can summarize the data in a large table?    

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.

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?

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?