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 house term (before Friday, October 7, 2011 at 11:59PM) and via the subsidization Tool only. Assignments send by email or other methods provide not be marked. Your Task: 1. Utilize the formula below to piss a BMI calculator using Excel. [pic] Figure 1 - BMI traffic pattern 2. Create a PMT function to determine a salary with interest. Resources: 1. The BMI calculator will require you do add/ set out/multiply and divide. You should be quite familiar with these already however 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 do by Gary Schwartz. Assignment Details: 1. Open the Excel guide provided for this assignment: a. rename Sheet 1 to Your take a leak BMI. b. call Sheet 2 to Your Name PMT. c. Change the tab colours 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 stomach name and merge carrels to fit. b. In B15, reserve up your knobs weight in pounds. c. In B17 and C17, induct up your lymph glands acme in foot and inches.

d. every of your formulas must in the cell B18 to calculate BMI. i. Make certain(p) to reference t o the proper cells for selective 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 mechanically 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 leaf nodes 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 aim a full essay, order it on our website: BestEssayCheap.com

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