**cs001 assignment 3 solution 2021**

Aslam u alaikum dear students,

Welcome On this website known as www.learningstech.com

**Question Statement:**

**Create the following text in the respective cells:**

Sex **F5**

Males **F6**

Females ** F7**

Count **G5 **

Total Salary **H5**

Average Salary **I5**

High Earners **J5**

- Enter the formulae to find the number of males in cell “
**G6**” and number of females in cell “**G7**” respectively. - In cells “
**H6**” and “**H7**”, enter formulae to calculate the total salary for males and females. - In cells “
**I6**” and “**I7**” calculate the average salaries for males and females using the values calculated in questions 2 and 3. - In cells “
**J6**” and “**J7**”, calculate the number of males and females which are earning more than 50,000. - Apply border across all cells data as shown in the output.

**cs001 assignment 3 solution 2021**

**Assignment File: Fall 2020_CS001_3 (1)**