Microsoft Excel Creating and Managing Charts Questions and Answers

Question 1

A colleague has created a chart to show monthly sales figures and the corresponding percentage of total annual sales.
The sales figures (in dollars) and percentages are on vastly different scales, making the chart difficult to read.
Which of the following is the BEST solution to improve the chart's readability?

Accepted Answer

Use a combination chart and plot the percentage data on a secondary axis.

Answer

Change the chart type to a 3-D pie chart.

Answer

Add data labels to both data series and remove the vertical axis.

Answer

Increase the font size of the axis labels for better visibility.

Question 2

You have created a column chart embedded in a worksheet, but you need to present it on its own for a presentation. Which is the most efficient way to move the chart to its own dedicated sheet?

Accepted Answer

Select the chart, navigate to the 'Chart Design' tab, and use the 'Move Chart' command to place it in a 'New sheet'.

Answer

Copy the chart, create a new worksheet, and paste the chart.

Answer

Use the 'Cut' and 'Paste' commands to move the chart to a new sheet.

Answer

Right-click the chart, select 'Format Chart Area', and choose the 'Move to New Sheet' option.

Question 3

Which of the following chart elements provides a key to identify the different data series represented by colors, patterns, or symbols in a chart?

Accepted Answer

Legend

Answer

Chart Title

Answer

Data Labels

Answer

Axis Titles

Question 4

A manager asks you to quickly hide the data for the 'North' region from a sales chart without deleting the underlying data. Which is the quickest method to achieve this?

Accepted Answer

Select the chart and use the Chart Filters (funnel icon) to deselect the 'North' category.

Answer

Delete the 'North' region's rows from the source data table.

Answer

Right-click the 'North' data series and select 'Hide'.

Answer

Change the fill color of the 'North' data series to 'No Fill'.

Question 5

You are analyzing weekly performance data and want to show a miniature trendline for each employee within a single cell, right next to their name and total sales. Which Excel feature should you use?

Accepted Answer

Sparklines

Answer

A regular Line Chart

Answer

Conditional Formatting Data Bars

Answer

A Scatter Plot

Question 6

To change the chart type for a single data series in an existing chart, effectively creating a combination chart, what is the first step?

Accepted Answer

Right-click the specific data series you want to change.

Answer

Select the entire chart area.

Answer

Go to the 'Insert' tab and select a new chart type.

Answer

Double-click the horizontal axis.