ITE 140 Module 6
Changing a cell's orientation is useful when you need to create a label in a narrow
column. - CORRECT ANSWER-True
If you need to make changes to a template after it is protected, you must first remove
the protection. - CORRECT ANSWER-True
Matrix is a category of SmartArt graphics that shows how parts relate to a whole. -
CORRECT ANSWER-True
Templates can only be used on the computer on which they are created. -
CORRECT ANSWER-False
When a template design is complete, the worksheet is automatically protected. -
CORRECT ANSWER-False
When you open a template from the New tab in Backstage view, a new copy of the
template opens as a workbook. - CORRECT ANSWER-True
________ are workbooks you use as the basis for other similar workbooks. -
CORRECT ANSWER-Templates
________ display alongside each row of data and provide a quick visual trend
summary. - CORRECT ANSWER-Sparklines
________ is a feature that enables you to rotate text diagonally or vertically in a cell.
- CORRECT ANSWER-Orientation
________ means that all forms created within the organization will have a uniform
appearance; the data will always be organized in the same manner. - CORRECT
ANSWER-Standardization
After text is entered and formatted in your template, add ________ to the cells where
you want the result of the calculations to display. - CORRECT ANSWER-formulas
A chart that displays as an object in the worksheet is called a(n) ________ chart. -
CORRECT ANSWER-embedded
A ________ chart shows values across the stages in a process, and these values
typically decrease gradually. - CORRECT ANSWER-funnel
A group of related data points that are plotted in a chart is called a data ________. -
CORRECT ANSWER-series
Changing a cell's orientation is useful when you need to create a label in a narrow
column. - CORRECT ANSWER-True
If you need to make changes to a template after it is protected, you must first remove
the protection. - CORRECT ANSWER-True
Matrix is a category of SmartArt graphics that shows how parts relate to a whole. -
CORRECT ANSWER-True
Templates can only be used on the computer on which they are created. -
CORRECT ANSWER-False
When a template design is complete, the worksheet is automatically protected. -
CORRECT ANSWER-False
When you open a template from the New tab in Backstage view, a new copy of the
template opens as a workbook. - CORRECT ANSWER-True
________ are workbooks you use as the basis for other similar workbooks. -
CORRECT ANSWER-Templates
________ display alongside each row of data and provide a quick visual trend
summary. - CORRECT ANSWER-Sparklines
________ is a feature that enables you to rotate text diagonally or vertically in a cell.
- CORRECT ANSWER-Orientation
________ means that all forms created within the organization will have a uniform
appearance; the data will always be organized in the same manner. - CORRECT
ANSWER-Standardization
After text is entered and formatted in your template, add ________ to the cells where
you want the result of the calculations to display. - CORRECT ANSWER-formulas
A chart that displays as an object in the worksheet is called a(n) ________ chart. -
CORRECT ANSWER-embedded
A ________ chart shows values across the stages in a process, and these values
typically decrease gradually. - CORRECT ANSWER-funnel
A group of related data points that are plotted in a chart is called a data ________. -
CORRECT ANSWER-series