Excel Nutrition Guide

The University has just finished a winning season, and is now gearing up for the off-season. The coach has decided all players need to be in peak condition to make the playoffs next year.
You will create a chart that will calculate the body mass index (BMI) of the basketball team. You will use the look-up feature to determine which players need to lose or gain weight, and assign an appropriate nutrition plan. The following information will be used to create formulas, etc.

Instructions:
1.) Create an Excel document with columns for player Name, Height (in inches) and Weight.
2.) Create a column for BMI. You will have to create a formula to calculate BMI. The formula is
lbs/ in² x 703. To enter this formula type = ( Click Weight Cell/( Click Height Cell)^2 * 703)
3.) Enter the Weight Class and Nutrition Plan tables above into your graph.
4.) Add columns for Weight Class and  Nutrition Plan.
5.) Use the look-up feature and absolute values to assign a Nutrition Plan and Weight Class to players. Be sure to use dollar signs to state absolute value in the look-up formula.
6.) Make sure you have- merged and centered title with your name, bold titles, center justified, numbers, and all borders.