BAT Chapter 8 Flashcards Preview

jeremy harmon > BAT Chapter 8 > Flashcards

Flashcards in BAT Chapter 8 Deck (27):
1

What does the Goal Seek Command determine?

What value should be in a cell

2

Descriptive Statistics Command

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

3

Scenario

Saved set of values in a workbook

4

Backsolving

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

5

Objective Cell

Target cell

6

Custom Calculation

Built in percent ranking or ratio

7

Goal Seek Command

Tests values for one cell in a summary

8

What 2 things are included in a forecast sheet?

A table or related chart
Two data series

9

Slicer

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

10

Value Field Settings

Determines how values are summarized

11

Scenario Manager Command

Creates scenario summary report

12

One variable data table

Substitutes values for one argument in one or more formulas

13

Calculated Field

Built from a formula with one field in the source data

14

What are the 3 parameters of the Solver Add in

Objective Cell
Variable Cell
Constraints

15

Forecast Sheet

Generated worksheet that uses existing data to analyze and predict results

16

Scenario Summary Report

Lists details about changing and result cells

17

Variable Cell

Decision / changing cells

18

Two variable data table

Two or more arguments in a single formula

19

Analysis ToolPak

Excel add in with built in stats and engineering calculations

20

What do you use to calculate statistical measures?

Analysis Toolpak

21

What must 1 data series include in a forecast sheet?

A date or time field

22

Query

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

23

What if analysis tool

Allows you to compare and display multiple data possibilities

24

Solver add in

Analysis tool that solves a problem in reverse

25

Timeline

A visual filter for a date field in a Pivot Table

26

Moving Average Command

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

27

What is the calculated field not in?

Not in data source for a Pivot Table

Decks in jeremy harmon Class (107):