Term
|
Definition
| Displays numerical data with dollar signs and decimal points that line up vertically within a column |
|
|
Term
|
Definition
| Displays text and numerical data as times |
|
|
Term
|
Definition
| Displays numerical data in exponential notation |
|
|
Term
|
Definition
| Displays the value of 0.5 as 1/2 |
|
|
Term
|
Definition
| Displays numerical data that will not be used for calculation such as serial numbers containing hyphens |
|
|
Term
|
Definition
| Displays both text and numerical data as keyed |
|
|
Term
|
Definition
| Displays text and numerical data as dates |
|
|
Term
|
Definition
| Displays numerical data with a fixed amount of places to the right of the decimal point |
|
|
Term
|
Definition
| Displays numerical data followed by a percent sign |
|
|
Term
|
Definition
| Displays formats designed by the user |
|
|
Term
|
Definition
| Displays numerical data preceded by a dollar sign; however, dollar signs and decimal points do not necessarily line up vertically within the column |
|
|
Term
|
Definition
| Displays text in numerical format such as ZIP codes |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| Divides the value in A3 by the result of 27 plus the value in A4 |
|
|
Term
|
Definition
| Raises the value in A3 to the 27th power |
|
|
Term
|
Definition
| Raises the value in A3 to the 27th power, and then divides the result by the value in A4 |
|
|
Term
|
Definition
| Adds the values in A3 and A4 |
|
|
Term
|
Definition
| Divides the value in A3 by 27 |
|
|
Term
|
Definition
| Divides the value in A3 by 27, and then adds the value in A4 |
|
|
Term
|
Definition
| Multiplies the value in A3 times 27, and then divides the product by the value in A4 |
|
|
Term
|
Definition
| Subtracts the value in A4 from the value in A3 |
|
|
Term
|
Definition
| Divides 27 by the value in A4, and then multiplies the result by the value in A3 |
|
|
Term
|
Definition
| Multiplies the value in A3 times 27 |
|
|
Term
|
Definition
| Inserts the value in D10 of Sheet2 |
|
|
Term
|
Definition
| Adds the values in D10 of Sheet2 and D11 of sheet3 |
|
|
Term
|
Definition
| Adds the values in cell D10 on Sheet2, Sheet3, and Sheet4 |
|
|
Term
|
Definition
| Adds the values in D10 and D11 of Sheet2 |
|
|
Term
|
Definition
| Adds the values in D10 and D11 of Sheet3 |
|
|
Term
|
Definition
| Charts are a graphical representation of whorsheet data. |
|
|
Term
|
Definition
| Column charts are the best way to represent data groups that are part of a whole. |
|
|
Term
|
Definition
| Line charts are good for representing trends over a period of time. |
|
|
Term
|
Definition
| A scatter chart produces a "cloud" of data points not connected by lines. |
|
|
Term
|
Definition
| When the worksheet data changes, charts created from the worksheet also change. |
|
|
