Quiz 6
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 ________ is a graphic representation of data.
Chart
An Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data is called ________.
Recommended Charts
A ________ is a visual representation of information and ideas.
SmartArt graphic
The entire chart with all of its elements is called the ________.
chart area
Objects that make up a chart are called ________.
chart elements
Charts can be placed on a separate sheet called a ________.
chart sheet
To make comparisons among related data, use a ________ chart.
column
A chart that is inserted into the same worksheet that contains the data used to create the chart is called ________.
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.
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.
formulas
Templates can have built-in ________ that display the results of calculations based on the data that is entered into the template.
formulas
Column and row titles that describe the values in the column or row are known as ________.
labels
When creating a column chart, selecting ______ for the data helps the reader understand the chart.
labels
The Text Pane displays to the ________ of the SmartArt diagram.
left
To display trends over time, use a ______ chart.
line
When you protect a worksheet, you can add an optional ________ to prevent someone from disabling a worksheet's protection.
password
The Text Pane includes ________ in which you can type text into a SmartArt graphic.
placeholders
The area bounded by the axes, including all the data series is called ________.
plot area
Which of the following SmartArt graphic categories would be best to show a timeline?
process
If you need to make changes to a template after it is protected, you must first remove the_________.
protection
To prevent others from altering the formulas or changing other template components, you should use ________.
protection
________ prevents anyone from changing a workbook.
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
An organization chart depicts ________ within an organization.
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.
scale
A group of related data plotted in a chart is called a data ________.
series
To delete a box from SmartArt organization chart, a ______border must display around the box.
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
The two main reasons for creating templates for commonly used forms in an organization are _________.
standardization and protection
________ are workbooks you use as the basis for other similar workbooks.
templates
Sparklines are ________.
tiny charts
When you create a chart, you must first decide if you are going to plot values representing ______.
totals or details
A ________ is a graphic representation of trends in a data series.
trendline
In order for individuals completing your form to type their data into designated cells, the cells must be ________.
unlocked
Column charts present data graphically in ________ columns.
vertical
The Select locked cells option enables you to click the locked cell and _______ the formulas.
view
When you open a template from the New tab in Backstage view, it opens as a(n)_________.
workbook