MS Excel Module 5: Quiz!

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Learn IT
L
Learn IT
Community Contributor
Quizzes Created: 1 | Total Attempts: 240
| Attempts: 240
SettingsSettings
Please wait...
  • 1/5 Questions

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

    • Data Validation
    • Conditional Formatting
    • AutoFormat
    • Pivot Table
    • Hyperlink
Please wait...
About This Quiz

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.

MS Excel Module 5: Quiz! - Quiz

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

    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. 
    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? - ProProfs

    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 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:

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

    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 Filter
    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:

  • 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? - ProProfs

    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$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 (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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 16, 2011
    Quiz Created by
    Learn IT
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.