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

A combination chart allows you to use different chart types for different data series. By plotting the percentage data, which has a much smaller scale, on a secondary vertical axis, you can clearly visualize both the dollar amounts and the percentages on the same chart without distortion.

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

The 'Move Chart' command, found on the 'Chart Design' contextual tab, is the dedicated tool for this purpose. It allows you to move the chart to a new, dedicated chart sheet or as an object in another existing worksheet.

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

The legend is a key component of a chart that explains what the different colors, patterns, or symbols used for the data series represent, making the chart easier to understand.

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

The Chart Filters button, which appears next to a selected chart, is designed to quickly show or hide data series or categories directly on the chart without altering the source data.

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

Sparklines are miniature charts that reside in a single cell, designed to provide a quick visual representation of data trends. They are perfect for showing trends in a series of values, like weekly performance, in a compact space.

Excel Practice Test

Excel Practice Test

Microsoft Excel Creating and Managing Charts Questions and Answers