Chapter 6
SmartArt graphic
A ________ is a visual representation of information and ideas that you can create by choosing from among many different layouts to communicate your message easily and effectively.
data series
A group of related data plotted in a chart is called a:
protection
All cells are locked by default, but the locking feature is only enabled when ________ is applied.
embedded
By default, Excel displays a chart as an _____ object within the worksheet.
chart sheet
Charts can be placed on a separate sheet called a:
vertical
Column charts present data graphically in ________ columns.
FORMAT
Effects can be added to SmartArt diagrams from the ________ tab.
view
If the Select locked cells option is selected in the Protect Sheet dialog box, the user can click the locked cells and ________ the formulas.
legend
If there is only one line in a line chart, you should delete the:
read-only
If you try to enter data in a protected cell, a message appears informing you that the cell is protected and therefore:
standardization
If you want all of the forms within an organization to have a uniform appearance and the data organized in the same way, you should use:
chart elements
Objects that make up a chart are called:
tiny charts that fit within a cell
Sparklines are:
standardization and protection
Templates are commonly used to provide ________ of data.
formulas
Templates can have built-in ________ for performing calculations based on the data you enter.
Hierarchy
The SmartArt organization chart is in the ________ category.
left
The Text Pane displays to the ________ of the SmartArt diagram.
placeholders
The Text Pane includes ________ in which text can be typed.
scale
The ________ is the range of numbers in the data series that controls the minimum, maximum, and incremental values on the value axis.
chart area
The entire chart with all of its elements is called the:
legend
The key that defines the colors assigned to categories in a chart is called a(n):
Add Shape Below
To add a shape to a lower level of an organization chart, click Add Shape, and then click:
labels
To create a column chart, you must first select the ________ data to be plotted.
unlock
To create a form for others to complete, you should first ________ the cells that will need to be filled in and then protect the workbook.
solid line
To delete a box from a SmartArt organization chart, you must display a ________ border.
line
To display trends over time, use a ________ chart.
styles
To enhance the appearance of sparklines, use:
styles
To help choose the best type of chart for your data, use:
column
To make comparisons among related data, use a ________ chart.
protection
To prevent others from changing the formulas and formatting of a worksheet, you should use:
Excel Workbook (*.xlsx)
When a template is opened from Windows File Explorer, it is opened as a(n):
workbook
When a template is opened from the New tab in the Backstage view, it is opened as a(n):
empty cell
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.
labels
When you create a chart, Excel uses the column and row headings that describe the values as ________ for the data.
totals OR details
When you create a chart, you must first decide if you are going to plot values representing:
password
When you protect a worksheet, you may add an optional _____ to prevent someone from disabling the worksheet protection.
My templates
When you save a template on your own computer to the template folder, it will be available for future use from:
Process
Which of the following SmartArt graphic categories would be used to show a timeline?
Trend
Which of the following is NOT a type of sparkline?
Protection
________ prevents anyone from changing a workbook.