Excel Basics

5 Questions  I  By Ddalgleish on September 24, 2008
Total Sales Calculation
A short test for basic skills in Excel.To see a longer list of basic Excel skills, read 14 Basic Skills for Excel Users

  

Question Excerpt

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.
B.
C.
D.
E.
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.Total Sales Calculation
3.  To create a list of unique items, based on a list that contains many duplicate entries, which Excel feature would you use?Unique List
A.
B.
C.
D.
E.
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?Product List
A.
B.
C.
D.
E.
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?Tax Calculation
A.
B.
C.
D.
E.
Back to top


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz