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

A chart that is inserted into the same worksheet that contains the data used to create the chart is called ________.

A(n)________ is a special workbook that can include formatting,formulas,and other elements and that can be used as a pattern for creating other workbooks.

________ display alongside each row of data and provide a quick visual trend summary.

A(n)________ graphic is a visual representation of your information and ideas.

Specific cells in a protected worksheet can be ________ so that data can be entered.

A(n)________ depicts reporting relationships in an organization.

Match the following five chart elements to their descriptions: i.tick marks II.axis III.chart area IV.category labels v.plot area

To add text to a SmartArt graphic,you can type in the shape placeholders or you can open the ________.

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

When you create a chart,you must first decide if you are going to plot values representing ________.

An organization chart displays relationships within an organization.

An advantage to creating a(n)________ is that it can be made available to coworkers on a company intranet or to customers through a website.

Objects that make up a chart are called ________.

________ is a feature that prevents anyone from altering the formulas or changing other template components.

When a template design is complete,you should enable protection.

You can change the values on the value axis to increase or decrease the variations among the numbers displayed.

Sparklines are ________.

A(n)________ is a graphic representation of data.

The Text Pane includes ________ in which you can type text into a SmartArt graphic.

Match the following five terms to their meanings. i.chart elements II.recommended charts III.vertical value axis IV.horizontal category axis v.data series