Shared Flashcard Set

Details

Excel Lesson 5 Formulas
Functions and formulas
20
Computer Science
10th Grade
11/22/2011

Additional Computer Science Flashcards

 


 

Cards

Term
COUNTA
Definition
A function that totals the number of ITEMS in a range of cells
Term
SUM
Definition
A function that adds a range of cells
Term
AVERAGE
Definition
A function that figures the average of a range of cells
Term
Relative
Definition
Cell reference that changes when it is copied or moved
Term
Absolute
Definition
Cell reference that does not change when it is copied or moved
Term
PMT
Definition
Function that figures equal payments on an installment loan
Term
COUNT
Definition
A function that lists how many cells in a range contain a value
Term
MAX
Definition
Function that finds the highest value in a range of cells
Term
MIN
Definition
Function that finds the lowest value in a range of cells
Term
Argument
Definition
the value the function uses to perform a calculation
Term
SQRT
Definition
A function that finds the square root of a number
Term
ROUND
Definition
A function that designates a specific number of decimal places the answer will be expressed in.
Term
STDEV.P
Definition
A function that finds the estimated standard deviation of the numbers in the range
Term
AND
Definition
Functions that brings about a "TRUE" result if BOTH logical tests are true
Term
IF
Definition
A function that contains 2 values or outcomes based on whether the condition is true or false
Term
Financial
Definition
These functions analyze loans and investments
Term
Statistical
Definition
Functions that describe quantities of data
Term
Function Arguments
Definition
Dialog box which provides a description of each argument you need to enter for the selected function
Term
Logical
Definition
Functions which display text or values if certain conditions exist
Term
OR
Definition
Function that returns a "TRUE" value if any of the arguments are true
Supporting users have an ad free experience!