ISTM 210 EXAM 2 WITH EXCELLING TIPS GIVEN

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