Chapter 6 Quiz, 20/20

To add a shape to a lower level of an organization chart, right-click the shape, click Add Shape, and then click ________.

Add Shape Below

A line that serves as a frame of reference for measurement and that borders the chart plot area.

Axis

Objects that make up a chart.

Chart elements

A workbook that contains only a chart.

Chart sheet

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

Embedded chart

A line chart can have only one line.

False

Standardization means designing a workbook so that individuals cannot enter data into cells.

False

You cannot add additional shapes to a SmartArt graphic.

False

You should plot both totals and details on the same chart.

False

Column and row headings that describe the values and help the reader understand the chart.

Labels

This prevents anyone from altering the formulas or changing other template components.

Protection

An Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data.

Recommended charts

Tiny charts that fit within a cell and give a visual trend summary alongside data.

Sparklines

A policy within an organization that all forms created within the organization will have a uniform appearance; the data will always be organized in the same manner.

Standardization

A special workbook that may include formatting, formulas, and other elements and is used as a pattern for creating other workbooks.

Template

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

True

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

True

A ________ is a graphic representation of data.

chart

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

trendline

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

view