ITE 140 EXAM 2 | QUESTIONS AND ANSWERS | 2026 UPDATE |
VERIFIED 100% CORRECT.
A ________ is a graphic representation of data. - (answer)chart
A ________ is a graphic representation of trends in a data series. - (answer)trendline
A ________ is a visual representation of information and ideas. - (answer)SmartArt graphic
A chart that is inserted into the same worksheet that contains the data used to create the chart is called
________. - (answer)embedded
A group of related data plotted in a chart is called a data ________. - (answer)series
After text is entered and formatted in your template, add ________ to the cells where you want the
result of the calculations to display. - (answer)formulas
An Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in
your data is called ________. - (answer)Recommended Charts
An organization chart depicts ________ within an organization. - (answer)reporting relationships
Charts can be placed on a separate sheet called a ________. - (answer)Chart sheet
Column and row titles that describe the values in the column or row are known as ________. -
(answer)labels
Column charts present data graphically in ________ columns. - (answer)vertical
If you need to make changes to a template after it is protected, you must first remove the ________. -
(answer)protection
, ITE 140 EXAM 2 | QUESTIONS AND ANSWERS | 2026 UPDATE |
VERIFIED 100% CORRECT.
If you try to enter data in a protected cell, a message displays informing you that the cell is protected
and therefore ________. - (answer)read-only
If you want all of the forms within an organization to have a uniform appearance and have the data
organized in the same manner, you should use ________. - (answer)standardization
In order for individuals completing your form to type their data into designated cells, the cells must be
________. - (answer)unlocked
Objects that make up a chart are called ________. - (answer)chart elements
Sparklines are ________. - (answer)tiny charts that fit within a cell and give a visual trend summary
alongside your data
Templates can have built-in ________ that display the results of calculations based on the data that is
entered into the template. - (answer)formulas
The Select locked cells option enables you to click the locked cell and ________ the formulas. -
(answer)view
The Text Pane displays to the ________ of the SmartArt diagram. - (answer)left
The Text Pane includes ________ in which you can type text into a SmartArt graphic. -
(answer)placeholders
The ________ is the range of numbers in the data series and that controls the minimum, maximum, and
incremental values on the value axis. - (answer)scale
VERIFIED 100% CORRECT.
A ________ is a graphic representation of data. - (answer)chart
A ________ is a graphic representation of trends in a data series. - (answer)trendline
A ________ is a visual representation of information and ideas. - (answer)SmartArt graphic
A chart that is inserted into the same worksheet that contains the data used to create the chart is called
________. - (answer)embedded
A group of related data plotted in a chart is called a data ________. - (answer)series
After text is entered and formatted in your template, add ________ to the cells where you want the
result of the calculations to display. - (answer)formulas
An Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in
your data is called ________. - (answer)Recommended Charts
An organization chart depicts ________ within an organization. - (answer)reporting relationships
Charts can be placed on a separate sheet called a ________. - (answer)Chart sheet
Column and row titles that describe the values in the column or row are known as ________. -
(answer)labels
Column charts present data graphically in ________ columns. - (answer)vertical
If you need to make changes to a template after it is protected, you must first remove the ________. -
(answer)protection
, ITE 140 EXAM 2 | QUESTIONS AND ANSWERS | 2026 UPDATE |
VERIFIED 100% CORRECT.
If you try to enter data in a protected cell, a message displays informing you that the cell is protected
and therefore ________. - (answer)read-only
If you want all of the forms within an organization to have a uniform appearance and have the data
organized in the same manner, you should use ________. - (answer)standardization
In order for individuals completing your form to type their data into designated cells, the cells must be
________. - (answer)unlocked
Objects that make up a chart are called ________. - (answer)chart elements
Sparklines are ________. - (answer)tiny charts that fit within a cell and give a visual trend summary
alongside your data
Templates can have built-in ________ that display the results of calculations based on the data that is
entered into the template. - (answer)formulas
The Select locked cells option enables you to click the locked cell and ________ the formulas. -
(answer)view
The Text Pane displays to the ________ of the SmartArt diagram. - (answer)left
The Text Pane includes ________ in which you can type text into a SmartArt graphic. -
(answer)placeholders
The ________ is the range of numbers in the data series and that controls the minimum, maximum, and
incremental values on the value axis. - (answer)scale
