FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Excell: Creating Charts, Diagrams, and Templates

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

Both charts and SmartArt graphics depend on underlying data in a worksheet.

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

The ________ controls the minimum,maximum,and incremental values on the value axis.

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

When creating a column chart,selecting ________ for the data helps the reader understand the chart.

The ________ is the range of numbers in the data series and that controls the minimum,maximum,and incremental values on the value axis.

The chart element that identifies the patterns or colors that are assigned to the categories in the chart is the ________.

Which of the following SmartArt graphic categories would be best to show a timeline?

The Select locked cells option enables you to click the locked cell and ________ the formulas.

A(n)________ graphic is a graphical tool that depicts ideas or associations.

All shapes in an organization chart must be the same color.

When you open a template from the Templates folder in Backstage view,a new copy of the template opens as a workbook.

To make comparisons among related data,use a ________ chart.

As you create a chart,you can make choices about what data to include.

A Process SmartArt graphic can display steps in a process or a ________.

The entire chart and all of its elements comprise the ________.

Excel includes predesigned templates,for example for a budget.

To display trends over time,use a ________ chart.

Templates can only be used on the computer on which they are created.

The two main reasons for creating templates for commonly used forms in an organization are ________.

In order for individuals completing your form to type their data into designated cells,the cells must be ________.

You cannot add additional shapes to a SmartArt graphic.