MOS - Microsoft Office Specialist Excel: Charting Data Questions and Answers

Question 1

A financial analyst wants to create a very small, simple chart inside a single cell to show the sales trend for a specific product over the last 12 months.
Which Excel feature should be used for this purpose?

Accepted Answer

Sparkline

Answer

Chart Sheet

Answer

PivotChart

Answer

Data Table

Question 2

When a chart is selected in Excel, two contextual tabs appear on the Ribbon, providing specific tools for chart manipulation. What are these two tabs called?

Accepted Answer

Chart Design and Format

Answer

Data and Review

Answer

Insert and Page Layout

Answer

View and Formulas

Question 3

You have created a column chart showing monthly sales, but you realize the data would be more effectively displayed with the months on the horizontal axis and the sales figures represented by the height of the columns. Currently, the opposite is shown. Which command should you use to correct this?

Accepted Answer

Switch Row/Column

Answer

Change Chart Type

Answer

Format Axis

Answer

Select Data

Question 4

A project manager is analyzing a line chart that displays sales data over the past three years. To better predict future performance, they want to add a line that shows the general direction of the data. Which chart element should they add?

Accepted Answer

Trendline

Answer

Error Bars

Answer

Legend

Answer

Gridlines

Question 5

A user has created a complex chart on a busy worksheet and now wants to move it to its own separate sheet to make it easier to view and present. Which of the following is the correct action to take?

Accepted Answer

Select the chart, go to the 'Chart Design' tab, and click 'Move Chart'.

Answer

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

Answer

Right-click the chart, select 'Format Chart Area', and choose a new location.

Answer

Select the chart, go to the 'Insert' tab, and click 'Move Chart'.

Question 6

To best illustrate the contribution of several product categories to the total annual sales, where each category is a part of the whole, which chart type is most appropriate?

Accepted Answer

Pie Chart

Answer

Line Chart

Answer

Scatter Plot

Answer

Histogram