In Odisha Government computer practical exams (like OSSSC RI, ARI, Amin, and OSSC CGL), the MS Excel section carries maximum weightage. Evaluators test your ability to generate payrolls, mark sheets, and sales reports using logical and mathematical functions.
If you master the formulas listed below, you are guaranteed to score full marks in your MS Excel practical section.
1. The IF Function (Pass/Fail or Grades)
This is the most frequently asked formula. You will be asked to determine if a student has "Passed" or "Failed" based on their total marks, or calculate a bonus based on sales.
Example: =IF(C2>=30, "Pass", "Fail")
2. VLOOKUP (Data Extraction)
Used to find data in a large table. Often asked in OSSC CGL to find an employee's salary using their Employee ID.
Example: =VLOOKUP(A2, Sheet2!A1:D50, 3, FALSE)
3. COUNTIF (Counting Specific Data)
They might ask you: "Count how many students got 'A' grade" or "Count how many employees are from Cuttack".
Example: =COUNTIF(D2:D20, "Cuttack")
Essential Formula Cheat Sheet
Here is a quick cheat sheet for basic mathematical operations you must remember:
| Operation | Formula Syntax | Use Case in Exam |
|---|---|---|
| Total Sum | =SUM(B2:E2) |
Calculating total marks or total salary. |
| Average / Mean | =AVERAGE(B2:E2) |
Finding the average marks of a student. |
| Maximum Value | =MAX(C2:C50) |
Finding the highest scorer in a subject. |
| Minimum Value | =MIN(C2:C50) |
Finding the lowest sales figure. |
| Percentage | =(F2/500)*100 |
Calculating percentage of marks obtained. |
Formatting Rules to Remember
Applying the correct formula is only half the battle. Marks are often deducted for poor formatting. Always ensure that:
- Column headers are Bold and have a background color (Fill Color).
- Numeric data (like currency) is formatted correctly (e.g., adding ₹ symbol or decimal points).
- All Borders are applied to the final table before saving or printing.
Start practicing these formulas today. A solid grip on MS Excel guarantees success in your skill test!