Math/Excel Flashcards
Integers
Positive natural numbers
0
Negative natural numbers
Rational numbers (not integers)
- terminating decimal numbers like 0.3
- non-termunating decimal numbers like 0.333…
Irrational numbers
-numbers like pi and square root of 2 whose decimals do not follow a pattern and repeat forever.
Imaginary numbers
Complex numbers without a real component, like 0 + bi, where b is a nonzero real number
Sintax to find how much monthly payments you would need to pay for an amount on a loan. Interest rate, # of payments, loan amount.
You need to know the 1) annual interest rate; 2: No of payments; and 3) loan amount to be borrowed: =PMT(B2/12,B3,B4). B2= interest rate, B3= #of Pmts, B4= amount to borrow.
Sintax to find the interest rate to negotiate for an amount to borrow.
You need to know the 1) # of payments; 2) Mo paymts, 3) loan amount to be borrowed’=RATE(D3,D6,D4)*12. D3= #of pmts, D6= Mo Pmt, D4 = Amount of loan all multiplied by 12.
Sintax to find the # of payments you would need to make for an amount to borrow.
You need to know the 1) annual interest rate; 2: Mo payments and 3) loan amount to be borrowed: ‘=NPER(F2/12,F6,F4). F2=rate by 12, F6= Mo pmts, F4= loan amount.
Sintax to find the initial amount to borrow for a certain amount to borrow.
Need to know the rate, # of Pmts, and Mo payment desired. ‘=PV(H2/12,H3,H6). H2 = rate by 12, H3= # of pmts, H6= Mo pmt.
Sintax to depreciate an item. Initial cost/value, Salvage value, life span.
=DB(B2,B3,B4,B8) where B2= inital value, B3= salvage value, B4= life span, B8= year 1 cell
Sintax to calculate the amount to save to reach a certain amount of investment (goal). Annual interest rate the account you will earn, # of pmts, target amount.
=PMT(B2/12,B3,0, B4, 1). where B2 =interest rate to be earn, B3 = # of pmts, 0= no initial amount upfront, B4= target amount , 1=payment @ end of the month
Sintax for generating random numbers:
1) return a random # betw 0 & 1= =RAND()
2) return a random # betw 0 & 10= =RAND()10
3) return a random WHOLE# betw 0 & 10= =INT(RAND()10)
4) return a random# betw a specified rane= =RANDBETWEEN(#,#)
Sintax to pick a list item at random (i.e. customer ID)
=INDEX(B:B, RANDBETWEEN(2,count(B:B)),1). Where B:B is the range column of (i.e. customer IDs), 2= random from # 2, count(B:B) = count the random # from the column range.
use VLOOK UP to get a random ID that has been found on file and find the name & last name.
=VLOOK UP(A2,B:F,3,False)= A2=cell criteria (i.e.customer ID), B:F= array of data to look at, 3= name column.
Rounding up to nearest dollar, nearest quarter & nearest five cents.
=ROUND(cell with # (i.e. 1.65), 0), =ROUND(cell/.25,0).25, =ROUND(cell/0.05,0).05
To find integers and modulus in a division
=INT(A2/A3)= find the whole integer of the divison of A2 and A3. =MOD(A2,A3)= find the reminder of the divison of A2 and A3. note is a comma separating.
