All Exams Test series for 1 year @ ₹349 only
Question

What type of chart is used to compare parts of a whole in MS-Excel?

The correct answer is

Pie Chart

To compare parts of a whole in MS-Excel, the ideal chart type is a Pie Chart. A pie chart is specifically designed to display data in a circular format, where each slice represents a category's contribution to the whole. The primary advantage of using a pie chart is its ability to provide a clear visual comparison of the relative sizes of data, making it easy to understand the composition of different components in relation to each other and to the total.

Was this answer helpful?

Important Questions from Pie Chart

  1. The given pie-diagram shows the expenditure incurred on the preparation of a book by a publisher, under various heads. Study the pie-diagram and answer the question that follows.

    Various Expenditures (in percentage) incurred in Publishing a Book

    The marked price of a book is 20% more than the CP. If the marked price of the book is ₹30, then what is the cost of paper used in a single copy of the book?

  2. Study the given pie-charts and answer the question that follows.

    The pie-charts show the characteristics of foreign tourists visiting India during a given year.

    If in a given year, 2,50,000 tourists visited India and the age-wise distribution of data applies to all the countries, then the number of Russian tourists who visited India during the year and were in the age group above 50 years is:

  3. A battery manufacturer manufactures five different types of batteries. The total revenue for the year 2020 is Rs.25,00,000, and 20,000 units were exported in 2020. The distribution of revenue and units for the five different types of batteries is shown in the charts.

    Which type of battery provides the lowest revenue per unit?

  4. The average of two numbers is M. If one number is N, then the other number is:

  5. Study the following pie-chart and answer the question that follows:

    The following pie-chart shows the breakup of the percentage sale of motorcycles by different companies in India in the year 2021.

    If the total motorcycles sold in India in the year 2021 was 25,00,000, then what was the number of motorcycles sold by GTM in India in the year 2021?

Need Expert Advice?

Start Your Preparation with Prepp Mobile App

Download the app from Google Play & App Store
Download the app from Google Play & App Store
Prepp Mobile App