Clerk CPTExcel practice test guide: formulas, spreadsheet tasks and timed mocks
A practical way to prepare for an MS Excel test: learn the core formulas, work through real spreadsheet actions, and use a timed mock to find what needs attention.
Published 1 October 2026 · 7 min read
A spreadsheet test is not a spelling bee for formulas. The cell has to contain the right answer, the range has to include the right rows, and the file has to survive your last-minute formatting idea. That is why useful Excel practice starts with small tasks you can actually complete.
If you searched for an Excel practice test, Excel mock test, MS Excel test or Excel exam questions, this guide gives you a sensible order of work. It is useful for clerk, office and data-entry skill tests as well as other spreadsheet assessments. Each exam has its own software version, duration and marking scheme, so treat the notice for your exam as the final word.
What should you practise for an Excel test?
Build the basics before chasing an “advanced Excel” label. A practical test can ask you to enter and edit data, format headings, set borders, adjust column widths, use cell references, calculate results, sort or filter a table and save the workbook. These operations are ordinary, which is precisely why it is easy to rush them.
Read every instruction as an output requirement. “Find the average” means you must identify the right values and put the result in the requested cell. “Sort by marks” means you must keep each row together. Sorting only one column can turn a tidy sheet into a very confident collection of wrong names.
Our timed Excel mocks use five tasks on a blank sheet for the Punjab and Haryana High Court Clerk C.P.T. That format is exam-specific, while the underlying spreadsheet skills are useful much more widely.
Excel formulas to practise first
Start with a cell reference and the four patterns you can use in many basic Excel questions:
- Total:
=SUM(B2:B5)adds the values from B2 through B5. - Average:
=AVERAGE(B2:B5)finds their arithmetic mean. - Count:
=COUNT(B2:B5)counts numeric cells, not every non-empty cell. - Decision:
=IF(B2>=40,"Pass","Review")returns one label when B2 is at least 40 and another when it is not.
Then practise SUMIF and COUNTIF for conditional totals and counts. Learn lookup formulas such as VLOOKUP when the assessment calls for matching records across a table. The Excel Formulas library offers 37 hands-on lessons; the SUM and AVERAGE lessons are free to try. You can learn a formula’s name in seconds. Learning to select the correct range takes practice.
Before pressing Enter, check three things: the function name, the first and last cells in the range, and whether the task needs a fixed reference when a formula is copied. A neat answer in the wrong column is still the wrong answer.
Try this original mini Excel practice test
Open a blank spreadsheet and enter this small table. It is original training material, not a past examination question. Give yourself six minutes for the five tasks below, then review the output rather than merely looking at the formula bar.
| Row | A — Candidate | B — Marks | C — Status |
|---|---|---|---|
| 2 | Amira | 48 | Blank |
| 3 | Dev | 35 | Blank |
| 4 | Iqbal | 62 | Blank |
| 5 | Leena | 55 | Blank |
- Make row 1 a clear heading and format B2:B5 as numbers.
- In B6, calculate the total with
=SUM(B2:B5). The answer should be 200. - In B7, calculate the average with
=AVERAGE(B2:B5). The answer should be 50. - In C2, enter
=IF(B2>=40,"Pass","Review")and fill it down to C5. Dev should show “Review”; the other three should show “Pass”. - Sort the table by marks from highest to lowest, keeping each candidate with the correct mark and status. Save the completed file.
Check your work against the expected values. If the total is wrong, inspect the range before rewriting the entire sheet. If names and marks no longer match, undo the sort and select the full table. This is what an Excel practice sheet should teach: a repeatable repair method.
Turn Excel practice into exam readiness
- Learn one skill. Complete a short lesson on SUM, AVERAGE, references, sorting or formatting. Do the action yourself; watching a demonstration is the warm-up.
- Attempt a mixed task. Put two or three skills in one sheet. Exams rarely label the exact formula you should use.
- Take a timed mock. Work in the software and time limit closest to the assessment you will sit. Use a free Excel mock for the site’s five-part Clerk C.P.T. format.
- Review the missed step. Was the problem understanding the instruction, selecting a range, entering a formula or running out of time? Practise that point before opening the next mock.
A daily twenty-minute block is enough to make progress if it includes both an attempt and a review. Ten rushed worksheets with no review make an impressive stack, but they do not explain the same mistake appearing eleven times.
How the Punjab and Haryana High Court Clerk Excel pattern fits
The published S.S.S.C. Clerk C.P.T. criteria describe a ten-minute MS Excel practical with five parts worth two marks each and a qualifying mark of four out of ten. The English typing paper is a separate qualifying component. Our Clerk Excel mocks follow this five-task, ten-minute structure, and the High Court Clerk guide explains the paired typing test. Check the latest official recruitment notice for the rules and software version that apply to your examination.
Preparing for another Excel exam? Use the same formula and spreadsheet drills, then replace the Clerk time limit and pass line with your own official criteria. This page teaches the skills; it does not pretend that every exam shares one pattern.
Common questions about Excel tests
Can I practise Excel formulas online for free?
Yes. Start with the free SUM and AVERAGE lessons, then apply them in a small spreadsheet task. The first Clerk Excel mock is free to try.
Should I memorise Excel test questions and answers?
Understand the action behind an answer instead. A different cell range or sorting instruction changes the result, even when the question looks familiar.
Do I need advanced Excel for every exam?
No. Follow the official syllabus. Reliable basics usually come first; add lookup, conditional and other functions when they are relevant to your assessment.
Practise one sheet, then test yourself
Try the sample table, take a timed mock and return to the skill that cost you marks. That gives tomorrow’s practice a purpose.
HighCourtExam is an independent practice platform and is not affiliated with the Punjab and Haryana High Court or S.S.S.C. Consult the official notice for your own exam pattern and qualifying rules.