USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Showing optimum combinations between the two sets of data
|
|
|
Comparing invidual items
|
|
|
Showing the realtionship of parts to a whole with more data series
|
|
|
Showing changes to data at regular intervals
|
Detailed explanation-1: -Just like a pie chart, a doughnut chart shows the relationship of parts to a whole, but a doughnut chart can contain more than one data series. Each data series that you plot in a doughnut chart adds a ring to the chart. The first data series is displayed in the center of the chart.
Detailed explanation-2: -Donut charts are used to show the proportions of categorical data, with the size of each piece representing the proportion of each category. A donut chart is created using a string field and a count of features, number, or rate/ratio field.
Detailed explanation-3: -The pie chart and the donut chart display the relation between values as well as the relation of a single value to the total. You can use a pie chart when you have a single data series with only positive values. You can use a donut chart when you have a single data series that includes negative values.
Detailed explanation-4: -Pie charts They use segments of a circle to show the relationship of parts to the whole.
Detailed explanation-5: -Pie charts show the size of items in one data series, proportional to the sum of the items. The data points in a pie chart are shown as a percentage of the whole pie. Consider using a pie chart when: You have only one data series.