Term
|
Definition
| A permanent reference to a cell and does not change in relation to the location of the formula. |
|
|
Term
|
Definition
| Follows the function name and is enclosed in parentheses. |
|
|
Term
|
Definition
| The most common Used operators such as addition and subtraction. |
|
|
Term
|
Definition
| A feature that you can use to automatically fill in worksheet data in any direction. |
|
|
Term
|
Definition
| Used to compare two Values to obtain a logical value, either TRUE or FALSE. |
|
|
Term
|
Definition
| Numbers entered directly into a formula that does not change. |
|
|
Term
|
Definition
| Excel indicates when a formula you have entered results in an error. |
|
|
Term
|
Definition
| A little black square in the lower-right corner of the results in an error. |
|
|
Term
|
Definition
| A set of instructions used to perform calculations on values in a worksheet. |
|
|
Term
|
Definition
| Built-in formulas that enable you to perform complex calculations easily. |
|
|
Term
|
Definition
| Contains both relative and absolute cell references. |
|
|
Term
|
Definition
| A sign or symbol that indicates what calculation is to be performed. |
|
|
Term
|
Definition
| A specific sequence used to calculate the value of a formula. |
|
|
Term
|
Definition
| The reference to a cell changes in relation to the location of the formula. |
|
|
Term
|
Definition
| A function must follow a set of established rules that specifies how the function must be entered. |
|
|
Term
|
Definition
| A graphical representation of wroksheet data. |
|
|
Term
|
Definition
| The complete chart and all its elements, which include the plot area, titles, axes, legend, and any other objects. |
|
|
Term
|
Definition
| Placing the chart in a seperate sheet in the workbook. |
|
|
Term
|
Definition
| A collection of predisigned artwork such as drawings or images that can be inserted into worksheets. |
|
|
Term
|
Definition
| A dot, a bar, or a symbol used to to represent one number from the sheet. |
|
|
Term
|
Definition
| As series of related values from the worksheet graphically represented by a unigue color or pattern. |
|
|
Term
|
Definition
| The range of cells that contains the data you want to display in the chart. |
|
|
Term
|
Definition
| shapes, curves, and lines that you create in the worksheet by first selecting the type of shape you want to create, and then clicking and dragging the mouse to create that shape. |
|
|
Term
|
Definition
| A newly created chart that are used for showing categories. |
|
|
Term
|
Definition
| Lines extending from the vertical or horizontal axes across the plot area of a chart. |
|
|
Term
|
Definition
| Lines on a chart that are used for showing catergories. |
|
|
Term
|
Definition
| A list that identifies the patterns or colors of the data series or catgories in a chart. |
|
|
Term
|
Definition
| Digital photographs or images, stored on your computer or network. |
|
|
Term
|
Definition
| The area in the chart where the calues from the data series are displayed graphically; this includes the axes and data series. |
|
|
Term
|
Definition
| A picture of a computer screen or part of a screen, such as a button. |
|
|
Term
|
Definition
| A predesigned diagram made up shapes contacting text that illustrates a cincept or idea. |
|
|
Term
|
Definition
| Miniature charts that are embedded in the background of a single cell. |
|
|
Term
|
Definition
| Descriptive name that identifies a chart or axis. |
|
|
Term
|
Definition
| Lines on a chart thatare used for plotting values. |
|
|
Term
|
Definition
| A drawings tool that turns word into a graphics object. |
|
|
