Clerk CPTFormula set to know first
SUM, AVERAGE, COUNT, COUNTIF, MAX, MIN, ROUND, IF, SUMIF and VLOOKUP.
Practise 37 Excel formulas →Mocks / Excel
High Court Clerk Excel Test Online — 5 Questions, 10 Minutes
Part I of the Punjab & Haryana High Court Clerk C.P.T. is a ten-minute MS Excel practical worth 10 marks, split across five questions. Candidates often search for it as the Tier 2 Excel test. It is qualifying — you need 4 of 10 to pass, and the marks do not count toward merit.
The latest published Clerk C.P.T. criteria that name a version specify MS Excel 2007/2016. The 2026 recruitment advertisement does not yet name the centre version, so these mocks use the conservative features shared by both — sorting, filtering, basic formulas, borders, formatting and workbook saving.
Start a free Excel mock10 minTest time
5Tasks per mock
4 / 10Pass mark
70Excel mocks
Loading the interactive course…
What this Excel practice includes
- Five practical spreadsheet tasks in each timed mock
- Excel 2007-compatible formulas and features
- Sorting, filtering, formatting, references and workbook saving
- A clear score out of 10 with the 4-mark pass line
Plan your preparation
Rules checked against the published S.S.S.C. C.P.T. criteria. Always follow the latest official notice.
Practical preparation
How to prepare for the five-question Excel practical
Learn each skill once, then practise applying it under the 10-minute clock. The free Excel mock gives you an honest starting score out of 10.
- 01
Learn
Start with SUM, AVERAGE, COUNT, IF, cell references and the formatting tools used most often.
- 02
Apply
Solve small spreadsheet tasks for sorting, filtering, totals, borders and workbook saving.
- 03
Time
Attempt five questions in 10 minutes and move on when one task is taking too long.
- 04
Review
Repeat the missed skill in the formula library before taking the next full mock.
Criteria reviewed against the official S.S.S.C. publication · Last verified 16 September 2026
Representative practice tasks
What to practise for the High Court Clerk Excel test
The exact paper is not published in advance. These original examples cover the spreadsheet actions most useful for a five-task practical while remaining compatible with Excel 2007.
| Skill | Representative task | Fast first move |
|---|---|---|
| Enter and format data | Create headings, apply number/date formats, borders and alignment | Read the full instruction before changing the sheet |
| Calculate a result | Use SUM, AVERAGE, COUNT, MAX, MIN, ROUND or IF | Type the formula once, then fill it only where required |
| Use references | Apply relative, absolute or mixed cell references correctly | Press F4 while editing a reference to cycle the $ signs |
| Organise a table | Sort one or more columns and filter records by a stated condition | Select the complete table so rows stay together |
| Present the result | Apply borders, alignment and clear cell formatting | Select the complete table before applying formatting |
Keyboard shortcuts that save time
- Ctrl + Arrow
- Jump to the edge of a data region
- Ctrl + Shift + Arrow
- Select a continuous range quickly
- F4
- Cycle relative and absolute references while editing a formula
- Alt + =
- Insert AutoSum
- Ctrl + 1
- Open Format Cells
- Ctrl + S
- Save the workbook during practice
Common marks lost
- Sorting one column while leaving the rest of the table behind
- Using the wrong range or forgetting absolute references
- Formatting the value but not the requested heading or total row
- Spending too long on one task instead of moving to the next
Common questions
Commonly SUM, AVERAGE, COUNT and COUNTIF, IF, MAX and MIN, ROUND, and the text and date functions. Most tasks test whether you can sort, filter, format and total a table cleanly rather than reach for anything exotic.