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

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

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

A group of related data plotted in a chart is called a data ________.

When you open a template from the Custom Office Templates folder,it opens as a(n)________.

Templates can have built-in ________ that display the results of calculations based on the data that is entered into the template.

Match the following five terms to their meanings: i.Template II.Standardization III.Protection IV.WordArt v.Rotation Handle

A data series is a group of related data points that are plotted in a chart.

The area bounded by the axes,including all the data series is called ________.

________ prevents anyone from changing a workbook.

Match the following five terms to their meanings: i.sparklines II.column chart III.labels IV.embedded chart v.chart sheet

The Text Pane displays to the ________ of the SmartArt diagram.

Match the following five terms to their meanings: i.Password II.Protect Sheet dialog box III.Locked cells IV.Select locked cells v.Unlocked Cells

Column and row titles that describe the values in the column or row are known as ________.

An organization chart depicts ________ within an organization.

When you open a template from the New tab in the Backstage view,it opens as a(n)________.

If you need to make changes to a template after it is protected,you must first remove the ________.

Organizations use standardization and protection when creating templates for commonly used forms.

When you select the chart type,the resulting chart will contain elements that you can delete or change.

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

Match the following five chart elements to their descriptions: i.Major unit value II.x-axis III.y-axis IV.tick mark labels v.walls and floor