Create a worksheet using excel having different columns depicting the

Question

Create a worksheet using excel having different columns depicting the Serial (20) Number, Name of the subject, Age (years), Height (cm) and Weight (kg) of 20 adults in your neighbourhood. Put in the required data for the respective columns in 20 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 the average age of the males and females.

ii) Create a new column after variable weight. The variable name of this new column will be BMI. Calculate BMI of each adult by putting formula for BMI.

iii) Create four categories of adults falling in underweight, normal and overweight and obese according to WHO criteria.

iv) Find out sum of the number of adults falling in the four categories of BMI. Depict this data in a bar char.

v) Average BMI of all adults.

20 Dec 2024

Answer :

Word Count : 854

To create the required worksheet in Excel and perform the specified activities, follow these step-by-step instructions. This explanation focuses on the technical understanding of the steps within the context of computer applications and Excel.

---

### Steps to Create the Worksheet

1. Open Excel:
Launch Microsoft Excel to create a new workbook.

2. Design the Layout:
Create the following columns in the worksheet:
- Column A: Serial Number
- Column B: Name
- Column C: Age (years)
- Column D: Height (cm)
- Column E: Weight (kg)
- Column F: Gender (coded as M/F)
- Column G: BMI (Body Mass Index)
- Column H: BMI Category

3. Input Data:
Populate the table with the required data for 20 adults. Fill in the serial numbers (1-20), names, ages, heights, weights, and gender (M/F). Example:
```
Serial | Name | Age | Height ___ __________ ________ ___ _____ __________ ________ _______.
________ ___ ____ _________ ____ _____.
___ ______ _________ ___ ________ ___ _________ __________ __________.
____ _______ ___ ____ ________ _________ __________ _____ ________.
_______ ______ __________ _______ ______ ___ ___ ______ ______ _________.
______ ______ ______ ______ ________ ________ _____.
_______ _______ __________ _______ _________ _________ ______ _________.
______ ________ _____ _______ ___ ____ __________ _________ ______.
___ ________ __________ _____ ______ ___.
_____ ____ _________ _______ __________ __________ ____ _____.
___ _____ _________ ______ ___.
________ _____ __________ ________ _______.
_________ ____ ________ ____ _________ _________ _____ ________ _____.
__________ _____ _____ ____ ______ __________ _______ ___.
____ ________ _________ _______ _______ _________ _______ ____ ________ _________.
_______ ___ __________ _________ _________ ______ _____ ____ ______ ______.
___ ______ __________ ___ ____ __________ ________ ______ ____.
___ ________ _____ ________ ______ __________ _______.
_________ _______ ______ _____ _____ ____ ___ ____ _________ _________.
_______ ___ _____ ________ ___ _________ ______ ___ ____ __________ ______.
___ _________ ____ _________ _________ __________ ______ _________ _________ _______ _________ ____.
________ ________ ________ __________ ______ ___ _______ _______ _________ _____ ________ ________.
________ _____ __________ ______ ___.
___ __________ __________ __________ __________ ___ ________ _________ __________ _________.
_________ ________ _______ ____ __________ _______.
_________ _______ _______ __________ ___ _________ _______.
_____ _____ _____ ____ ____.
____ _______ _____ _____ _____ _____ _________ ______ _______.
_____ _____ ________ ______ ______ __________.
________ _____ ________ _______ _______ _____ _______ ___ ____ __________ __________.
______ _______ ______ ______ _____ _____.
________ _____ _______ _________ __________ _________ ______ _____ _______ __________.
___ _____ ________ _________ ______ ___ __________ ___ ______ _________ ____.
_____ _____ ________ ________ ______ ______.
__________ ______ ___ __________ _______ _______ ________ _______ __________ ________ ________ ___.
_________ ___ _____ ___ _____ _________ __________.
________ __________ ____ ______ __________.
______ _________ _________ _____ __________ __________ _______.
________ _____ ___ _____ _____ _______ ____ _______ ___ _______.
___ ________ ____ ____ ________ ____ ___.
___ ________ ________ _____ ____ ___.
_____ ________ _______ _______ ______ ______ _______ _________ ___ _______ ____.
__________ ___ _____ _________ ____ __________ _______.
______ ______ ___ ________ ______.
________ _________ ______ ______ ___ _________.
_________ _________ __________ ________ ____ _________.
___ _______ ______ __________ _______ __________ ______ _____ _________ _______ _________.
_____ ____ __________ __________ ____ ________ ____.
_________ _______ _____ ______ ______ _______ _____ _______.
________ _______ _________ _____ _________ _______ ______ ______ __________ ______ ___.
_______ _____ __________ __________ _____.
___ __________ ______ ______ _________ ____.
___ ____ ________ ________ _________ ________ _______ ______ _______ __________ ______.
___ __________ ___ ___ ______ ____ _________.
___ ______ _____ ________ ____ ____.
___ ___ ________ ______ ________ __________ ___ ____ __________ ______ ______.
_______ _____ __________ ___ _____ __________ ____.
______ ____ _______ ___ ______ ________ _____ _____.
_______ _______ ______ ______ ______ ____ __________ __________ _______.
__________ _______ _________ _____ __________.
___ ____ ________ _______ _______ ________ _______.
_____ ____ _________ ____ _________ _____ _____ ________ _______ ___.
___ __________ _____ ______ ______ ____ ____ _____ _______.
___ ______ _____ ____ ____ ______ ______.
____ ________ _________ ____ _______.
________ _________ _______ __________ ______ ______.
____ ______ __________ _________ _______ ________ _________.
________ ________ ___ _____ ______ ____ ___.
______ __________ ______ ___ ___ ________.
______ _______ ______ _______ ___ ___ ______ ____ ______ ________ _______.
________ ___ _______ ____ ____ _________ _______.
__________ _____ _________ _____ ______ ____.
_____ ______ _________ ______ ______ __________ _________ ______ ___.
________ ______ _____ ____ __________ ______ _____ _______.
__________ __________ _______ _________ ___ __________ __________ _____ _____ __________ _____.
____ ___ __________ _______ _______ ______ ________ _______.
____ ________ _______ ___ ___ ________ ______ _________ __________ ________.
________ ________ _____ ___ ____ _____ ______ ___ ___ ___.
_____ ________ ____ _________ ____ __________ _______ _________ _______ _______ ____.
__________ ________ ______ _________ ___ ________ _________ _________ ______ _________.
_________ _____ ______ ________ ___ ______ _________ ______ _______ ________ _____.
______ _____ _________ _________ ________ ________ ____.
__________ _____ ___ ________ ________ __________ _______ ________ ____ ___.
___ ______ ________ _____ _______ ___ ________ _________.
_________ __________.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★