Term
|
Definition
| using a worksheet to explore different outcomes for Excel formuals |
|
|
Term
|
Definition
| worksheet you use to produce a what if analysis |
|
|
Term
|
Definition
| acts as the basis for multiple outcomes, or sets of results |
|
|
Term
|
Definition
| cells that contain data rather than formulas |
|
|
Term
|
Definition
| usually contains a formual whose resulting value changes depending on the values in the input cells |
|
|
Term
| The Excel Goal Seek feature |
|
Definition
| useful when you have a specific solution or goal in mind and you want to determine what input values will be needed to achieve that goal |
|
|
Term
|
Definition
| use _____________ to see the effects of one or two variables on a formula |
|
|
Term
|
Definition
| is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. |
|
|
Term
| Scenarios and data tables |
|
Definition
| take sets of input values and determine possible results. |
|
|
Term
|
Definition
| If you have a formula that uses one or two variables, or multiple formulas that all use one common variable, you can use a ______ to see all the outcomes in one place |
|
|
Term
| 5 Characteristics of a good model |
|
Definition
1. Accuracy
2. Simplicity
3. Ease of Control
4. Adaptiveness
5. Ease of Communication |
|
|
Term
| 5 Steps to developing a model |
|
Definition
1. Understand the problem
2. Plan the logic
3. Build the model
4. Test the model
5. Use the model |
|
|
Term
|
Definition
| Which option must be chosen before subtotals can be generated on a table? |
|
|
Term
Inputs must meet a certain criteria to be capable of being entered into the field.
B. The use of a drop-down box for the only allowed options.
C. Users are provided an error message stating why their entries aren't permitted. |
|
Definition
| What options are available with the use of data validation? |
|
|
Term
DAverage
B. Subtotal
C. Pivottable |
|
Definition
| average numbers according to a particular field value |
|
|
Term
|
Definition
| set of instructions that performs tasks in the order you specify |
|
|
Term
|
Definition
|
|
Term
|
Definition
| program code container (where each macro is stored) |
|
|
Term
|
Definition
| a program that lets you display and edit your macro code |
|
|
Term
|
Definition
| off/on switch for relative refrencing in macros; retains the relative reference setting until you click it again to turn it off or you exit excel |
|
|
Term
|
Definition
| excel file that is always available, unless you specify otherwise, and gives you access to all the macros it contains, regardless of which workbooks are open |
|
|
Term
|
Definition
| breaks data fields in one column into separate columns |
|
|
Term
|
Definition
| conditionally totals cells in a sum range that meet given criteria |
|
|
Term
|
Definition
| combine and display the data in one sheet; summzarize similar data that exists in different sheets or workbooks |
|
|
Term
|
Definition
| makes calculations based on criteria that you create (called stated conditions) |
|
|
Term
|
Definition
| a contion that can be answered with a true or false response |
|
|
Term
|
Definition
| a table is organized into rows called: |
|
|
Term
|
Definition
| contains data about an object, person, or other type of table item |
|
|
Term
|
Definition
| records are com,posed of : |
|
|
Term
|
Definition
| columns in the table; describes a characteristic of the record |
|
|
