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

Sparklines are miniature charts that reside within a single cell, designed to provide a quick, simple visual representation of data trends without taking up much space. A full chart sheet, PivotChart, or data table would be too large and complex for this requirement.

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

When you select a chart object, Excel displays contextual tools to help you work with it. The two tabs that appear under 'Chart Tools' are 'Chart Design' (for changing chart type, layout, styles, and data) and 'Format' (for formatting shapes, fills, and text).

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

The 'Switch Row/Column' command, located on the 'Chart Design' contextual tab, swaps the data being plotted on the horizontal (category) and vertical (value) axes. This is the most direct way to flip the data orientation without recreating the chart or manually editing the data source.

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

A Trendline is a chart element used to graphically display trends in data and to help analyze problems of prediction. It can be used to forecast future values based on past data. Error Bars, Legends, and Gridlines serve different purposes related to showing uncertainty, identifying series, and aiding readability.

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

The 'Move Chart' command, found on the 'Chart Design' contextual tab, opens a dialog box that allows the user to place the chart in a new, dedicated chart sheet or as an object in another existing worksheet. While copy-pasting works, the 'Move Chart' feature is the designated and most efficient method.

MOS - Microsoft Office Specialist Certification Practice Test

MOS - Microsoft Office Specialist Certification Practice Test

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