Exam 12: Microsoft Excel 2010,workshop 4: Using Charts

A(n)________ chart would best be used if you wanted to display parts of a whole,such as comparing sales for four salespeople to see who has sold the largest percentage of goods.

Two chart types can be combined,for example,by overlaying a line chart on top of a column chart.

A bar chart is most similar in function to a(n)________ chart.

Which of the following chart types are most similar in function?

To compare data in groups vertically,use a(n)________ chart.

Which of the following statements regarding data series is FALSE?

To compare data in groups horizontally,use a(n)________ chart.

Which of the following chart types compares groups of data in a horizontal fashion?

A simple way to display change over time,without displaying colored layers,is by using a(n)________ chart.

All types of charts can be exploded.

A data point is made up of one or more data series.

Which of the following chart types are most similar in function?

Gridlines can be switched off,so that they do not display.

Both line charts and area charts are effective in displaying change over time.

A(n)________ chart is a variation of a stacked line chart that emphasizes the magnitude of change over time and visually depicts a trend.

Changing all numbers under 50 to red,numbers between 51 and 80 to yellow,and numbers above 80 to green can be done using a specialized data bar type called ________.

Lines added to a chart that use current data to show the general direction of the data are referred to as ________.

A(n)________ chart conveys the relationship between two variables.

Sparklines facilitate quick analysis of trends.