Exam 3: Determining Effective Data Display with Charts

In a line chart, values are indicated by the filled areas below the lines.

In the Open-High-Low-Close chart sub-type, ____ is used to show if the stock closed at a higher or lower price than its opening price.

When tracking stock prices, the term crawling average is used because the average is calculated each day for the last 30 days-moving the average along the chart. _________________________

Any changes to the data label content must be made using the Format Data Labels task pane. _________________________

The ____ chart sub-type adds information on the opening price of the stock to the High-Low-Close information for the time period.

Excel provides 10 standard chart types, with 53 sub-types that can be used to present information graphically. _________________________

To compare the contribution each value in a single data series makes to the whole, or 100%, use a pie chart.

Excel datalines are small, word-sized graphics placed within the images or words they represent. _________________________

You can modify the location of a chart at any time using the _____ dialog box.

Radar charts are named for their resemblance to the plots on radar screens as they scan a 360-degree circle. _________________________

____________________ are small word-sized charts or graphics embedded within the words, numbers, and images they represent.

The ____ gallery in the Insert Shapes group on the CHART TOOLS FORMAT tab contains a variety of shapes that can be added to a chart.

____ charts allow three-dimensional data to be plotted in 2-D on two axes.

In a bubble chart, the larger the bubble, the _____ the value.

List and explain briefly the five guidelines given by Edward R. Tufte.

The ____ option of splitting a pie data series into a second, smaller pie chart allows you to drag individual pie segments between the two charts so you can include exactly the segments you want in the main pie chart and the second plot.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#2

____ identify the data values plotted on the y-axis.

According to Tufte, ____ can make charts difficult to read, use, and interpret.

A data series is composed of related data points that are plotted on a chart.