Term
|
Definition
|
|
Term
|
Definition
| Organizational collection of data |
|
|
Term
|
Definition
| Categories of information from the column headings |
|
|
Term
|
Definition
| Combine the fields from a row |
|
|
Term
|
Definition
| Allows us to filter what data we want shown. Process of filtering |
|
|
Term
|
Definition
| Visual way of graphically representing 2 variables usually over time as to their relationship to each other. Also calculate the R value. |
|
|
Term
|
Definition
| Interactive view of data summarized by selecting categories to group the data |
|
|
Term
|
Definition
| Interactive chart view were we can change groupings that represent the data |
|
|
Term
|
Definition
| In pivot charts and tables we can filter data on charts and tables representing them wit a graphical object |
|
|
Term
|
Definition
| Check cells referenced in formulas and check formulas referenced in cells |
|
|
Term
|
Definition
| Specify certain types values be accepted in a cell |
|
|
Term
|
Definition
| The power house to solve large problems instead of trial and error. Up to 200cells |
|
|
Term
|
Definition
| Limitations imposed on possible value a cell can have |
|
|
Term
|
Definition
| Shows the answer solver derived including what was manipulated and the constraints used. |
|
|
Term
|
Definition
| Analysis tool to record and save sets of what-if assumptions |
|
|
Term
|
Definition
| Blue arrows that point from cell to cell referencing cells in a formula |
|
|
Term
|
Definition
| Cell represented in a formula. If a1+a2 equals a3,a1and a2 are precedent and upstream to A3. A3 is dependent of a1 2 |
|
|
Term
|
Definition
| Mathamtical process of solving problems |
|
|
Term
|
Definition
| Those cells used in solver that are adjustable in deriving an answer |
|
|
Term
|
Definition
| Cells used in solver whose value solver tries to meet by adjusting the changing cells |
|
|
Term
| Scenario summary worksheet |
|
Definition
| These are the productions given us in the summary manager |
|
|
Term
|
Definition
| A step by step process that continues until the task is completed |
|
|
Term
|
Definition
| Method of data entering by creating forms or fields from the column headings |
|
|
Term
|
Definition
| Visual basic application to extend the capabilities of excel |
|
|
Term
|
Definition
| Procedure derived from VBA |
|
|
