Management Science 291 SimNet #3
Solver is an enhanced Excel tool that is an example of...
An add-in
a saved set of values in a worksheet that functions as "what-if" analysis tools are called:
Scenarios
A file format that is designed for exchanging data on the web is called:
XML.
A field that appears in the PivotTable but is not a field in the source data is called:
a calculated field
An identifier that appears in chevron ( < > ) braces which surround the actual data is calledL
a tag
These settings determine how data is summarized in a PivotTable:
a value field
A cell with a formula that will be solved for specific results is called:
an objective cell
To run solver, click the Solver button on the Data tab in this group:
analysis
A range of cells that shows calculated results of one or more formulas
data table
The Slicer tool creates an on screen window that acts as a(n):
filter
Go to this tab to change the font size and style in a PivotTable
home
How many scenarios can be displayed in a worksheet at one time,
one
A solver problem has three components, known as...
parameters
To update a PivotTable, choose:
refresh
The default calculation for a value field it:
SUM.