BAT Chapter 8 (Finals Guide) Flashcards
1
Q
XML
A
A file format that is designed for exchanging data on the web
2
Q
Slicer
A
Visual filter that connects your Pivot tables together
3
Q
How is a scenario summary report generated?
A
Generated on a new sheet named Scenario Summary
4
Q
Calculated Field
A
A field in the Pivot Table that is not in the source data
5
Q
What must 1 column be when creating a forecast sheet?
A
Time or date field
6
Q
Scenario
A
Saved set of values permitting one to many members to see potential results
7
Q
How is a scenario summary report formatted?
A
As an Excel Outline
8
Q
Solver
A
Finds highest, lowest or specific result by changing values in other cells with set limitations
9
Q
Forecast Sheet
A
Table and chart that illustrates past data and predicts future values
