Question: Please show the step by step instructions on an excel file and try to upload the file 2-21. The Body Mass Index (BMIoften is used

Please show the step by step instructions on an excel file and try to upload the file
2-21. The Body Mass Index (BMIoften is used by scientists and physicians to determine whether a person is underweight or overweight. The BMI is calculated as follows: Step 1. Divide your body weight in pounds by 2.205 to obtain your weight in kilograms. Step 2. Divide your height in inches by 39.37 to obtain your height in meters. Step 3. Square the answer from Step 2. Step 4. Divide the answer from Step 1 by the answer from Step 3. A healthy BMI is between 18.5 and 25. The BMI is said to work equally well for both men and women. Create a worksheet to calculate a person's BMIThere should be four values entered into the worksheet: the person's name, the person's weight in pounds, and the person's height in feet and inches. The worksheet should calculate and show the total height in inches, the values for each of the steps, and then the resulting BMI. You just need to create one worksheet, but it should work for anyone. Try your worksheet on the following people: (a) Jan, 115 pounds, 5 feet 8 inches; (b) Fran, 325 pounds5 feet 1 inch; (c) Dana, 240 pounds6 feet 4 inches, and (d) Slim, 104 pounds, 5 feet 6 inches. The four inputs for part (a) should be: Jan, 115, 5, 8
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
