What the C.P.T. tests

Both papers are qualifying · 10 minutes each · marks do not enter the merit list

XLPart I — MS Excel5 questions · 2 marks each · pass at 4/10125 graded questions

▦Formulas and functionsSUM, AVERAGE, MAX, MIN, COUNT, IF18 mocks

⚑Absolute and relative referencesFill down without moving the rate cell⚡ Most missed

AaFormattingCurrency, dates, column width, wrap text14 mocks

⇄Sorting and filteringSingle and multi-column sorts11 mocks

▤Printing and page setupPrint area, orientation, fit to one page4 mocks

Workbooks are Excel 2007 compatible, as the notice requires.

⌨Part II — English typing10 minutes · printed passage · 30 W.P.M. to pass60 passages

▦How the score is computed(words typed − mistakes) ÷ 1030.0

AaPassage materialJudgment extracts, bail orders, cause lists, noticesAll tiers

;What counts as a mistakeCapitalisation, punctuation, transposition, spacingNotice is silent

The passage is handed out on paper. Practice in exam mode does the same.