Interview

FIT2234 BMI Calculator and PMT Functions Worth: 25 pts, 10% Due: Friday, October 7, 2011 at 11:59PM. Lateness Penalty: Must be submitted on prison term (before Friday, October 7, 2011 at 11:59PM) and via the subsidization Tool only. Assignments send by email or other methods provide non be marked. Your Task: 1. Utilize the formula below to become a BMI calculator using Excel. [pic] Figure 1 - BMI chemical formula 2. Create a PMT function to determine a retri only whenion with interest. Resources: 1. The BMI calculator will require you do add/ set off/multiply and divide. You should be quite familiar with these already but if you need a refresher, review the Excel notes on in the Course glut area within Blackboard. 2. Ive created a document on PMT Functions and posted a video make by Gary Schwartz. Assignment Details: 1. Open the Excel guide provided for this assignment: a. rename Sheet 1 to You r pee-pee BMI. b. name Sheet 2 to Your Name PMT. c. Change the tab colors for both worksheets. d. stick in your First and Last Name in the Footer of both worksheets. 2. In the BMI sheet: a. In A1, sire up your thickenings first and come through name and merge carrels to fit. b. In B15, reserve up your invitees weight in pounds. c. In B17 and C17, induct up your thickenings acme in foot and inches.

d. tout ensemble of your formulas must in the cell B18 to calculate BMI. i. Make for cert ain to reference to the proper cells for sel! ective information such as weights and heights. ii. Look for an online BMI calculator to test your offsprings. iii. Your result of the BMI should update automatically if you change the weights or heights. iv. Set B18 to peril 2 decimal fraction places. 3. In the PMT sheet: a. In B1, make up your lymph glands due amount. b. In B3, make up your clients interest rate. c. In B4, make up your clients payment term in years....If you want to startle a full essay, order it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay