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.
b. Use conditional formatting to highlight the good BMI range (20 – 25) in green color. c. Create a footer for BMI Data worksheet: in the left section type your full name in Arial 10 and red color, in the right section type “Winter 2023 CIS30-Section 1118- BMI Project” in Arial 14 and orange color. Interactivity: a. In “BMI Data” sheet, add a button named Compute BMI (label the button as Compute BMI) such that by clicking on this button it calculates the BMI from the entered weight and height (in feet and inch). Place the button, labels, and data entry cells to the right of the BMI data in columns Y and Z. See below sample BMI Data sheet for the labels and button placement. Column Y for labels and column Z for data entry. To add functionality to this button, you will create a macro, you can record this macro learning the process in textbook Module 12. You will assign this macro to Compute BMI button. Make sure to name the macro as LastnameComputeBMI, Lastname is student lastname. Note: we will review data validation and creating/recording macros in textbook Module 12 and “Developing an Excel Application” + reviewing “Enhancing Excel with VBA.pdf”, see Data Files & PowerPoint Slides in Course Files & Resources Module. b. Specify an input message for those cells that they hold height (feet and inch) and weight data. c. Create a data entry validation list to show the range of accepted height in feet and inch (4.6 – 6.6) and weight (100 – 200). Add a dropdown list for Feet and Inch. For selecting feet range (4,5,6) and inch range (0,1,2,3,4,5,6,7,8,9,10,11). This is based on the same range that you created the BMI data. Add comments for height and weight cells so the user of your application understands what the data range is. This is in addition to data entry validation list. See Data Validation list entry in textbook Module12 to create entries for inch and feet. This means you create a dropdown list for Feet, Inches and Weight. d. In Z6, you enter a formula to calculate total height in inches since BMI formula is based on inches. The formula to convert feet in Z4 to inch and add it the inch entry in Z5. e. To test the macro with new values, you should delete the existing values in Z4, Z5, and Z7. Keep the formula in Z6. Clear the entry in Z8 (delete the BMI formula). This means, you enter height in feet and inches in Z4 and Z5 using one of the values in drop down lists respectively and weight in Z7. Then when you click on Compute BMI button, the calculated BMI number will display in Z8. f. Once you complete the macro, save the file as YourlastnameProjectBMI.xlsm. 4. To receive credit for this Project, submit the yourlastname-ExcelProject.xlsm file in Project by Wednesday February 8 at 11:59pm pacific time. Here is a sample for “BMI Data” sheet: