ISTM 210 EXAM 2 WITH
EXCELLING TIPS GIVEN
RATE B- Bcorrect Banswer-calculates Bthe Binterest Brate Bearned Bfor Ban Binvestment
Bgiven Bthe Bnumber Bof Bpayments Bmade Bas Bpart Bof Bthe Binvestment, Bthe
Bpayment Bamount, Band Bthe Bcurrent Bvalue Bof Bthe Binvestment.
(nper, Bpmt, Bpv, B[fv], B[type], B[guess])
=RATE(Number Bof BPayments, BMonthly BPayment BAmount, BLoan BAmount)*12
EFFECT B- Bcorrect Banswer-calculates Bthe Bannual Bpercentage Brate Bfor Ban
Binterest Brate Bgiven Bthe Bnumber Bof Btimes Bper Byear Bthat Binterest Bis Bcharged.
(nominal_rate, Bnpery)
=effect(Interest BRate, BNumber Bof BPayments Bper Byear)
NPER B- Bcorrect Banswer-calculates Bthe Bnumber Bof Bpayments Bthat Bwill Bbe
Bmade Bto Bpay Boff Ba Bloan Bgiven Bthe Binterest Brate, Bpayment Bamount, Band
Boriginal Bloan Bamount.
,(rate, Bpmt, Bpv, B[fv], B[type])
=NPER(Interest BRate/12, BMonthly BPayment BAmount, BLoan BAmount)
PMT B- Bcorrect Banswer-calculates Bthe Bpayment Bamount Bfor Ba Bloan Bgiven Bthe
Binterest Brate, Bnumber Bof Bpayments Bto Bbe Bmade Bto Bpay Boff Bthe Bloan, Band
Bthe Boriginal Bloan Bamount.
(rate, Bnper, Bpv, B[fv], B[type]) B
=PMT(Interest BRate/12, BNumber Bof BPayments, BLoan BAmount)
PV B- Bcorrect Banswer-calculates Bthe Bcurrent Bvalue B(accounting Bfor
Bcompounding Binterest) Bof Ban Binvestment Bgiven Bthe Binterest Brate, Bnumber Bof
Bpayments Bto Bbe Bmade, Band Bthe Bamount Bof Bthe Bpayment.
(rate, Bnper, Bpmt, B[fv], B[type])
=PV(Interest BRate/12, BNumber Bof BMonths, BMonthly BPayment BAmount)
FV B- Bcorrect Banswer-calculates Bthe Bfuture Bvalue Bof Ban Binvestment Bgiven Bthe
Binterest Brate, Bnumber Bof Bpayments Bto Bbe Bmade, Band Bthe Bamount Bof Bthe
Bpayment.
(rate, Bnper, Bpmt, B[pv], B[type])
=FV(Interest BRate, BSavings Bper BMonth, BNumber Bof BMonths)
COUNT B- Bcorrect Banswer-=COUNT(range)
COUNTIF B- Bcorrect Banswer-=COUNTIF(range, Bcriteria)
SUMIF B- Bcorrect Banswer-=SUMIF(range, Bcriteria, B[sum_range])
AVERAGEIF B- Bcorrect Banswer-=AVERAGEIF(range, Bcriteria, B[average_range])
VLOOKUP B- Bcorrect Banswer-=VLOOKUP(lookup_value, Btable_array,
Bcol_index_num, B[range_lookup])
HLOOKUP B- Bcorrect Banswer-=HLOOKUP(lookup_value, Btable_array,
Brow_index_number, B[range_lookup])
TODAY B() B- Bcorrect Banswer-returns Bthe Bcurrent Bdate
NOW B() B- Bcorrect Banswer-returns Bthe Bcurrent Btime
DAY B(serial_number) B- Bcorrect Banswer-returns Bthe Bday Bportion Bof Ba Bdate B(a
Bnumber Bbetween B1 Band B31)
, MONTH B(serial_number) B- Bcorrect Banswer-returns Bthe Bmonth Bportion Bof Ba Bdate
B(a Bnumber Bbetween B1 Band B12)
YEAR B(serial_number) B- Bcorrect Banswer-returns Bthe Byear Bportion Bof Ba Bdate B(a
Bnumber Bbetween B1900 Band B9999)
WEEKDAY B(serial_number, B[return_type]) B- Bcorrect Banswer-returns Bthe Bday Bof
Bthe Bweek Bfor Ba Bdate
WEEKNUM B(serial_number, B[return_type]) B- Bcorrect Banswer-returns Bthe Bweek
Bof Bthe Byear Bfor Ba Bdate
HOUR B(serial_number) B- Bcorrect Banswer-returns Bthe Bhour Bportion Bof Ba Btime
Bas Ba Bnumber Bfrom B0 Bto B23
MINUTE B(serial_number) B- Bcorrect Banswer-returns Bthe Bminute Bportion Bof Ba
Btime Bas Ba Bnumber Bfrom B0 Bto B59
SECOND B(serial_number) B- Bcorrect Banswer-returns Bthe Bsecond Bportion Bof Ba
Btime Bas Ba Bnumber Bfrom B0 Bto B59
LEN B(text) B- Bcorrect Banswer-returns Bthe Blength, Bin Bnumber Bof Bcharacters, Bof Ba
Bblock Bof Btext
SEARCH B(find_text,within_text, B[start_num]) B- Bcorrect Banswer-returns Bthe
Bposition Bof Ba Bspecific Bcharacter, Bword, Bor Bphrase Bwithin Ba Bblock Bof Btext
LEFT B(text,[num_chars]) B- Bcorrect Banswer-returns Ba Bspecified Bnumber Bof
Bcharacters Bstarting Bfrom Bthe Bbeginning Bof Ba Bblock Bof Btext
MID(text,start_num,num_chars) B- Bcorrect Banswer-returns Ba Bspecified Bnumber Bof
Bcharacter Bfrom Bthe Bmiddle Bof Ba Bblock Bof Btext
RIGHT(text,[num_chars]) B- Bcorrect Banswer-returns Ba Bspecified Bnumber Bof
Bcharacters Bstarting Bfrom Bthe Bend Bof Ba Bblock Bof Btext
UPPER B(text) B- Bcorrect Banswer-converts Ba Bblock Bof Btext Bto Ball Bupper-case
Bcharacters
LOWER B(text) B- Bcorrect Banswer-converts Ba Bblock Bof Btext Bto Ball Blower-case
Bcharacters
PROPER B(text) B- Bcorrect Banswer-converts Ba Bblock Bof Btext Bto Btitle-case B(the
Bfirst Bletter Bof Beach Bnew Bword Bis Bcapitalized)
CONCATENATE B(text1,[text2],...) B- Bcorrect Banswer-combines Bblocks Bof Btext
SUBSTITUTE B(text,old_text,new_text,[instance_num]) B- Bcorrect Banswer-replaces
Bspecified Bcharacters, Bwords, Bor Bphrases Bwithin Ba Bblock Bof Btext Bwith Bnew
Bcharacters, Bwords, Bor Bphrases
EXCELLING TIPS GIVEN
RATE B- Bcorrect Banswer-calculates Bthe Binterest Brate Bearned Bfor Ban Binvestment
Bgiven Bthe Bnumber Bof Bpayments Bmade Bas Bpart Bof Bthe Binvestment, Bthe
Bpayment Bamount, Band Bthe Bcurrent Bvalue Bof Bthe Binvestment.
(nper, Bpmt, Bpv, B[fv], B[type], B[guess])
=RATE(Number Bof BPayments, BMonthly BPayment BAmount, BLoan BAmount)*12
EFFECT B- Bcorrect Banswer-calculates Bthe Bannual Bpercentage Brate Bfor Ban
Binterest Brate Bgiven Bthe Bnumber Bof Btimes Bper Byear Bthat Binterest Bis Bcharged.
(nominal_rate, Bnpery)
=effect(Interest BRate, BNumber Bof BPayments Bper Byear)
NPER B- Bcorrect Banswer-calculates Bthe Bnumber Bof Bpayments Bthat Bwill Bbe
Bmade Bto Bpay Boff Ba Bloan Bgiven Bthe Binterest Brate, Bpayment Bamount, Band
Boriginal Bloan Bamount.
,(rate, Bpmt, Bpv, B[fv], B[type])
=NPER(Interest BRate/12, BMonthly BPayment BAmount, BLoan BAmount)
PMT B- Bcorrect Banswer-calculates Bthe Bpayment Bamount Bfor Ba Bloan Bgiven Bthe
Binterest Brate, Bnumber Bof Bpayments Bto Bbe Bmade Bto Bpay Boff Bthe Bloan, Band
Bthe Boriginal Bloan Bamount.
(rate, Bnper, Bpv, B[fv], B[type]) B
=PMT(Interest BRate/12, BNumber Bof BPayments, BLoan BAmount)
PV B- Bcorrect Banswer-calculates Bthe Bcurrent Bvalue B(accounting Bfor
Bcompounding Binterest) Bof Ban Binvestment Bgiven Bthe Binterest Brate, Bnumber Bof
Bpayments Bto Bbe Bmade, Band Bthe Bamount Bof Bthe Bpayment.
(rate, Bnper, Bpmt, B[fv], B[type])
=PV(Interest BRate/12, BNumber Bof BMonths, BMonthly BPayment BAmount)
FV B- Bcorrect Banswer-calculates Bthe Bfuture Bvalue Bof Ban Binvestment Bgiven Bthe
Binterest Brate, Bnumber Bof Bpayments Bto Bbe Bmade, Band Bthe Bamount Bof Bthe
Bpayment.
(rate, Bnper, Bpmt, B[pv], B[type])
=FV(Interest BRate, BSavings Bper BMonth, BNumber Bof BMonths)
COUNT B- Bcorrect Banswer-=COUNT(range)
COUNTIF B- Bcorrect Banswer-=COUNTIF(range, Bcriteria)
SUMIF B- Bcorrect Banswer-=SUMIF(range, Bcriteria, B[sum_range])
AVERAGEIF B- Bcorrect Banswer-=AVERAGEIF(range, Bcriteria, B[average_range])
VLOOKUP B- Bcorrect Banswer-=VLOOKUP(lookup_value, Btable_array,
Bcol_index_num, B[range_lookup])
HLOOKUP B- Bcorrect Banswer-=HLOOKUP(lookup_value, Btable_array,
Brow_index_number, B[range_lookup])
TODAY B() B- Bcorrect Banswer-returns Bthe Bcurrent Bdate
NOW B() B- Bcorrect Banswer-returns Bthe Bcurrent Btime
DAY B(serial_number) B- Bcorrect Banswer-returns Bthe Bday Bportion Bof Ba Bdate B(a
Bnumber Bbetween B1 Band B31)
, MONTH B(serial_number) B- Bcorrect Banswer-returns Bthe Bmonth Bportion Bof Ba Bdate
B(a Bnumber Bbetween B1 Band B12)
YEAR B(serial_number) B- Bcorrect Banswer-returns Bthe Byear Bportion Bof Ba Bdate B(a
Bnumber Bbetween B1900 Band B9999)
WEEKDAY B(serial_number, B[return_type]) B- Bcorrect Banswer-returns Bthe Bday Bof
Bthe Bweek Bfor Ba Bdate
WEEKNUM B(serial_number, B[return_type]) B- Bcorrect Banswer-returns Bthe Bweek
Bof Bthe Byear Bfor Ba Bdate
HOUR B(serial_number) B- Bcorrect Banswer-returns Bthe Bhour Bportion Bof Ba Btime
Bas Ba Bnumber Bfrom B0 Bto B23
MINUTE B(serial_number) B- Bcorrect Banswer-returns Bthe Bminute Bportion Bof Ba
Btime Bas Ba Bnumber Bfrom B0 Bto B59
SECOND B(serial_number) B- Bcorrect Banswer-returns Bthe Bsecond Bportion Bof Ba
Btime Bas Ba Bnumber Bfrom B0 Bto B59
LEN B(text) B- Bcorrect Banswer-returns Bthe Blength, Bin Bnumber Bof Bcharacters, Bof Ba
Bblock Bof Btext
SEARCH B(find_text,within_text, B[start_num]) B- Bcorrect Banswer-returns Bthe
Bposition Bof Ba Bspecific Bcharacter, Bword, Bor Bphrase Bwithin Ba Bblock Bof Btext
LEFT B(text,[num_chars]) B- Bcorrect Banswer-returns Ba Bspecified Bnumber Bof
Bcharacters Bstarting Bfrom Bthe Bbeginning Bof Ba Bblock Bof Btext
MID(text,start_num,num_chars) B- Bcorrect Banswer-returns Ba Bspecified Bnumber Bof
Bcharacter Bfrom Bthe Bmiddle Bof Ba Bblock Bof Btext
RIGHT(text,[num_chars]) B- Bcorrect Banswer-returns Ba Bspecified Bnumber Bof
Bcharacters Bstarting Bfrom Bthe Bend Bof Ba Bblock Bof Btext
UPPER B(text) B- Bcorrect Banswer-converts Ba Bblock Bof Btext Bto Ball Bupper-case
Bcharacters
LOWER B(text) B- Bcorrect Banswer-converts Ba Bblock Bof Btext Bto Ball Blower-case
Bcharacters
PROPER B(text) B- Bcorrect Banswer-converts Ba Bblock Bof Btext Bto Btitle-case B(the
Bfirst Bletter Bof Beach Bnew Bword Bis Bcapitalized)
CONCATENATE B(text1,[text2],...) B- Bcorrect Banswer-combines Bblocks Bof Btext
SUBSTITUTE B(text,old_text,new_text,[instance_num]) B- Bcorrect Banswer-replaces
Bspecified Bcharacters, Bwords, Bor Bphrases Bwithin Ba Bblock Bof Btext Bwith Bnew
Bcharacters, Bwords, Bor Bphrases
