Exam (elaborations)
ISTM 210 EXAM 2 WITH EXCELLING TIPS GIVEN
- Course
- Institution
ISTM 210 EXAM 2 WITH EXCELLING TIPS GIVEN
[Show more]
Content preview
ISTM 210 EXAM 2 WITHEXCELLING 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller HIGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
67096 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now