MGSC 290 Chapter 8 (Exam 3)

XML

-Extensible Markup Language -file format design for exchanging data on the web -essentially a text file that can be imported into many applications -.xml file name extension

Go to this tab to change the font size and style in a PivotTable:

-Home

______ dialog box will inform you if it cannot find a solution.

-Solver Results

Solver is an Excel ______.

-add-in ---enhanced command/feature that is not installed w/ initial setup; you can install add-ins form Add-Ins pane in Excel Options

Solver

-advanced analysis tool that finds the highest, lowest, or specific result for a formula by changing the values in other cells within limitations that you set -"solving a problem in reverse" -located on Data tab in Analysis group

Objective cell

-cell with a formula that has your desired result (place where final answer will appear) -sometimes referred to as target cell -can set to a max, min, or certain value

Sensitivity report

-contents depend on the solving method that is selected when you run Solver -includes statistical data such as objective coefficient, Lagrange multiplier, and reduced gradient -first sensitivity report is inserted in a sheet named Sensitivity Report 1

Limits report

-displays data about the lower and upper limits of each variable cell and how those limits impact the objective cell

Array formula

-executes a calculation on any number of cells in the array (array = any group of cells)

Scenario summary report

-generated worksheet that describes each scenario in a workbook -formatted as an Excel outline w/ two row outline levels and two column outline levels -in report, you can hide or display details about the changing cells and result cells -if you edit a scenario after creating a summary report, the report is not updated (you can, however, quickly generate another scenario summary report) -for a large worksheet w/ many scenarios, you can also choose to format a scenario summary report as a PivotTable

Answer report

-identified and lists each parameter -includes the original value and the value suggested by solver, as well as statistical values such as slack and integer -inserted in your workbook as a worksheet named Answer Report 1

Refresh

-if option is not active to automatically refresh PivotTable data each time workbook is opened, use this option -PivotTable and chart are not automatically updated if the worksheet data is altered

Value Field Settings

-in a PivotTable, control how the data is summarized in the table -default calculation is Sum, but you can change to Count, Average, Min, or Max

Calculated field

-in a PivotTable; appears in PivotTable but is not a field in the source data -uses a value field from the PivotTable's underlying data in a formula

Variable cells

-in order to reach desired result in objective cell, Solver changes these cells -also called decision cells/changing cells

Input value

-number from a column or row

Open XML dialog box

-offers an option of opening the file as an XML table -imports all of the data and displays it in an Excel table -you can also choose to import the data as a read-only workbook

A Solver problem has three components, known as _____.

-parameters ---info used by Solver to find a solution ---1. objective cell ---2. variable cell ---3. constraint

Data table

-range of cells that shows calculated results of one or more formulas

Constraint

-restriction/limitation -limitation on the formula, on one or more of the variable cells, or on other cells that are directly related to the objective cell

Scenario

-saved set of values in a worksheet -what-if analysis tool -enable you to test values in a worksheet and determine potential results -a worksheet can have multiple scenarios, each one named and saved

One-variable data table

-substitutes values for one argument in a formula and displays the results when that value is altered -uses one input value

A properly structured XML file includes ____ that describe the data.

-tags ---identifiers such as <Customer> ---opening tag and ending tag for each data field ---ending tag includes a forward slash with the name, for example </Customer>

Slicer

-tool that creates an on-screen window that acts as a filter for a single field in the PivotTable -when working with a large PivotTable, slicer allows you to display only the data you need at the moment -from Insert Slicer button in Filter group on PivotTable Tools Analyze tab

Custom calculation

-you can display values in a PivotTable with this -percentage, ranking, or ratio -if you want to analyze a field in a PivotTable as a value and as a ratio or percentage, you can add the field MULTIPLE TIMES in the Values area; then, for each occurrence, you can choose a field setting or a custom calculation

XML map

-tree hierarchy of tags and other elements from the source XML file -from here, you can place fields in any order to build a table in the worksheet

Two-variable data table

-uses two sets of input values; one in a column, the other in a row -it can only use on formula -row input values start one column to the right of the column values