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

A ________ is a graphic representation of trends in a data series.

If you try to enter data in a protected cell,a message displays informing you that the cell is protected and therefore ________.

If you need to make changes to a template,you must first remove protection.

The entire chart with all of its elements is called the ________.

Sparklines are tiny charts that fit within a cell and give a visual trend summary alongside your data.

Match the following five terms to their meanings: i.Text Pane II.Organization chart III.Hierarchy IV.SmartArt graphic v.Picture

The Process SmartArt graphic can show steps in a timeline.

After an Excel template is complete,you should ________ it before it is ready to use.

When you protect a worksheet,you can add an optional ________ to prevent someone from disabling a worksheet's protection.

________ charts can show trends over time.

Both the Text Pane and the SmartArt graphic contain ________ in which you can type text.

A chart is a graphic representation of data.

A line chart can have only one line.

Match the following categories of SmartArt graphic types with their descriptions: i.Matrix II.Cycle III.List IV.Process v.Relationship

An Excel template is saved with the ________ extension.

The key that defines the colors assigned to categories in a chart is called a(n)________.

To create sparklines,first select the data you want to plot.

The Text Pane is populated with placeholder text that you replace with your information.

You can add effects,for example a bevel,to a SmartArt graphic.

Match the following five terms to their meanings: i.legend II.line chart III.scale IV.trendline v.plot area