Term
|
Definition
| Organize and store data within worksheets. |
|
|
Term
|
Definition
| includes a needs statement, source of data, summary of calculations, and any other special requirements for the worksheet, such as charting and Web support. |
|
|
Term
|
Definition
| Intersection of each column and row. |
|
|
Term
|
Definition
| A cell referred to by it s unique address. |
|
|
Term
|
Definition
| The horizontal and vertical lines on the worksheet itself. |
|
|
Term
|
Definition
| As you type excel displays the entry in the |
|
|
Term
|
Definition
| small black square located in the lower-right corner of the active cell. |
|
|
Term
|
Definition
| To specify an absolute reference in a formula, enter a(n) ____ before a column letter or a row number. |
|
|
Term
| IF(logical_test, value_if_true, value_if_false) |
|
Definition
| The general form of the IF function is ____. |
|
|
Term
|
Definition
| The ____ entry of the IF function is made up of two expressions and a comparison operator. |
|
|
Term
|
Definition
| To quit Excel, click the ____ button on the title bar |
|
|
Term
|
Definition
| Text in a cell can be rotated counterclockwise by entering a number between 1º and ____ in the Alignment sheet in the Format Cells dialog box. |
|
|
Term
|
Definition
| A ____ function is one in which the action taken for the true or false case includes yet another IF function. |
|
|
Term
copy a cell, copy a range of cells,
create a series of numbers |
|
Definition
| You can use the fill handle to ____. |
|
|
Term
|
Definition
| A(n) ____ chart is used to show the relationship of the parts to a whole. |
|
|
Term
|
Definition
| The entries that will identify the slices of a pie chart are called ____. |
|
|
