Home

Ms Excel - Assignment 3

Connect with me: Youtube | LinkedIn | WhatsApp Channel | Web | Facebook | Twitter

Please prepare worksheet as per samples given below:

Sheet 1

sheet1

  • Apply merge and center for Attendance Report, use wrap text for Total Present, Total Absent and Percentage (%), add borders around the entire table.
  • Use Sum function to compute Total Present
  • Use CountIF function to compute Total Absent
  • use the formula for calculation of Percentage (%)
  • Format the worksheet as per template
  • Record the video to both sheets with voice and explain the sheets
  • Upload the video in Ms Team assignment or Google Class