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.
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