Shared Flashcard Set

Details

EECS 138
Test #1
10
Chemical Engineering
Undergraduate 1
02/23/2011

Additional Chemical Engineering Flashcards

 


 

Cards

Term
=counta(range)
Definition
Counts the total number and text cells
Term
=count(range)
Definition
Counts the total numbers
Term
=countif(range,parameter)
Definition
Counts the number of cells that find the parameter in the range
Term
rand()
Definition
generates random numbers in the cell
Term
=if()
Definition
=if(logical_test, value if true, value if false)
Term
vlookup() hlookup()
Definition

v/h lookup(lookup value table array, column, index number, [range lookup])

(false gives exact numbers)

(true gives closest number)

Term
=ifisna
Definition
if(isna(=HLOOKUP(A20,A20:B22,3,false),"not found",hlookup(a20,a20:b22,3,false)
Term
Circular reference
Definition
If B3 contains the formula =B2+B3, then B3 contains a circular reference. A formula refers—either directly or indirectly—to the cell in which the formula is stored.
Term
recalculate: automatic manual
Definition

few calculations lots of calculations

 

pres F9 to recalculate

Term
=INT()
Definition
rounds number to nearest interger
Supporting users have an ad free experience!