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

Column charts present data graphically in ________ columns.

A SmartArt graphic is a visual representation of information and ideas.

You can add an optional ________ to prevent others from disabling worksheet protection.

After text is entered and formatted in your template,add ________ to the cells where you want the result of the calculations to display.

To create an organization chart,insert a ________ graphic from the Illustrations group on the Insert tab.

To delete a box from a SmartArt organization chart,a ________ border must display around the box.

Match the following five chart elements to their descriptions: i.data labels II.data marker III.data points IV.data series v.gridlines

________ are workbooks you use as the basis for other similar workbooks.

A vertical dotted line displaying in the worksheet indicates where a page will end if the worksheet were ________ as currently set up.

If you want all of the forms within an organization to have a uniform appearance and have the data organized in the same manner,you should use ________.

A ________ is a graphic representation of data.

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

A ________ is a visual representation of information and ideas.

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

When you open a ________ from the default location on your computer,Excel opens a new copy of it as a workbook and preserves the original.

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

Charts can be placed on a separate sheet called a ________.

When selecting a range of cells for a chart,it is sometimes necessary to include an empty cell in the selection.

To prevent others from altering the formulas or changing other template components,you should use ________.

When selecting the range for a line chart,you may need to include a(n)________ to have the same number of cells in each row.