Excel Chapter 6: Exam
To add a shape to a lower level of an organization chart, click Add Shape, and then click:
Add Shape Below.
Which of the following SmartArt graphic categories would be used to show a timeline?
Process
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.
SmartArt graphic
Which of the following is NOT a type of sparkline?
Trend
The entire chart with all of its elements is called the:
chart area.
By default, Excel displays a chart as a(n) ________ object within the worksheet.
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
All shapes in an organization chart must be the same color.
false
Line charts MUST consist of only one line.
false
When a template is opened from Windows File Explorer, it is opened as a(n):
Excel Workbook (*.xlsx)
Effects can be added to SmartArt diagrams from the ________ tab.
FORMAT
The SmartArt organization chart is in the ________ category.
Hierarchy
When you save a template on your own computer to the template folder, it will be available for future use from:
My templates.
________ prevents anyone from changing a workbook.
Protection
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 group of related data plotted in a chart is called a:
data series
Charts and SmartArt graphics depend on underlying data in a worksheet.
false
If you need to make changes to a template, it is not necessary to remove protection.
false
New shapes cannot be added to a SmartArt graphic.
false
Once you have created a chart, it is not possible to change the range of data that is displayed.
false
Standardization means designing a workbook so that individuals cannot enter data into cells.
false
Templates can only be used on the computer on which they are created.
false
To select all the columns that represent a data series in a column chart, you must click on each column individually.
false
You should plot both totals and details on the same chart.
false
Templates can have built-in ________ for performing calculations based on the data you enter.
formulas
To create a column chart, you must first select the ________ data to be plotted.
labels
When you create a chart, Excel uses the column and row headings that describe the values as ________ for the data.
labels
The Text Pane displays to the ________ of the SmartArt diagram.
left
If there is only one line in a line chart, you should delete the:
legend
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 may add an optional ________ to prevent someone from disabling the worksheet protection.
password
The Text Pane includes ________ in which text can be typed.
placeholders
All cells are locked by default, but the locking feature is only enabled when ________ is applied.
protection
To prevent others from changing the formulas and formatting of a worksheet, you should use:
protection
If you try to enter data in a protected cell, a message appears informing you that the cell is protected and therefore:
read-only.
The ________ is the range of numbers in the data series that controls the minimum, maximum, and incremental values on the value axis.
scale
To delete a box from a SmartArt organization chart, you must display a ________ border.
solid line
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:
standardization
Templates are commonly used to provide ________ of data.
standardization and protection
To enhance the appearance of sparklines, use:
styles
To help choose the best type of chart for your data, use:
styles
Sparklines are:
tiny charts that fit within a cell.
When you create a chart, you must first decide if you are going to plot values representing:
totals OR details.
A SmartArt graphic is a visual representation of information and ideas.
true
A data series is a group of related data.
true
An organization chart depicts reporting relationships within an organization.
true
As you type in the Text Pane, the text appears simultaneously in the SmartArt graphic.
true
Charts and diagrams communicate data visually.
true
Excel includes predesigned templates.
true
High Point, Low Point, and Last Point markers can be used to further emphasize the visual story that sparklines depict.
true
Organizations use standardization and protection when creating templates for commonly used forms.
true
Preformatted SmartArt styles can be applied from the DESIGN tab.
true
Sparklines give a visual trend summary alongside your data.
true
To apply an effect to shapes in an organization chart, you must hold Ctrl and click on all shapes individually to select them.
true
When a template design is complete, you should enable protection.
true
When selecting a range of cells for a chart, it is sometimes necessary to include an empty cell in the selection.
true
When you open a template from the Templates folder in Backstage view, a new copy of the template opens as a workbook.
true
You can change the values on the value axis to increase or decrease the variations among the numbers displayed.
true
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.
unlock
Column charts present data graphically in ________ columns.
vertical
If the Select locked cells option is selected in the Protect Sheet dialog box, the user can click the locked cells and ________ the formulas.
view
When a template is opened from the New tab in the Backstage view, it is opened as a(n):
workbook
