BAT Chapter 8 Flashcards
What does the Goal Seek Command determine?
What value should be in a cell
Descriptive Statistics Command
Calculates and generates a list of popular measures for a data range
Scenario
Saved set of values in a workbook
Backsolving
Problem solving method that starts with the result and calculates the value to reach that result
Objective Cell
Target cell
Custom Calculation
Built in percent ranking or ratio
Goal Seek Command
Tests values for one cell in a summary
What 2 things are included in a forecast sheet?
A table or related chart
Two data series
Slicer
A visual filter for a pivot table that floats on the sheet
Value Field Settings
Determines how values are summarized
Scenario Manager Command
Creates scenario summary report
One variable data table
Substitutes values for one argument in one or more formulas
Calculated Field
Built from a formula with one field in the source data
What are the 3 parameters of the Solver Add in
Objective Cell
Variable Cell
Constraints
Forecast Sheet
Generated worksheet that uses existing data to analyze and predict results
Scenario Summary Report
Lists details about changing and result cells
Variable Cell
Decision / changing cells
Two variable data table
Two or more arguments in a single formula
Analysis ToolPak
Excel add in with built in stats and engineering calculations
What do you use to calculate statistical measures?
Analysis Toolpak
What must 1 data series include in a forecast sheet?
A date or time field
Query
Stores instructions for getting data from an external source for display in a worksheet
What if analysis tool
Allows you to compare and display multiple data possibilities
Solver add in
Analysis tool that solves a problem in reverse
Timeline
A visual filter for a date field in a Pivot Table
Moving Average Command
Calculates and generates a list of running or rolling averages for a set of values with a related chart
What is the calculated field not in?
Not in data source for a Pivot Table
