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