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. 

