MS Excel Module 5: Quiz!
-
Which Excel feature can summarize the data in a large table?
-
Data Validation
-
Conditional Formatting
-
AutoFormat
-
Pivot Table
-
Hyperlink
-
MS Excel Module 5: Quiz! tests your skills in utilizing Excel features like Pivot Tables, SUMIF, Advanced Filter, Data Validation, and formula creation for practical business applications, enhancing efficiency in data management and analysis.
Quiz Preview
- 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.
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?
-
AutoFilter
-
Merge Cells
-
Custom Sort
-
Data Validation
-
Advanced Filter
Correct Answer
A. Advanced FilterExplanation
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?
-
Pivot Table
-
AutoFormat
-
Data Validation
-
Insert Comment
-
Named Range
Correct Answer
A. Data ValidationExplanation
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?
-
=B2*$H$2
-
=$B$2*$H$2
-
=B$2*$H$2
-
=B2*H2
-
=B2*$H2
Correct Answer
A. =B2*$H$2Explanation
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 (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Dec 16, 2011Quiz Created by
Learn IT
Back to top