FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Excel : Charts

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

It is important to select parallel ranges.

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

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

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

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

Which chart type displays the data horizontally?

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

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

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

In a bar chart, which axis displays the categories?

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

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

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

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

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

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

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

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

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.