Question 1

An Excel template is saved with the ________ extension.

Accepted Answer

The answer of An Excel template is saved with the...

Question 2

The key that defines the colors assigned to categories in a chart is called a(n) ________.

Accepted Answer

A)  object
B)  element
C)  legend
D)  marker

Question 3

If you try to enter data in a protected cell,a message displays informing you that the cell is protected and therefore ________.

Accepted Answer

A)  read-only
B)  unlocked
C)  invalid
D)  embedded

Question 4

Both the Text Pane and the SmartArt graphic contain ________ in which you can type text.

Accepted Answer

The answer of Both the Text Pane and the SmartArt...

Question 5

The Text Pane is populated with placeholder text that you replace with your information.

Accepted Answer

A) True 
 B)False

Question 6

If you need to make changes to a template,you must first remove protection.

Accepted Answer

A) True 
 B)False

Question 7

After an Excel template is complete,you should ________ it before it is ready to use.

Accepted Answer

The answer of After an Excel template is complete,you should...

Question 8

Match the following categories of SmartArt graphic types with their descriptions:
i.Matrix
II.Cycle
III.List
IV.Process
v.Relationship

Accepted Answer

A)  Used to illustrate connections.
B)  Used to show how parts relate to a whole.
C)  Used to show steps in a process or timeline.
D)  Used to illustrate a continual process.
E)  Used to show nonsequential information.

Question 9

You can add effects,for example a bevel,to a SmartArt graphic.

Accepted Answer

A) True 
 B)False

Question 10

To create sparklines,first select the data you want to plot.

Accepted Answer

A) True 
 B)False

Question 11

Match the following five terms to their meanings:
i.Text Pane
II.Organization chart
III.Hierarchy
IV.SmartArt graphic
v.Picture

Accepted Answer

A)  A SmartArt graphic type that is useful to depict reporting relationships within an organization.
B)  A category of SmartArt graphics used to create an organization chart or show a decision tree.
C)  A category of SmartArt graphics used to display pictures in a diagram.
D)  A visual representation of your information and ideas.
E)  A window that displays to the left of a SmartArt Graphic to input and organize the text in the graphic.

Question 12

The Process SmartArt graphic can show steps in a timeline.

Accepted Answer

A) True 
 B)False

Question 13

A ________ is a graphic representation of trends in a data series.

Accepted Answer

A)  gridline
B)  line chart
C)  sparkline
D)  trendline

Question 14

A chart is a graphic representation of data.

Accepted Answer

A) True 
 B)False

Question 15

A line chart can have only one line.

Accepted Answer

A) True 
 B)False

Question 16

Sparklines are tiny charts that fit within a cell and give a visual trend summary alongside your data.

Accepted Answer

A) True 
 B)False

Question 17

Match the following five terms to their meanings:
i.legend
II.line chart
III.scale
IV.trendline
v.plot area

Accepted Answer

A)  The range of numbers in the data series that controls the minimum,maximum,and incremental values on the value axis.
B)  A chart element that identifies the patterns or colors that are assigned to the categories in the chart.
C)  A chart type that is useful to display trends over time.
D)  The area bounded by the axes,including all the data series.
E)  A graphic representation of trends in a data series.

Question 18

The entire chart with all of its elements is called the ________.

Accepted Answer

A)  plot area
B)  chart object
C)  chart element
D)  chart area

Question 19

When you protect a worksheet,you can add an optional ________ to prevent someone from disabling a worksheet's protection.

Accepted Answer

A)  lock
B)  legend
C)  scale
D)  password

Question 20

________ charts can show trends over time.

Accepted Answer

The answer of ________ charts can show trends over time....

Exam 6: Excell: Creating Charts, Diagrams, and Templates

A line chart can have only one line.

Correct AnswerverifiedShow Answer

Sparklines are tiny charts that fit within a cell and give a visual trend summary alongside your data.

Correct AnswerverifiedShow Answer

An Excel template is saved with the ________ extension.

Correct AnswerverifiedShow Answer

A ________ is a graphic representation of trends in a data series.

Correct AnswerverifiedShow Answer

The Process SmartArt graphic can show steps in a timeline.

Correct AnswerverifiedShow Answer

The key that defines the colors assigned to categories in a chart is called a(n) ________.

Correct AnswerverifiedShow Answer

After an Excel template is complete,you should ________ it before it is ready to use.

Correct AnswerverifiedShow Answer

A chart is a graphic representation of data.

Correct AnswerverifiedShow Answer

Match the following categories of SmartArt graphic types with their descriptions: i.Matrix II.Cycle III.List IV.Process v.Relationship

Correct AnswerverifiedShow Answer

To create sparklines,first select the data you want to plot.

Correct AnswerverifiedShow Answer

Match the following five terms to their meanings: i.Text Pane II.Organization chart III.Hierarchy IV.SmartArt graphic v.Picture

Correct AnswerverifiedShow Answer

Match the following five terms to their meanings: i.legend II.line chart III.scale IV.trendline v.plot area

Correct AnswerverifiedShow Answer

Both the Text Pane and the SmartArt graphic contain ________ in which you can type text.

Correct AnswerverifiedShow Answer

________ charts can show trends over time.

Correct AnswerverifiedShow Answer

When you protect a worksheet,you can add an optional ________ to prevent someone from disabling a worksheet's protection.

Correct AnswerverifiedShow Answer

You can add effects,for example a bevel,to a SmartArt graphic.

Correct AnswerverifiedShow Answer

If you try to enter data in a protected cell,a message displays informing you that the cell is protected and therefore ________.

Correct AnswerverifiedShow Answer

If you need to make changes to a template,you must first remove protection.

Correct AnswerverifiedShow Answer

The Text Pane is populated with placeholder text that you replace with your information.

Correct AnswerverifiedShow Answer

The entire chart with all of its elements is called the ________.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified