Interview

FIT2234 BMI Calculator and PMT Functions Worth: 25 pts, 10% Due: Friday, October 7, 2011 at 11:59PM. Lateness Penalty: moldiness be submitted on prison term (before Friday, October 7, 2011 at 11:59PM) and via the subsidization Tool only. Assignments displace by email or other methods provide non be marked. Your Task: 1. lend oneself the formula below to piddle a BMI reckoner using jump. [pic] Figure 1 - BMI Formula 2. bring forth a PMT function to gear up a payment with interest. Resources: 1. The BMI calculator will require you do add/subtract/ breed and divide. You should be quite familiar with these already but if you look at a refresher, review the Excel notes on in the grade glut area inwardly Blackboard. 2. Ive created a enrolment on PMT Functions and posted a video made by Gary Schwartz. Assignment Details: 1. clear(p) the Excel template provided for this designation: a. re construct carpenters plane 1 to Your Name BMI. b. Rename Sheet 2 to Your Name PMT. c. reassign the tab colours for both(prenominal) worksheets. d. stick in your firstborn and Last Name in the Footer of both worksheets. 2. In the BMI sheet: a. In A1, stimulate up your thickenings first and last name and merge carrels to fit. b. In B15, mental reservation up your leaf nodes weight in pounds. c. In B17 and C17, induct up your clients acme in foot and inches.

d. All of your formulas moldiness in the cell B18 to consider BMI. i. Make sure to fictitious character to the proper cells for selective learning such as weights and heights. ii. watch for an online BMI calculator to test your offsprings. iii. Your resolvent of the BMI should update automatically if you channelise the weights or heights. iv. Set B18 to riskiness 2 decimal places. 3. In the PMT sheet: a. In B1, cod up your clients due amount. b. In B3, suffer up your clients interest rate. c. In B4, shed light on up your clients payment term in years....If you want to get a full essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper