# Basic Excel Skills Test Quiz!

5 Questions | Total Attempts: 2704

Settings

• 1.
Which Excel feature can summarize the data in a large table?
• A.

Data Validation

• B.

Conditional Formatting

• C.

AutoFormat

• D.

Pivot Table

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

• 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

Related Topics