MOS - Microsoft Office Specialist Excel: Charting Data Questions and Answers — 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?
- Chart Sheet
- Sparkline (Correct answer)
- PivotChart
- Data Table
Correct answer: Sparkline
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?
- Data and Review
- Insert and Page Layout
- Chart Design and Format (Correct answer)
- View and Formulas
Correct answer: Chart Design and Format
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?
- Change Chart Type
- Format Axis
- Select Data
- Switch Row/Column (Correct answer)
Correct answer: Switch Row/Column
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?
- Trendline (Correct answer)
- Error Bars
- Legend
- Gridlines
Correct answer: Trendline
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?
- Copy the chart, create a new worksheet, and paste the chart.
- Right-click the chart, select 'Format Chart Area', and choose a new location.
- Select the chart, go to the 'Insert' tab, and click 'Move Chart'.
- Select the chart, go to the 'Chart Design' tab, and click 'Move Chart'. (Correct answer)
Correct answer: Select the chart, go to the 'Chart Design' tab, and click 'Move Chart'.
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.
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?
- Line Chart
- Scatter Plot
- Pie Chart (Correct answer)
- Histogram
Correct answer: Pie Chart
A Pie Chart is the ideal chart type for showing the proportions of individual parts to a whole. Each slice represents a category's percentage of the total. A Line Chart shows trends over time, a Scatter Plot shows relationships between variables, and a Histogram shows frequency distribution.
MOS - Microsoft Office Specialist Excel: Charting Data Questions and Answers
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?