| A | B |
|---|
| Trend | A mathematical prediction of future values based on the relationship between existing values. |
| Step | Used to calculate a future value. The step is the difference between two existing values. |
| What-if analysis | Excel's term for a series of tools that perform calculations that involve one or more variables. |
| Variable | An input value that changes depending on the desired outcome. |
| substitution values | A special name given to the variables used in a data table. |
| Input Cell | A cell in a data table to which your formula refers. Excel copies a variable into this cell, solves the formula, and then goes on to the next variable to create a series of answers. |
| Data Table | A method of performing what-if analysis, involving a column (and possibly a row) of variables and a formula that Excel solves over and over, using each of the variables. |
| Goal Seek | A method of performing what-if analysis in which the result (the goal) is known, but the value of a dependant variable is unknown. |
| Solver | A method of performing what-if analysis in which the result is known, but more than a single variable is unknown. Also, there may be additional contraints upon the final result. |
| Table | A series of columns and rows used to organize data. Each column typically represents a differenet field, and each row represents an entire record. |
| Range Name | The name given to a set of adjacent cells. You might name a range in order to make it more convenient to referenece that range in a formula or a function, such as VLOOKUP. |
| Pivotable | A rearrangeable table that allows you to analyze complex data in a variety of ways. |
| Data | What is an organized collection of records? For example, in an employee ________, one record might include the following: employee name, date of hire, address, phone number, salary rate. |
| PivotChart | A chart based on PivotTable data. |
| Field | A single part of a record, such as "Phone number. employee's name, address, phone number, etc., make up one record. |
| Report filter | A field from the database that you can use to filter or limit the data displayed within the PivotTable. |
| HTML | Used to publish information on the World Wide Web. |
| World wide web | A network of computers located in businesses, research foundations, schools, and homes that allows users to share and search for information. |
| Web browser | Software that enables you to view Web sites on the Internet. |
| Web page | Information published on the World Wide Web, which can include text, graphics, and links to other pages. |
| publising | The process of saving data to an intranet or Internet. |
| Intranet | A private network of computers within a business or organization. |
| Web Query | The process of pulling data from a Web page into an Excel worksheet. |
| Refresh | The process of updating the data copied to a worksheet through a query. |
| Link | A reference to data stored in another file. When that data is changed, the data is updated in the destination file automatically. |
| Embed | A special process of copying data from one document to another, so that the tools from the original application are made available in the destination application for editing. No link to the original data is created, so such editing does not affect the original data. |
| Picture | A graphic image of your data, which is neither linked or embedded into another document. |
