FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

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: -Pie charts are used to show parts of a whole. Specifically, pie charts illustrate meaningful relationships between percentages or parts of 100%. If the data which we want to display add up to 100%, a pie chart is the best choice.

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: -With a pie chart in Excel, you can see a representation of the total amount, and then the percentage that each value has of that total. It might be easier to compare the values, if you create a bar chart such as this one, which easily shows the difference between each region, or in a column chart like this one.

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.