Exam 7: Excel : Charts

In the task pane, what does a diagonal white triangle next to a chart category indicate?

Which group on the Design tab would you select if you wanted to change the source information in the chart?

A(n)________ is a cell that contains a value used in a chart.

What can you not do from the Select Data Source dialog box?

As a general rule, Pie charts should be limited to how many slices?

You can switch the rows and columns in a chart to communicate a different perspective on your data.

The ________ axis helps measure data from left to right in a graph.

Match the following terms with their description (since the options are very similar, pick the most complete, descriptive answer): I. Clustered column chart II. Stacked column chart III. Column chart IV. 100% stacked column chart V. 3-D chart A. Changes individual data points to percentages B. Adds an additional dimension to your chart C. Columns are set side by side D. Compares individual points to the whole category E. Compares values across categories

It is good practice to delete any blank rows or columns before creating a chart.

You can link to a cell as the title of a chart.

It is important to select parallel ranges.

A group of data points used in a graph become a data ________.

If you are not sure which chart type to pick, it may be helpful to click ________ Charts in the Chart group.

In a bar chart, which axis displays the categories?

Which chart type displays the data horizontally?

Which of the following is not a chart element?

Match the following terms with their description: I. Line chart II. Pie chart III. Bar chart IV. Column chart V. Sparkline A. Uses horizontal bars B. Chart resides in one cell C. Line connect data points D. Uses slices to display data points E. Uses vertical bars

Do not use data ________ and individual values in a chart.

Match the following terms with their description: I. Parallel range II. Alt Text III. Exploded pie chart IV. Arrange V. Chart filter A. Text based interpretation B. Moves an object backward or forward C. Has the same starting and ending point D. Helps you to focus on particular data E. One or more pieces are separated from the others

Match the following terms with their description: I. Data labels II. Quick Layout III. Accessibility Compliance IV. Alt Text V. Sparklines A. Applying features to make it easier on disabled users B. Can be read by various devices C. Helps you use predefined layouts D. Easier to read than a legend E. Examples include: line, column, win\loss.