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.