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]

John wants to create a chart that shows trends of sales for four quarters.What type of chart should he create?

A	PivotChart
B	LineChart
C	Embedded Chart
D	Linked Chart

Explanation:

Detailed explanation-1: -Column charts work easily for 4 quarters or 12 months. Within the column chart category, you can choose between 2-D and 3-D styles. If you want to highlight one component of a sales trend, you can use a stacked column chart.

Detailed explanation-2: -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-3: -What graphically represents trends in plotted data and predicts future values? Trendline.

Detailed explanation-4: -An embedded chart is defined as a chart that is inserted into a worksheet. The embedded chart is inserted into a spreadsheet using the insert option. The following are the types of chart: Pie chart. Bar chart.

There is 1 question to complete.