USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Bar Chart
|
|
Column Chart
|
|
Pie Chart
|
|
None of the above
|
Detailed explanation-1: -Pie charts can be used to show percentages of a whole, and represents percentages at a set point in time. Unlike bar graphs and line graphs, pie charts do not show changes over time. The following pages describe the different parts of a pie chart.
Detailed explanation-2: -Pie charts are used to show parts of a whole. A pie chart represents numbers in percentages, and the total sum of all the divided segments equals 100 percent.
Detailed explanation-3: -Reading Pie Charts To calculate the percentage each slice is worth, measure the angle of each slice and divide this by 360 then multiply it by 100 . To find the number of pieces of data each slice represents, multiply the percentage that each slice is worth by the total number of the data sets.
Detailed explanation-4: -The entire “pie” represents 100 percent of a whole, while the pie “slices” represent portions of the whole.
Detailed explanation-5: -The sum of all the data is equal to 360°. The total value of the pie is always 100%.