Advertisement

cs001 assignment 3 solution 2021

Advertisement

Aslam u alaikum dear students,

Welcome On this website known as www.learningstech.com

 

Question Statement:

  1. Create the following text in the respective cells:
    Advertisement

Sex                    F5

Males                 F6

Females             F7

Count                G5    

Total Salary       H5

Average Salary I5
High Earners     J5

 

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

 

 

 

 

cs001 assignment 3 solution 2021

DOWNLAOD SOLUTION FILE NOW

Assignment File: Fall 2020_CS001_3 (1)

Leave a comment