Excel Formulas for the High Court Clerk C.P.T.

How to practise these Excel formulas

After browsing the formula list, start with totals and averages, then practise conditions, text, dates and lookups in a workbook. Each lesson pairs a short explanation with a graded exercise. The exact questions in a future C.P.T. paper are not published in advance.

Choose the function that matches the task before entering a formula: SUM adds values, AVERAGE finds their mean, and COUNT counts numeric cells rather than adding them. For a condition such as “total only passing marks,” use a conditional function such as SUMIF. Check the cell range and whether it includes a header before you submit your answer. The practice sheet grades the formula you enter; reading a function name alone will not build the speed needed for a timed Excel practical.

A useful order for formula practice

Begin with the free SUM and AVERAGE lessons. In each worksheet, find the cells holding the raw numbers, identify where the result belongs, and read the task verb before choosing a function. A colon selects one continuous range, while separate arguments are listed with commas. Check whether a heading, blank row or earlier total sits beside your data so the formula does not include the wrong cells. Then move from totals and averages to counting, conditions, text, dates and lookup tasks as those skills become familiar.

When a formula gives an unexpected result, inspect the function, the selected range and the cell format separately. A correct calculation can look wrong when the destination cell uses an unsuitable format. If you copy a formula to another row, check whether its cell references should move or stay fixed. Practise the same skill again in a fresh worksheet, then use a timed Excel mock to see whether you can apply it under the ten-minute clock.