USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
True or False:All chart types are interchangeable. For example, data suitable for a pie chart will also always work as a scatter chart.
|
|
False
|
|
|
True
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -For the most part, bar charts and column charts can be used interchangeably.
Detailed explanation-2: -Pie charts are used for nominal or categorical data. When there are many levels to your variable, a bar chart or packed bar chart may provide a better visualization of your data.
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: -False: Achart is updated automatically with the change in data. You can modify the chart by changing its colours and patterns.
There is 1 question to complete.