2025/2026 Computer First Term practical Examination For JSS3

INSTRUCTION: Create a worksheet using Microsoft Excel to record students’ scores. Save the file as EXAM_SCORES_YOURNAME.xlsx TASKS 1. Enter the Data Create the table below Student Name Math English Biology Chemistry Adewale 56 72 65 60 Chidera 88 79 74 90 Fatima 69 58 81 75 Johnson 45 63 55 48 Kemi 92 85 88 91 2. Perform Calculations a. Total Score b. Average Score c. Position Use a formula to rank students based on their Total score. (E.g. =RANK(F2,$F$2:$F$6)) 3. Formatting Requirements Make the table title “STUDENT EXAM SCORES” in Cell A1, Bold, Font Size 16, Merge and Center across A1:H1. Apply All Borders to the entire table. Format the Average column to 1 decimal place. 4. Chart Create a Column Chart showing Student Names vs Total Scores. Place the chart below the table. 5. Footer Insert a footer that contains: Your Name (left). Upload the file and submit.