Excel: Charting Data Flashcards

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?

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.

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?

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).

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?

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.

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?

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.

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?

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.

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?

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.