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