BAT Chapter 8

Question 1

What does the Goal Seek Command determine?

Answer 1

What value should be in a cell

Question 2

Descriptive Statistics Command

Answer 2

Calculates and generates a list of popular measures for a data range

Question 3

Scenario

Answer 3

Saved set of values in a workbook

Question 4

Backsolving

Answer 4

Problem solving method that starts with the result and calculates the value to reach that result

Question 5

Objective Cell

Answer 5

Target cell

Question 6

Custom Calculation

Answer 6

Built in percent ranking or ratio

Question 7

Goal Seek Command

Answer 7

Tests values for one cell in a summary

Question 8

What 2 things are included in a forecast sheet?

Answer 8

A table or related chart

Two data series

Question 9

Slicer

Answer 9

A visual filter for a pivot table that floats on the sheet

Question 10

Value Field Settings

Answer 10

Determines how values are summarized

Question 11

Scenario Manager Command

Answer 11

Creates scenario summary report

Question 12

One variable data table

Answer 12

Substitutes values for one argument in one or more formulas

Question 13

Calculated Field

Answer 13

Built from a formula with one field in the source data

Question 14

What are the 3 parameters of the Solver Add in

Answer 14

Objective Cell
Variable Cell
Constraints

Question 15

Forecast Sheet

Answer 15

Generated worksheet that uses existing data to analyze and predict results

Question 16

Scenario Summary Report

Answer 16

Lists details about changing and result cells

Question 17

Variable Cell

Answer 17

Decision / changing cells

Question 18

Two variable data table

Answer 18

Two or more arguments in a single formula

Question 19

Analysis ToolPak

Answer 19

Excel add in with built in stats and engineering calculations

Question 20

What do you use to calculate statistical measures?

Answer 20

Analysis Toolpak

Question 21

What must 1 data series include in a forecast sheet?

Answer 21

A date or time field

Question 22

Query

Answer 22

Stores instructions for getting data from an external source for display in a worksheet

Question 23

What if analysis tool

Answer 23

Allows you to compare and display multiple data possibilities

Question 24

Solver add in

Answer 24

Analysis tool that solves a problem in reverse

Question 25

Timeline

Answer 25

A visual filter for a date field in a Pivot Table

Question 26

Moving Average Command

Answer 26

Calculates and generates a list of running or rolling averages for a set of values with a related chart

Question 27

What is the calculated field not in?

Answer 27

Not in data source for a Pivot Table