FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT HEADERS FOOTERS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which chart in Excel would best show the percentages of students’ favorite ice cream flavors?
A
Bar chart
B
Line Chart
C
Pie Chart
D
Scatter Chart
Explanation: 

Detailed explanation-1: -In Excel, a pie chart is a type of graph that you create to show proportions. For example, if you have data that shows the percentage of people who like different flavors of ice cream, you could use a pie chart to show those proportions.

Detailed explanation-2: -To display percentage values as labels on a pie chart On the design surface, right-click on the pie and select Show Data Labels. The data labels should appear within each slice on the pie chart.

Detailed explanation-3: -Pie charts are a popular way to show how much individual amounts contribute to a total amount. We use them to show proportions of a whole. Let’s explore when to use a pie chart, when not to use one, how to make a pie chart in Excel-basic and advanced, and how to customize pie charts to suit each situation.

Detailed explanation-4: -Pie-of-pie and bar-of-pie charts make it easier to see small slices of a pie chart. These chart types separate the smaller slices from the main pie chart and display them in a secondary pie-or stacked bar chart.

Detailed explanation-5: -Find the total of all values in the dataset. Divide each segment’s value by the total, to get the corresponding percentage of the total for the pie chart. Multiply this percentage by 360° to calculate the degrees for the pie chart segment. Create a sector with this degree measure in the pie chart.

There is 1 question to complete.