BAT Chapter 8 (Finals Guide) Flashcards Preview

jeremy harmon > BAT Chapter 8 (Finals Guide) > Flashcards

Flashcards in BAT Chapter 8 (Finals Guide) Deck (9):
1

XML

A file format that is designed for exchanging data on the web

2

Slicer

Visual filter that connects your Pivot tables together

3

How is a scenario summary report generated?

Generated on a new sheet named Scenario Summary

4

Calculated Field

A field in the Pivot Table that is not in the source data

5

What must 1 column be when creating a forecast sheet?

Time or date field

6

Scenario

Saved set of values permitting one to many members to see potential results

7

How is a scenario summary report formatted?

As an Excel Outline

8

Solver

Finds highest, lowest or specific result by changing values in other cells with set limitations

9

Forecast Sheet

Table and chart that illustrates past data and predicts future values

Decks in jeremy harmon Class (106):