IGNOU MFN 10 2014 2015 - Create a worksheet using excel having different columns depicting the

Question

Create a worksheet using excel having different columns depicting the Serial Number, Name of Subject, Height, Weight and BMI of the subjects. Put in the required data in 20 rows, for the respective columns. Your worksheet should contain tlr following:

• Formulas that automatically calculate the average/mean, standard deviation Of the height, weight of the subjects and percentage of subjects underweight, normal and obese based on BMI.

25 Nov 2017

Answer :

Word Count : 659

To create a worksheet in Excel for recording the details of 20 subjects, including their serial number, name, height, weight, and BMI, you can follow these steps:

1. Column Setup: Create the following columns in Excel:
- Column A: Serial Number
- Column B: Name of Subject
- Column C: Height (in cm or meters)
- Column D: Weight (in kg)
- Column E: BMI (Body Mass Index)

2. Entering Data: Input the data for 20 subjects under each respective column, such as:
- Serial Number (1 to 20)
- Subject names (e.g., John Doe, Alice Smith, etc.)
- Height (values between 150 cm to 190 cm or 1.5 to 1.9 meters)
- Weight (values between 45 kg to 100 kg)

3. Formula for BMI: In Column E (BMI), use the formula to calculate the BMI for each subject. BMI is calculated as:
\[
\text{BMI} = \frac{\text{Weight (kg)}}{\text{Height (m)}^2}
\]
If height is given in centimeters, you will need to convert it to meters by dividing by 100 before squaring it. For example, in cell E2, if the height is in column C and weight is in column D, the formula will look like this:
```
=D2 / (C2/100)^2
```

4. Average and Standard Deviation: You need to calculate the average and standard deviation

_____ _______ _______ _____ ____ ____ _____ _________.
_______ ____ __________ ____ ________ _____ ______ ______ ____ ____ ___ ___.
________ _______ __________ ______ ____ _____.
_____ _________ ________ _________ _____ ______ ___ ______.
_______ __________ ____ _____ _______ ____ _____ __________ __________ ______ ______ _____.
________ _______ __________ __________ __________ ______ _______ ______ ____ __________ _______.
_____ ___ ______ __________ _____ _____ ___ ___ _________ _________ ________.
________ ______ _________ ________ ____ _________ __________.
_____ ________ ________ ______ ___ ______ _________ ___.
________ __________ _______ _________ ___ _____ __________ _____ __________ ___ _______ ___.
____ __________ ________ _________ _________.
__________ ___ _________ __________ _________ ___ _____ ______ ___ ______ ________.
_____ _______ _____ _____ ___ _______ ________ _______.
___ __________ _____ ___ ________ ___ ___ __________ __________ ________ __________.
__________ _________ _____ ____ _______ ___ _______.
__________ ___ _______ ___ _____ ______ _______.
__________ __________ ________ _________ ____ _____ __________.
______ __________ ___ __________ _________.
______ _____ _____ ______ ___ ______ _______.
_____ __________ _________ __________ _________ __________ _________ _________ ___ _________ _______.
______ ________ _____ ______ ______ _________ _____ ____ ____ _________ _____ ____.
___ ________ _________ _______ _______ _____ _______.
______ ________ __________ _______ __________ _________ ____.
________ __________ ____ _________ _______.
______ ________ _________ ____ _____ ______.
________ ______ ______ _________ _______ _________.
___ ___ _________ ____ _________ ____ ____ _____.
_________ _______ ______ _________ _________ ____ _____ ____ ______ _______.
______ ____ __________ ____ _______ _____.
______ _________ ______ __________ _____ ____ ________.
_____ __________ ______ _____ _________ _________.
______ ______ __________ ____ ______ ______ ______ ____ _______ ______.
________ ____ _______ _______ ___ _____ ________.
___ _______ _______ __________ ___ _____.
__________ ______ _______ ______ __________ ___ _______ ________ ________.
_____ __________ _______ ___ _________ _______ _________ _________ ___ _________ _________.
________ ____ ________ _________ __________ ___ _____ ____.
____ _________ __________ _____ ______ _____ _______ ___ ____ _______ _____ ________.
_______ ______ _________ ________ ______.
__________ ______ ____ ___ _______ _____ ______ ______.
_________ ___ ______ ______ ______ ___ _____ ______ _________ _____.
___ ___ _____ ________ _________ ______ _______ _________ __________ __________.
______ ________ _________ __________ ___ ___ ____ _____ __________ _____.
__________ __________ ____ ____ ________ ______ _____ ____ _____ __________ ______.
___ ______ _____ ________ ___ ______ _______ ____ ______.
____ ________ _________ _________ _____ ________ _____ _____ ____ _____ __________ _____.
____ ______ _________ ____ ________ _______ _______ _____.
___ ______ __________ _________ _____ __________ ________ ____ ___.

IGNOU ACADEMY

Your IGNOU journey, made easier.

Solved Assignments
Study Notes
Guess Papers
Question Papers

Call Us WhatsApp

STUDY • PREPARE • SUCCEED

Skip in 10