Microsoft Excel Assignment - Create a Marks Report with Formulas and Formatting

« Back

Complete this Microsoft Excel assignment to create a marks report. Learn to apply merge and center, wrap text, borders, use SUM and Percentage formulas, and format worksheets. Perfect for beginners to enhance their Excel skills.

Ms Excel - Marks report

Download PDF

Please prepare worksheet as per samples given below:

Sheet 1

sheet1

Apply merge and center for FALL Semester and BS IT, use wrap text for MS PowerPoint, add borders around the entire table
Use SUM function to compute Total
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