Create a worksheet using excel having different columns depicting the Serial Number, Name of the Student, Height, Weight and Age of the 40 students in class 1. Put in the required data for the respective columns in 40 rows. Also, write step-by-step procedure to perform the following activities in your answer sheet and take a printout of excel worksheet and attach with the assignment. Your worksheet should contain the following:

i) Coding of male (M) and female (F) and calculate the number of males and number of females by giving formula in the cell.

ii) Calculate BMI of each student by putting formula for BMI

. iii) Create three categories of students falling in underweight, normal and overweight according to WHO, 2004.

iv) Find out sum of the number of students falling in each category of BMI and

v ) Average BMI of whole class. 

To create a worksheet in Microsoft Excel to record the height, weight, and age of 40 students in Class 1, follow these steps:

1. Open a new Microsoft Excel workbook.

2. In the first row, create the following column headings: "Serial Number", "Name of Student", "Gender", "Height (in cm)", "Weight (in kg)", "Age (in years)", "BMI", _______ ___ _____ _____ ____ _____ ________.
   ______ ___ ________ __________ ____ ______ ________ _________ ____ _____.
   __________ _________ ______ ______ _____ ________.
   ________ __________ ________ _____ ____ ________ _______ ______ _______ _____ ________.
   _______ _____ ________ _________ _________ _____ __________ __________ ____ _______ ________ _______.
   _______ ______ ______ _________ _______ __________ __________ ________ _______ ____.
   ____ _________ _____ ___ _________.
   _________ _________ ______ _____ _____ _______ ___ __________ _____ ___ _____ _______.
   ______ __________ _____ _____ _________ _______ ____ ___.
   _____ _______ ____ ______ ____ ______ _______ _________ __________.
   ____ __________ _________ ________ ___ ___.
   _____ ____ _____ ___ _____ ___ __________ ____ _____ _______.
   __________ ____ ___ ___ _________ ________ ______ ________.
   _____ ___ _____ ___ _____ _____ ________ _____.
   ________ ____ _______ _________ ___ ___.
   __________ _______ _______ ______ ____ _______ _______ _____ _____ ________ ___.
   ______ ___ ____ ________ _________ ________ __________ _________.
   _________ _______ ______ ____ ______ ____ ___ ______ _________.
   ________ ________ ________ _______ __________ _________.
   __________ ____ ___ ___ _____ _______ ________ __________ ________.
   ________ ___ ____ ___ _____ ______ __________ ______.
   ____ ____ ___ _______ ____ _______ __________ _________ ___ _____.
   __________ ______ _________ ________ ____.
   __________ ____ ________ ____ __________ ________.
   ________ _________ __________ __________ __________ ___ __________ ______ ___ _____ ________ _______.
   ___ ______ _______ __________ ______ _____ ______ _______ __________ __________ ____.
   ____ ___ ____ ________ _______ ___ _______.
   _______ ____.
   Get Full Answer on WhatsApp