FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which chart type is used to show the optimum combinations between the two sets of data?
A
Column
B
Pie
C
Scatter
D
Surface
Explanation: 

Detailed explanation-1: -This chart is useful when you want to find optimum combinations between two sets of data. As in a topographic map, colors and patterns indicate areas that are in the same range of values. You can create a surface chart when both categories and data series are numeric values.

Detailed explanation-2: -A Dual Axis Line Chart is one of the best graph to compare two sets of data. The chart has a secondary y-axis to help you display insights into two varying data points. More so, it uses two axes to easily illustrate the relationships between two variables with different magnitudes and scales of measurement.

Detailed explanation-3: -You can emphasize different types of data, such as Temperature and Precipitation, by combining two or more chart types in one Combo chart. Different types of data, often, have different value ranges and with a Combo chart, you can include a secondary axis.

Detailed explanation-4: -A Surface chart is useful when you want to find the optimum combinations between two sets of data.

Detailed explanation-5: -Bar charts are good for comparisons, while line charts work better for trends. Scatter plot charts are good for relationships and distributions, but pie charts should be used only for simple compositions-never for comparisons or distributions.

There is 1 question to complete.