FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Edward would like to create a chart that shows the trend in iPod salesover the past 2 years. Which chart type should he create?

A	Bar
B	Column
C	Line
D	Pie

Explanation:

Detailed explanation-1: -A line chart is, therefore, the best chart to show trends over time. It shows trends and data variables clearly. Besides, a line graph assists readers with making predictions for the future. However, for a data set comparison being useful, you must use the same scale on both axes.

Detailed explanation-2: -Line charts are useful for showing trends over time and comparing many data series. Line charts plot data at regular points connected by lines.

Detailed explanation-3: -A Dual Axis Line Chart is one of the best graphs for presenting growth year-over-year. 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-4: -Click on Chart Options and select Horizontal (Value) Axis. Click the Axis Option Icon. Open the Axis Options dropdown triangle. Make changes to the Bounds, Units, and so on to adjust the time-scale to display the chart in the manner you wish.

There is 1 question to complete.