| A | B |
|---|
| #REF | Displayed in cells to indicate a cell reference error. |
| Absolute Cell Reference | instructs Excel to keep the cell reference constant (absolute) in the formula as it copies it to the destination area. |
| Category Names | -- the names that identify the slices of the Pie chart. |
| Chart Sheet | when the Pie chart resides on a separate sheet, which contains only the chart. |
| Data Series | The data that determines the size of the slices in the pie. |
| Date Stamp | shows the date the workbook, report, or other document was created or the period it represents. |
| Drag and Drop | using the mouse to move or copy cells. |
| Exploded Pie chart | A pie chart with one or more slices offset. |
| Format Symbol | Excel immediately displays it with the assigned format. |
| Freeze the tiltles | Excel displays the titles on the screen, no matter how far down or the right you scroll. |
| Goal Seeking | determines the value of a cell on which the formula depends. |
| IF function | useful when you want to assign a value to a cell based on a logical test. |
| Mixed cell reference | a cell reference with only one dollar sign before either the column or the row. |
| Nested IF function | one in which the action to be taken for the true or false includes yet another IF function. |
| NOW Function | one of 14 date and time functions available in Excel. |
| Office Clipboard | a reserved place in the computer's memory that allows you to collect text and graphic items from an Office document and then past them onto any Office document. |
| Offsetting | emphasizing a slice of the pie chart from the rest of the slices so that it stands out. |
| Pie Chart | shows the relationship or proportion of parts to a whole. Each slice (or wedge) of the pie shows what percent that slice contributes to the total (100%). |
| Relative Cell reference | instructs Excel to adjust the cell reference as it copies it to the destination area. |
| Underline | underlines only the character in the cell, rather than the entire cell, as is the case when you assign a cell a bottom border. |
