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

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

Which of the following is not a chart element?

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

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

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

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 important to select parallel ranges.

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.

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

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

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

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

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

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

In a bar chart, which axis displays the categories?

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

Which chart type displays the data horizontally?

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