Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
28 Cards in this Set
- Front
- Back
|
Makes a decision
|
=if(condition,true,false)
|
|
|
Find the largest value
|
=max(range)
|
|
|
Finds the smallest value
|
=min(range)
|
|
|
Calculate the mean
|
=average(range)
|
|
|
Counts all Numbers
|
=count(range)
|
|
|
Counts all cells that have blanks
|
=countblank(range)
|
|
|
Counts the number of cells hat has anything in it
|
=counta(range)
|
|
|
Returns the absolute value
|
=abs(number)
|
|
|
Returns an integer
|
=int(number)
|
|
|
IsErr
|
To see if there is an error, beside #N/A in a certain cell. If there is it will display true if not false.
|
|
|
IsError (def)
|
To see if there is any error statement in a cell, if there is will display true if not false
|
|
|
IsNumber (def)
|
To see if a value in a cell is a number if it is it will show true, if not false.
|
|
|
IsText (def)
|
To see if the value in a cell is text, if it is it will display true, if not false.
|
|
|
IsBlank (def)
|
To see if a cell is blank, if it is it will show true, if not false
|
|
|
IsEven (def)
|
Tosee if a value in a cell is even, if it is it will show true if not false
|
|
|
IsOdd (def)
|
To see if a value in a cell is odd, if it is it shows true, if its not it shows false
|
|
|
IsLogical (def)
|
To see if a cell is logical, if it is it will show true if not false
|
|
|
Index (def)
|
To locate the intersecting column and row of a desired calue
|
|
|
Match (def)
|
To locate the exact cello of a desire volume
|
|
|
Index (argument)
|
=Index(Value, column, row)
|
|
|
Match (argument)
|
=match(volume,column,row)
|
|
|
Today (argument)
|
=today()
|
|
|
Now (argument)
|
=now()
|
|
|
Date (argument)
|
=date[serial number]
|
|
|
day (argument)
|
=day[serial number]
|
|
|
month (argument)
|
=month[serial number]
|
|
|
round (argument)
|
=round(number, number of decimals)
|
|
|
Pmt
|
=PMT(rate,pd,fv)
|
