ITE 140 Chapter 6 Quiz_ Exam 2
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
When you open a template from Custom Office Templates folder, it opens as a(n)_______
Excel Template
Which of the following SmartArt graphic categories would be best to show a timeline
Process
To prevent others from altering the formulas or changing other templates 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 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
______ are workbooks you can use as the bases for other similar workbooks.
Templates
The entire chart with all of its elements if called the _____
chart arear
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 is inserted into the same worksheet that contains the data used to create the chart is called ______
embedded
When electing 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 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
The key that defines the colors assigned to categories in a chart is called a (n) ____.
legend
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 worksheets 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
plat area
If you need to make charges to a template after it is protected, you must first remove the _______.
protection
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 values axis
scale
A group of related data plotted in a chart is called data _______.
series
To delete a box from a SmartArt organization chart, a _____ border must display around the box.
soldline
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
Sparklines are ____.
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 ______
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 the Backstage view, it opens as a(n)_____
workbook