Term
|
Definition
| Keeps both rows and columns above and to the left of active cell visible |
|
|
Term
|
Definition
| Range of related data formatted to enable data management and analysis |
|
|
Term
|
Definition
Indv. piece of data
-Appear in top row as column headings
-short but descriptive |
|
|
Term
|
Definition
Complete set of data for an entity
-listed in a row of table
-do not insert blank rows in the table |
|
|
Term
|
Definition
| process of displaying records that meet specific conditions |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Applied to display a range of values |
|
|
Term
|
Definition
| Controls fill color, header row, columns, and records |
|
|
Term
|
Definition
-Summarize, analyze, explore large amounts of data
|
|
|
Term
|
Definition
| Sets overall conditions for aggregating data |
|
|
Term
|
Definition
| Filters out data based on a row or column category |
|
|
Term
|
Definition
| -Graphical rep of data in a PivotTable |
|
|
Term
|
Definition
Filter Data in PivotTable
-Graphical
-Buttons for quick filtering
-Indicate current filtering state |
|
|
Term
|
Definition
| See how changing variables impacts calculated results |
|
|
Term
|
Definition
| Value the can be chagned to see how it affects other values |
|
|
Term
|
Definition
| Data analysis tool that provides various results based on changing one variable |
|
|
Term
|
Definition
| Replaces the original value of a variable in a data table |
|
|
Term
|
Definition
Took when you know desired end result but not the value needed to meet the goal
-Work backwards to solve problem |
|
|
Term
|
Definition
Determine possible results
Define and manage up to 32 scenarios |
|
|
Term
|
Definition
Worksheet that compares the scenario results
-Does not update automatically |
|
|
Term
|
Definition
| -Manipulates variables based on constraints to find the optimal solution to a problem |
|
|
Term
|
Definition
1. Objective cell - formula-based value that you want optimized
2. Changing cells - values are adjusted until constraints are satisfied
3. Constaints - specify the restrictions |
|
|
Term
|
Definition
| Rules that Solver enforced to reach the target value |
|
|
Term
|
Definition
| Do not restrice target value found |
|
|
Term
Where do you drag the field if you want a list of each state in the first column of the PivotTable?
1. Column Labels Area
2. Report Filter Area
3. Row Labels Area
4. Values Area |
|
Definition
|
|
Term
| + button indicate to left of a row heading |
|
Definition
| Can expand the details in the category |
|
|
Term
| Default summary statistic for the salaries in the PivotTable? |
|
Definition
|
|
