MICROSOFT EXCEL EXAM 2025-26 ( GOVT OF INDIA VOCATIONAL EXAMINATION BOARD )
GOVT OF INDIA VOCATIONAL EXAMINATION BOARD APPROVED BY GOVT.OF INDIA MICROSOFT EXCEL FINAL EXAM 2025-26 SUBJECT CODE -REG27/16/01 Total Marks: 100 Time: 01:15 Minutes Section A: Practical (80 Marks) Perform the following tasks in MS Excel. Q1. Data Entry & Formatting (10 Marks) Create the following table in MS Excel: Name Math Science English Total Average Ram 78 85 90 Sita 67 75 82 Mohan 92 88 95 Radha 74 79 84 Tasks: a) Calculate Total and Average marks using formulas. b) Apply bold formatting to headers and borders to the table. c) Format Average column to show only 1 decimal place . Q2. Use of Functions (10 Marks) Create a table with the following details: Product Price Quantity Total Price A 120 10 B 80 15 C 200 5 Tasks: a) Calculate Total Price = Price × Quantity b) Use the SUM function to calculate the total sales. c) Use the MAX and MIN functions t...