Module 5 Ch. 6 Quiz

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 Add Shape Above Add Shape After Add Shape Before

Add Shape Below

A ________ is a graphic representation of data. Style Legend Chart List

Chart

When you open a template from the Custom Office Templates folder, it opens as a(n) ________. Excel Workbook Excel Template Excel Macro-Enabled Workbook Excel Macro-Enabled Template

Excel Workbook

Which of the following SmartArt graphic categories would be best to show a timeline? List Pyramid Cycle Process

Process

________ prevents anyone from changing a workbook. Validation Embedding Protection Securing

Protection

A ________ is a visual representation of information and ideas. template chart area SmartArt graphic trendline

SmartArt graphic

________ are workbooks you use as the basis for other similar workbooks. Designs Page Layouts Common Reports Templates

Templates

The entire chart with all of its elements is called the ________. plot area chart object chart element chart area

chart area

Objects that make up a chart are called ________. chart data chart elements chart markers chart objects

chart elements

Charts can be placed on a separate sheet called a ________. design sheet chart sheet new sheet worksheet

chart sheet

To make comparisons among related data, use a ________ chart. line pie column scatter

column

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

embedded

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. total empty cell legend column

empty cell

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

formulas

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

formulas

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

labels

When creating a column chart, selecting ________ for the data helps the reader understand the chart. labels columns totals rows

labels

The Text Pane displays to the ________ of the SmartArt diagram. left bottom top right

left

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

legend

To display trends over time, use a ________ chart. line bar column pie

line

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

password

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

placeholders

The area bounded by the axes, including all the data series is called ________. data points chart area plot area format

plot area

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

protection

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

protection

If you try to enter data in a protected cell, a message displays informing you that the cell is protected and therefore ________. read-only unlocked invalid embedded

read-only

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

recommended charts

An organization chart depicts ________ within an organization. ranges SmartArt cycles reporting relationships

reporting relationships

The ________ is the range of numbers in the data series and that controls the minimum, maximum, and incremental values on the value axis. legend template scale matrix

scale

A group of related data plotted in a chart is called a data ________. point line series marker

series

To delete a box from a SmartArt organization chart, a ________ border must display around the box. solid line dashed line double line dotted line

solid line

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 ________. standardization protection validation equality

standardization

The two main reasons for creating templates for commonly used forms in an organization are ________. lookup and validation validation and standardization standardization and protection validation and relationship

standardization and protection

Sparklines are ________. the same as trendlines tiny charts that fit within a cell and give a visual trend summary alongside your data lines that connect the high point of columns the border that displays around a selected range

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 ________. columns OR details totals OR details sparklines OR trendlines columns OR trends

totals OR details

A ________ is a graphic representation of trends in a data series. gridline line chart sparkline trendline

trendline

In order for individuals completing your form to type their data into designated cells, the cells must be ________. selected unlocked password unprotected

unlocked

Column charts present data graphically in ________ columns. horizontal single diagonal vertical

vertical

The Select locked cells option enables you to click the locked cell and ________ the formulas. view delete modify format

view

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

workbook