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