Ms Excel - Assignment 3

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