MS Excel Module 5: Quiz!

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Learn IT
L
Learn IT
Community Contributor
Quizzes Created: 1 | Total Attempts: 227
Questions: 5 | Attempts: 227

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.

D. Pivot Table
Explanation
A Pivot Table is an Excel feature that can summarize data in a large table. It allows users to easily analyze and summarize large amounts of data by creating customizable tables that can be sorted, filtered, and calculated. Pivot Tables are particularly useful for organizing and summarizing data from multiple sources or for creating reports and visualizations. They provide a quick and efficient way to analyze data and identify trends or patterns.

Rate this question:

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

SUMIF
SUMIFS
SUMPRODUCT
Explanation
To calculate the total quantity for the person named "Wilson", the appropriate worksheet function to use would be either SUMIF, SUMIFS, or SUMPRODUCT. These functions allow you to specify a criteria or condition (in this case, the name "Wilson") and sum the corresponding quantities. SUMIF is used when you have a single criteria, while SUMIFS is used when you have multiple criteria. SUMPRODUCT is a more versatile function that can handle multiple criteria and perform calculations on arrays of data.

Rate this question:

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

Explanation
Advanced Filter is the correct answer because it allows users to create a list of unique items from a list that contains duplicate entries. This feature provides options to specify criteria for filtering the data and selecting only the unique values. By using Advanced Filter, users can easily remove duplicate entries and create a new list with unique items.

Rate this question:

• 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

C. Data Validation
Explanation
Data Validation is the correct answer because it allows users to create a drop-down list in a cell. With Data Validation, you can specify a list of products as the source for the drop-down list, ensuring that users can only select from the provided options. This feature helps to maintain data integrity and consistency by restricting input to a predefined set of values. Pivot Table, AutoFormat, Insert Comment, and Named Range are not suitable for creating a drop-down list in a cell.

Rate this question:

• 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

A. =B2*\$H\$2
Explanation
The correct formula to use in this case is =B2*\$H\$2. This formula will multiply the sales total in cell B2 by the sales tax rate in cell H2. By using absolute references (\$), the formula can be copied down to cell B20 without changing the reference to the sales tax rate. This ensures that each sale is multiplied by the correct tax rate.

Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

• Current Version
• Mar 21, 2023
Quiz Edited by
ProProfs Editorial Team
• Dec 16, 2011
Quiz Created by
Learn IT

Related Topics