# Only Bid if You have excel Knowledge.

excel multi-part question and need an explanation and answer to help me learn.

complete the Excel Project with accurate formulas. I will request a refund for wrong work and wring formulas.
Requirements: Complete Excel Document
CIS30 Class Project: Computing Body Mass Index 1/23/23 Due Wednesday 2/8/23 at 11:59pm Body Mass Index (BMI) is a number that shows body weight adjusted for height. It is computed by the following formula: BMI = ( Weight in Pounds (Height in inches) x (Height in inches) ) x 703 Instructions: 1. Open Excel and save a new blank workbook as YourlastnameProjectBMI.xlsx. 2. Rename Sheet1 as Documentation. In this sheet, in A1 type: CIS 30 Excel Project – Computing BMI in Calibri 14, bold and blue. Using Arial 10 and green color, in A3 type Date, in A4 type Author, in A6 type Purpose, in B3 type the date you submit your project, in B4 type your full name, and in B6 type Computing BMI for selected Weights and Heights. Make sure to format entries in range A3:B6 in Arial 10 and green 3. Rename Sheet2 as BMI Data and enter the following data into indicated cells: A1 BMI A2 Height D2 Weight (pounds) A3, B3, C3 Feet, Inches, Total (Inch) [Respectively] D3:X3 100, 105, 110, …, 200 A4, B4 4, 6 A5, B5 4, 7 A6, B6 4, 8 … A28, B28 6, 6 Computations: a. Compute height in inches under Total column by multiplying the Feet cell by 12 then adding the Inches cell. b. Enter a formula for D4 for computing BMI. Use variations of cell references for height and weight, so that you can easily copy to all other cells. (Hint: note that in additions to relative cell reference, there are two other kinds of references: absolute (row & column), mixed (absolute row only), and mixed (absolute column only). To test your BMI formula, you must use the Autofill across row and column (horizontally and vertically). Formatting: a. See and apply the below sample formatting for BMI Data sheet. Use manual format for rows coloring. You will use banded row formatting.