Shared Flashcard Set

Details

Microsoft Excel
Excel Terminology
37
Computer Science
9th Grade
10/30/2008

Additional Computer Science Flashcards

 


 

Cards

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
Addition
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!