# Shared Flashcard Set

## Details

Microsoft Excel
Excel Terminology
37
Computer Science
10/30/2008

Term
 Accounting
Definition
 Displays numerical data with dollar signs and decimal points that line up vertically within a column
Term
 Time
Definition
 Displays text and numerical data as times
Term
 Scientific
Definition
 Displays numerical data in exponential notation
Term
 Fraction
Definition
 Displays the value of 0.5 as 1/2
Term
 Text
Definition
 Displays numerical data that will not be used for calculation such as serial numbers containing hyphens
Term
 General
Definition
 Displays both text and numerical data as keyed
Term
 Date
Definition
 Displays text and numerical data as dates
Term
 Number
Definition
 Displays numerical data with a fixed amount of places to the right of the decimal point
Term
 Percentage
Definition
 Displays numerical data followed by a percent sign
Term
 Custom
Definition
 Displays formats designed by the user
Term
 Currency
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
 Special
Definition
 Displays text in numerical format such as ZIP codes
Term
 +
Definition
Term
 -
Definition
 Subtraction
Term
 *
Definition
 Multiplication
Term
 /
Definition
 Division
Term
 ^
Definition
 Exponentiation
Term
 =A3/(27+A4)
Definition
 Divides the value in A3 by the result of 27 plus the value in A4
Term
 =A3^27
Definition
 Raises the value in A3 to the 27th power
Term
 =A3^27/A4
Definition
 Raises the value in A3 to the 27th power, and then divides the result by the value in A4
Term
 =A3+A4
Definition
 Adds the values in A3 and A4
Term
 =A3/27
Definition
 Divides the value in A3 by 27
Term
 =A3/27+A4
Definition
 Divides the value in A3 by 27, and then adds the value in A4
Term
 =(A3*27)/A4
Definition
 Multiplies the value in A3 times 27, and then divides the product by the value in A4
Term
 =A3-A4
Definition
 Subtracts the value in A4 from the value in A3
Term
 =A3*(27/A4)
Definition
 Divides 27 by the value in A4, and then multiplies the result by the value in A3
Term
 =A3*27
Definition
 Multiplies the value in A3 times 27
Term
 =Sheet2!D10
Definition
 Inserts the value in D10 of Sheet2
Term
 =Sheet2!D10+Sheet3!D11
Definition
 Adds the values in D10 of Sheet2 and D11 of sheet3
Term
 =SUM(Sheet2:Sheet4!D10)
Definition
 Adds the values in cell D10 on Sheet2, Sheet3, and Sheet4
Term
 =SUM(Sheet2!D10:D11)
Definition
 Adds the values in D10 and D11 of Sheet2
Term
 =Sheet3!D10+Sheet3!D11
Definition
 Adds the values in D10 and D11 of Sheet3
Term
 True
Definition
 Charts are a graphical representation of whorsheet data.
Term
 True
Definition
 Column charts are the best way to represent data groups that are part of a whole.
Term
 True
Definition
 Line charts are good for representing trends over a period of time.
Term
 True
Definition
 A scatter chart produces a "cloud" of data points not connected by lines.
Term
 True
Definition
 When the worksheet data changes, charts created from the worksheet also change.
Supporting users have an ad free experience!