Excel Chapter 9 MC
An Excel add-in with statistical and engineering functions is the: Forecast sheet Analysis ToolPak Solver Goal Seek tool Descriptive Statistics
Analysis ToolPak
Solver is an enhanced Excel tool that is an example of an Excel: Add-in Cross link Macro XML command Model
add in
A problem-solving method that starts with a result and calculates the value to reach that result is: Forecasting Constraining Analysis Backsolving Goal Seeking
backsolving
A range of cells that shows calculated results of one or more formulas is called a(n): Data table Numerator Range return Net return Scenario
data table
Summary measures for a data range such as the mean or average, the maximum, the minimum, or a count are: Intervals PivotTables Sums Moving averages Descriptive statistics
descriptive statistics
A forecast sheet calculates: Intervals Future values Moving averages Summaries Date and time
future values
A column chart that illustrates the frequency of each data point in a data set is called a(n): Scene 3D Map Moving Range Tour Histogram
histogram
A cell with a formula that will be solved for specific results is called a(n): Input cell Analyzer Prime cell Objective cell Result cell
objective cell
How many scenarios can be displayed in a worksheet at any one time? One Two Three Four Eight
one
A Solver problem has three components, known as: Fields Sectors Conditions Data models Parameters
parameters
A saved set of values in a worksheet that functions as a "what-if" analysis tool is a(n): Hypothetical Condition Scenario Limited data Comment
scenario
A generated worksheet that displays values for changing and result cells for each scenario in a workbook is called a(n): One-variable data table Forecast sheet Scenario summary report Analysis report Two-variable data table
scenario summary report
A forecast sheet inserts functions into its tables from which function category? Financial Statistical Logical Data and Time Text
statistical
A series of scenes created by 3D Map that visualize your data is a(n): Chart Tour Scenario Power Map Plot
tour
What settings determine how data is summarized in a PivotTable? PowerPivot Value field Form box Text box Numeric range
value field
