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.