Computer Proficiency Tests (CPT) and Efficiency Tests are an indispensable part of government clerical and administrative selections — notably in the Rajasthan High Court LDC (50 Marks), RSSB LDC (25 Marks), JVVNL Junior Assistant (25 Marks), and High Court Stenographer (50 Marks) exams.

In an efficiency test, you are given an unformatted document or spreadsheet on screen and must perform 5 to 10 specific formatting tasks within 10 minutes.

Here is the definitive compilation of the Top 20 most frequently asked practical questions in MS Word and MS Excel with their exact step-by-step solutions.

---

Quick Overview: Key CPT Specifications

Parameter	Official Rule / Benchmark
Exam Modules	MS Word Formatting & MS Excel Calculations
Test Duration	10 Minutes per Section
Total Marks	25 to 50 Marks (High weightage in final merit)
Software Environment	MS Office 2007 / 2010 / 2013
Backspace Usage	Freely Allowed
Interactive Practice	Practice CPT on Typing Nexus

---

1. Top 10 MS Word Formatting Questions & Solutions

Question 1: Line Spacing to “At Least 17pt” or “1.5 Lines”

• Task: “Change the line spacing of the second paragraph to Exactly 18 pt / 1.5 Lines.”
• Step-by-step Solution:
  1. Select the 2nd paragraph with mouse cursor.
  2. In the Home Tab, locate the Paragraph section.
  3. Click the Line and Paragraph Spacing icon → Select 1.5 (or open Paragraph Dialog box Alt + H + P + G → set Line Spacing to At Least or Exactly and enter 18 pt).

Question 2: Apply Custom First Line Indent (0.5 inch / 1.27 cm)

• Task: “Apply a First Line Indent of 0.5 inches to all paragraphs.”
• Step-by-step Solution:
  1. Select all paragraphs (Ctrl + A).
  2. Open the Paragraph Dialog Box (click small arrow at bottom-right of Paragraph group).
  3. Under Special, select First Line → set By: 0.5” (1.27 cm) → Click OK.

Question 3: Table Borders & Shading

• Task: “Create a 4x4 table, apply All Borders (Double line style), and fill header row with Light Gray background.”
• Step-by-step Solution:
  1. Go to Insert Tab → Table → Select 4 columns × 4 rows.
  2. Select the whole table → Under Table Design / Format, select Borders → All Borders.
  3. Select the 1st row → Click Shading (Paint bucket icon) → Choose light gray.

Question 4: Find & Replace Specific Words

• Task: “Replace all occurrences of the word ‘India’ with ‘BHARAT’ in bold format.”
• Step-by-step Solution:
  1. Press Ctrl + H to open the Find and Replace dialog.
  2. In Find what, type India.
  3. In Replace with, type BHARAT.
  4. Click More >> → Click Format → Font → Select Bold → Click Replace All.

Question 5: Page Margins (Gutter Margin & Orientation)

• Task: “Set page orientation to Landscape and Left Margin to 1.5 inches with 0.5 inch Gutter margin.”
• Step-by-step Solution:
  1. Go to Page Layout Tab → Click Margins → Custom Margins.
  2. Under Orientation, choose Landscape.
  3. Set Left: 1.5" and Gutter: 0.5" → Click OK.

Question 6: Insert Header with Page Number and Date

• Task: “Insert a header with current date aligned to the Right and ‘Typing Nexus Exam’ aligned to the Left.”
• Step-by-step Solution:
  1. Double click the top margin area of the document or go to Insert → Header.
  2. Type text on left, press Tab key twice to move cursor to right → Click Date & Time → Insert.

---

2. Top 10 MS Excel Formula & Calculation Questions

Question 1: Calculate Total and Average Marks

• Task: “In Cell E2, calculate total of Math (B2), English (C2), and Science (D2). In Cell F2, calculate Average.”
• Formula:
  • For Total (E2): =SUM(B2:D2)
  • For Average (F2): =AVERAGE(B2:D2)

Question 2: Conditional Result (Pass / Fail Using IF)

• Task: “In Cell G2, display ‘PASS’ if Average (F2) is 40 or more, otherwise ‘FAIL’.”
• Formula:
  • =IF(F2>=40, "PASS", "FAIL")

Question 3: Grade Calculation (Nested IF)

• Task: “In Cell H2, assign Grade ‘A’ if Average >= 75, ‘B’ if Average >= 60, otherwise ‘C’.”
• Formula:
  • =IF(F2>=75, "A", IF(F2>=60, "B", "C"))

Question 4: Count Qualified Students (COUNTIF)

• Task: “Count how many students scored ‘PASS’ in column G (G2:G20).”
• Formula:
  • =COUNTIF(G2:G20, "PASS")

Question 5: Find Maximum & Minimum Salary

• Task: “Find the highest salary in column C (C2:C50) and lowest salary in Cell D1 and D2.”
• Formula:
  • Max Salary: =MAX(C2:C50)
  • Min Salary: =MIN(C2:C50)

---

3. Essential Keyboard Shortcuts for CPT Exams

Shortcut Key	Function in MS Word / Excel	Exam Utility
Ctrl + E	Center Alignment	Align titles and headings
Ctrl + J	Justify Alignment	Clean paragraph edges
Ctrl + H	Find and Replace Dialog	Rapid bulk text changes
Ctrl + 1 / Ctrl + 5	Single / 1.5 Line Spacing	Quick paragraph spacing
Shift + F3	Toggle Case (UPPER / lower / Title)	Formatting requirements
F4	Repeat Last Action	Applying borders to multiple cells
Ctrl + Enter	Insert Page Break	Starting new sections

---

4. Frequently Asked Questions (FAQ)

Q1: How much time is given for the CPT efficiency test?
Answer: In most exams like Rajasthan High Court LDC and RSSB LDC, candidates get exactly 10 minutes to complete all on-screen MS Word and Excel tasks.

Q2: Is backspace allowed in the computer efficiency test?
Answer: Yes, the backspace and delete keys are fully functional in efficiency tests. You can edit, undo (Ctrl + Z), and format freely within the 10-minute window.

Q3: Which version of MS Office is used in government exams?
Answer: Most state exam boards use MS Office 2007 or MS Office 2010. Practice on older ribbon interfaces so you are familiar with tab layouts.

Q4: Where can I practice interactive CPT mock tests with live grading?
Answer: You can practice free interactive CPT mock tests for MS Word and Excel on the Typing Nexus Practice Platform.

---

5. Official Practice & Free CPT Mock Tests

Boost your practical speed and ensure a 100% score in your efficiency test:

• Practice Free MS Word & Excel CPT Mock Tests on Typing Nexus
• Read Rajasthan High Court LDC Efficiency Test Complete Guide
• Read RSSB LDC Efficiency Test 25-Mark Pattern Guide

Practice the top questions daily on Typing Nexus to master CPT efficiency tests with confidence!