MGT 2180 EXAM STUDY GUIDE
Template - Answers - a prototype or workbook. Can include data, formula, formatting,
charts, images, controls, and more. Best for work that requires the same layout, design,
and data pattern each time you prepare a workbook.
Thumbnail - Answers - a tiny image of the activity sheet.
Data Validation - Answers - a process in which excel checks data as it is entered to
verify that it matches established requirements.
Validation Settings - Answers - rules applied to data as it is entered.
Input Message - Answers - a comment box that appears on screen as soon as a cell
with data validation is selected. An input message is a guideline for the person entering
the data.
Error Alert - Answers - pop-up message that appears after invalid data is entered.
Invalid Data - Answers - value or label that does not conform to validation criteria.
Circle Invalid Data - Answers - command that circles invalid data with a red ellipse is
placed around data that does not match the validation criteria.
The Form Button - Answers - creates a data-input screen for list-type data.
Data Input Form - Answers - a window or dialog box with labels and entry boxes in a
vertical layout.
Form Control - Answers - an object that you can use to display a choice, to run a
command, or to perform an action in a worksheet. Make data entry easier and can
improve the appearance of your work. Includes drop down lists, option buttons, or a
click check box.
Option Button - Answers - a radio button that allows the user to select one choice from a
set of possibilities.
Combo Box Control - Answers - creates a drop down list from which you select one
option
Worksheet Protection - Answers - allows you to choose which cells can be edited. A
simple way to prevent changes to your work.
, Shared Workbook - Answers - a workbook that multiple people can edit, either
simultaneously or at different times.
Change History - Answers - feature in shared workbook that maintains a record of each
edit. Includes name of user, date, and brief description of the change.
Comment - Answers - pop-up text box attached to a cell.
Metadata - Answers - embedded file properties such as user name and date at the time
of creation, the original file location and user comments. Some metadata can be
removed.
Document Inspector - Answers - dialog box that lists properties and data that can be
removed.
Compatibility Checker - Answers - can be opened by Check Compatibility command
and identifies commands, features, or objects that are not supported in earlier versions
of Excel. Ex. earlier versions of excel did not have SmartArt.
Protected View - Answers - workbooks with data from questionable sources open in
protected view so that you can confirm that you do trust the document and the source.
Trusted Location - Answers - a folder that is identified as one that stores workbooks that
are safe.
Scenario - Answers - a set of saved values in a worksheet allowing you to vary numbers
and see potential results. A what-if analysis tool. A worksheet can have up to 32
scenarios. The FIRST scenario you should create is one for the current data so that you
can return to it.
Scenario Summary Report - Answers - a generated worksheet that describes each
scenario in a workbook. You cannot edit a scenario after generating a summary report,
but you can create another scenario.
Goal-seek - Answers - a what-if analysis command that tests values in a cell to
backsolve a formula.
Backsolving - Answers - knowing the results and determining the value needed to reach
those results. *solves a formula for one cell (one argument)
Solver - Answers - an analysis tool that finds the lowest, highest, or a specific formula
by changing values in other cells within limitations that you set.
Solver Results - Answers - dialog box that will inform you if the solver could not find a
solution to your problem.
Template - Answers - a prototype or workbook. Can include data, formula, formatting,
charts, images, controls, and more. Best for work that requires the same layout, design,
and data pattern each time you prepare a workbook.
Thumbnail - Answers - a tiny image of the activity sheet.
Data Validation - Answers - a process in which excel checks data as it is entered to
verify that it matches established requirements.
Validation Settings - Answers - rules applied to data as it is entered.
Input Message - Answers - a comment box that appears on screen as soon as a cell
with data validation is selected. An input message is a guideline for the person entering
the data.
Error Alert - Answers - pop-up message that appears after invalid data is entered.
Invalid Data - Answers - value or label that does not conform to validation criteria.
Circle Invalid Data - Answers - command that circles invalid data with a red ellipse is
placed around data that does not match the validation criteria.
The Form Button - Answers - creates a data-input screen for list-type data.
Data Input Form - Answers - a window or dialog box with labels and entry boxes in a
vertical layout.
Form Control - Answers - an object that you can use to display a choice, to run a
command, or to perform an action in a worksheet. Make data entry easier and can
improve the appearance of your work. Includes drop down lists, option buttons, or a
click check box.
Option Button - Answers - a radio button that allows the user to select one choice from a
set of possibilities.
Combo Box Control - Answers - creates a drop down list from which you select one
option
Worksheet Protection - Answers - allows you to choose which cells can be edited. A
simple way to prevent changes to your work.
, Shared Workbook - Answers - a workbook that multiple people can edit, either
simultaneously or at different times.
Change History - Answers - feature in shared workbook that maintains a record of each
edit. Includes name of user, date, and brief description of the change.
Comment - Answers - pop-up text box attached to a cell.
Metadata - Answers - embedded file properties such as user name and date at the time
of creation, the original file location and user comments. Some metadata can be
removed.
Document Inspector - Answers - dialog box that lists properties and data that can be
removed.
Compatibility Checker - Answers - can be opened by Check Compatibility command
and identifies commands, features, or objects that are not supported in earlier versions
of Excel. Ex. earlier versions of excel did not have SmartArt.
Protected View - Answers - workbooks with data from questionable sources open in
protected view so that you can confirm that you do trust the document and the source.
Trusted Location - Answers - a folder that is identified as one that stores workbooks that
are safe.
Scenario - Answers - a set of saved values in a worksheet allowing you to vary numbers
and see potential results. A what-if analysis tool. A worksheet can have up to 32
scenarios. The FIRST scenario you should create is one for the current data so that you
can return to it.
Scenario Summary Report - Answers - a generated worksheet that describes each
scenario in a workbook. You cannot edit a scenario after generating a summary report,
but you can create another scenario.
Goal-seek - Answers - a what-if analysis command that tests values in a cell to
backsolve a formula.
Backsolving - Answers - knowing the results and determining the value needed to reach
those results. *solves a formula for one cell (one argument)
Solver - Answers - an analysis tool that finds the lowest, highest, or a specific formula
by changing values in other cells within limitations that you set.
Solver Results - Answers - dialog box that will inform you if the solver could not find a
solution to your problem.
