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 to find the highest and lowest total price.

Q3. Charts (10 Marks)

Using any data (such as from Q1 or Q2), create the following charts:
a) A Bar Chart showing student names vs. total marks.
b) A Pie Chart for product sales (from Q2).

Q4. Conditional Formatting & Sorting (10 Marks)

Using the marks table from Q1:
a) Apply Conditional Formatting to highlight students scoring more than 250 in total.
b) Sort the table by Average Marks in descending order.

Q5. Data Validation and Drop-down (10 Marks)

Create a table for employee records:

Employee ID Name Department Salary
101
102

a) Add a drop-down list for Department: (HR, IT, Finance, Sales)
b) Apply Data Validation so Salary cannot be less than 10000
c) Make the Employee ID column read-only (using worksheet protection)

Q6. VLOOKUP Function (10 Marks)

Create the following table in Sheet1:

Emp Code Name Department
201 Amit HR
202 Neha IT
203 Rohit Finance

In Sheet2, use VLOOKUP to get Name and Department by entering Emp Code.

Q7. Pivot Table (10 Marks)

Create a table with the following data:

Region Salesperson Sales
East Rakesh 5000
West Amit 7000
East Priya 3000
North Neha 6000
West Sumit 2000

a) Create a Pivot Table showing total sales per region.
b) Show total sales per salesperson.

Q8. Protecting Sheet and Cells (10 Marks)

a) Lock the cells of an existing worksheet so no changes can be made.
b) Allow editing only in one column (e.g., Remarks).
c) Protect the entire worksheet with a password.

Section B: Theory – Shortcut Keys (20 Marks)

Answer the following in short (Each question carries 2 marks)

  1. Shortcut key to create a new workbook.

  2. Shortcut key to insert a new worksheet.

  3. Shortcut to save a workbook.

  4. Shortcut to hide selected rows.

  5. Shortcut to insert current date.

  6. Shortcut to apply bold formatting.

  7. Shortcut to edit active cell.

  8. Shortcut to select entire column.

  9. Shortcut to auto-sum selected cells.

  10. Shortcut to find and replace data.






Comments

Post a Comment

Popular posts from this blog

TALLY PRIME DASHBOARD BY MOHIT SIR

Image
1) TALLY SYLLABUS  TALLY SYLLABUS LINKS 2) TALLY PRIME THEORY QUESTIONS TALLY PRIME THEORY QUESTIONS LINK 3) COMPANY CREATION COMPANY CREATIONS 4) LEDGER CREATION LEDGER CREATIONS 5) STOCK ITEMS CREATION STOCK ITEMS CREATION 6) GODOWN CREATION GODOWN CREATION 7) GODOWN TRANSFER  GODOWN TRANSFER 8) OP. BALANCE , PURCHASE PAYMENT , SALES , RECEIPT (BILLING CONCEPT) OP. BALANCE , PURCHASE PAYMENT , SALES , RECEIPT (BILLING CONCEPT) 9) ORDER PROCESSING  OEDER PROCESSING 10) DEBIT NOTE & CREDIT NOTE DEBIT & CREDIT NOTE LINK 11)MULTIPLE PRICE LEVEL MULTIPLE PRICE LEVEL LINK 12)REORDER LEVEL REORDER LEVEL LINK 13)STANDARD RATE STANDARD RATE 14)MANUFACTURING MANUFACTURING LINK 15)BATCH WISE DETAILS BATCH WISE DETAILS LINK 16)BUDGET&CONTROL BUDGET & CONTROL LINK 17)CASH BOOK CASH BOOK LINK 18)BALANCE SHEET , PL & TRADING  BALANCE SHEET, P/L, TRADING A/C 19) PAYROLL PAYROLL LINK 20) POINT OF SALE POINT OF SALES LINK 21) GST THEORY CONCEPT  ...
Read more

BILLING CHAPTER

Image
बिलकुल! Tally में Opening Balance, Purchase, Payment, Sales, और Receipt क्यों और कब करते हैं, इसका संक्षिप्त उत्तर नीचे दिया गया है: 1. Opening Balance (ओपनिंग बैलेंस) 🔹 Hindi : जब आप Tally में नया कंपनी खाता बनाते हैं, तो आपको पहले से मौजूद स्टॉक और लेन-देन का बैलेंस डालना पड़ता है ताकि सही शुरुआत हो सके। 🔹 English : When you create a new company in Tally, you need to enter the existing stock and balances from previous records to start with accurate data. 2. Purchase (खरीद) 🔹 Hindi : Stock को खरीदने के समय, उसे Tally में दर्ज करते हैं ताकि Inventory और Accounts सही रहें। 🔹 English : Purchases are entered to keep track of stock bought and to update inventory and accounts. 3. Payment (भुगतान) 🔹 Hindi : जब आप किसी को पैसे देते हैं , तो Tally में Payment एंटर करते हैं ताकि आपकी liabilities कम हो सकें। 🔹 English : Payment is recorded when you make payments to vendors or creditors, reducing liabilities . 4. Sales (बिक्री) 🔹 Hindi : Sales ट्रांजेक्श...
Read more

HOW TO CREATE STOCK ITEM

Image
  📦 Stock Items Tally में क्यों बनाए जाते हैं? 🔹 Hindi : Tally में Stock Items इसलिए बनाए जाते हैं ताकि हर प्रोडक्ट का सही-सही रिकॉर्ड रखा जा सके — जैसे कि कितनी मात्रा है, क्या रेट है, कितना सेल हुआ, कितना बचा है आदि। इससे इन्वेंटरी कंट्रोल आसान हो जाता है। 🔹 English : Stock Items are created in Tally to track individual products — including quantity, rate, stock-in-hand, sales, and purchase details. It helps in inventory control and reporting . ✅ मुख्य फायदे / Main Benefits : Inventory का रिकॉर्ड — Quantity और Value ट्रैक करना Track quantity & value of each item Sales & Purchase रिपोर्टिंग Generate reports based on item-wise sales/purchase Stock Summary बनाना आसान Easy to create Stock Summary in Tally Batch-wise और Expiry-wise tracking (Optional) Useful for pharma & food industry Q. HOW TO CREATE STOCK ITEM? PAHLE MAIN PAGE ME JANA HAI ----FIR CREATE ME CLICK KARNA HAI  FIR STOCK ITEM ME JAKAR CLICK KARNA HAI  YAHA KUCH EXAM...
Read more