USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A pie chart, sometimes called a circle chart, is a way of summarizing a set of nominal data or displaying the different values of a given variable (e.g. percentage distribution). This type of chart is a circle divided into a series of segments. Each segment represents a particular category.
Detailed explanation-2: -Do not use a pie chart if: Your dimension has too many categories. Similar percentages/numbers exist between different values within the chosen dimension. Data doesn’t represent a uniform “whole”, or the percentages don’t measure to 100 percent.
Detailed explanation-3: -Answer: A pie chart can only represent one data series. If you want to represent multiple then you need multiple pie charts.
Detailed explanation-4: -Pies and doughnuts fail because: Quantity is represented by slices; humans aren’t particularly good at estimating quantity from angles, which is the skill needed. Matching the labels and the slices can be hard work. Small percentages (which might be important) are tricky to show.