Many clerical recruitments include a spreadsheet task. You may be given a small table of data and asked to enter values, apply formatting, calculate totals or averages, sort and filter the table and perhaps draw a simple chart. The tasks are usually basic, but they are timed, and small slips such as a wrong cell reference can cost marks. This guide lists what to practise. Confirm the exact scope, software and marking in the official notification for your recruitment.

Original Excel efficiency sample data

Build this small table in a blank worksheet. These are learning exercises, not an official exam paper or an automatically scored test. Put Name, Theory, Practical and Total in A1, B1, C1 and D1 respectively.

  • Row 2: A2 = Asha, B2 = 42, C2 = 38. Leave D2 blank.
  • Row 3: A3 = Imran, B3 = 35, C3 = 41. Leave D3 blank.
  • Row 4: A4 = Neha, B4 = 46, C4 = 44. Leave D4 blank.

A. Calculate totals using formulas

Question: Calculate each student's total in D2:D4.

Answer: Select D2, enter =SUM(B2:C2) and press Enter. Select D2 again and drag its fill handle down to D4. The copied formulas should be =SUM(B3:C3) and =SUM(B4:C4). Expected totals are 80, 76 and 90. Check the formula bar: typing these numbers by hand does not demonstrate the formula skill.

B. Find the average and highest total

Question: Put the average total in D6 and the highest total in D7.

Answer: Select D6, enter =AVERAGE(D2:D4) and press Enter; the result is 82. Select D7 and enter =MAX(D2:D4); the result is 90. To show two decimal places, select D6:D7 > Home > Number > the dialog launcher > Number > Decimal places: 2. Regional settings can change how decimal separators appear.

C. Format the heading row

Question: Make A1:D1 bold and centre the header text.

Answer: Enter A1:D1 in the Name Box to the left of the formula bar and press Enter. Go to Home > Font > Bold, then Home > Alignment > Center. Use Center, not Merge & Center: the four headings must stay in separate cells.

Change one mark and confirm that the total and summary formulas update. Keep D6:D7 out of formulas intended to cover only the three student rows. This checks whether your references are correct rather than whether you memorised the answers.

Timed Excel practice in TypeSkill

Download TypeSkill for Windows for Excel efficiency practice with checking. Installed Microsoft Excel is required. The first three desktop tests per category are free without login; further tests require login and an active subscription. Daily live typing tests are a separate browser activity and do not edit Excel workbooks.

Continue with the Word questions and menu-path answers and the RSSB LDC preparation guide. Repeat the exercise with different marks and check every range before submitting.

Know the screen first

Candidates who lose time often simply cannot find things. Spend your first practice session learning the layout:

  • The name box, formula bar and cell grid.
  • Sheet tabs, and how to rename, add or delete a sheet.
  • The ribbon groups for fonts, alignment, number formats, styles and cells.
  • How to select a row, a column, a range and the entire sheet.

Data entry and number formats

Accurate data entry is half the battle.

  • Type numbers, text and dates in the cell formats the task shows.
  • Understand the difference between a number stored as text and a real number. Left-aligned numbers are often text.
  • Practise number formats: decimal places, thousand separators, currency, percentage and date.
  • Use fill handle and autofill to extend series quickly.

Formatting a table

  • Column width and row height, including autofit.
  • Borders, fill colour and font style.
  • Merge and centre, wrap text and alignment inside a cell.
  • Freezing panes and basic page setup for printing.

Basic formulas and functions

Every formula starts with an equals sign. For an efficiency test, a small set of functions covers most tasks:

  • SUM, AVERAGE, MIN, MAX for quick totals and statistics.
  • COUNT and COUNTA to count numbers or non-empty cells.
  • IF for simple conditions, such as marking "Pass" or "Fail".
  • Percentage and simple arithmetic, written as ordinary formulas.
  • Awareness of relative and absolute references. A reference such as $B$2 stays fixed when you copy the formula, while B2 moves. Mixing them up is a very common error.

Practise typing formulas by hand and by selecting ranges with the mouse. Then check the result with a quick mental estimate. If the total of ten numbers around 100 is 10,000, something is wrong.

Sorting, filtering and simple analysis

  • Sort a table by one column, ascending and descending.
  • Add a second sort level when the task asks for it.
  • Apply a filter and clear it again.
  • Use conditional formatting for a simple rule, for example highlighting values above a limit.

Charts

A basic chart is often enough: a column, bar, line or pie chart from a small range. Practise selecting the data, inserting the chart, adding a title and axis labels, and moving it to the right place.

A practice routine

Work in 45 minute sessions for two to three weeks.

  1. Build a small table of about 15 rows: names, marks, amounts or dates.
  2. Write ten instructions for yourself: format, calculate, sort, filter, chart.
  3. Do them against a timer, in order.
  4. Check each result. Click into formulas and make sure the range is correct.
  5. Save the file using the name and format you were told.

Change the data and the tasks each session so that you learn the skill, not the example.

Mistakes that cost marks

  • Wrong range in a formula, particularly when new rows are added.
  • Typing totals by hand instead of calculating them. Some examiners check for formulas.
  • Not reading the instruction about decimal places or the number format.
  • Sorting only one column and breaking the link between rows. Always select the whole table or a cell inside it.
  • Forgetting to save.

Pair it with typing practice

Spreadsheet data entry is typing too. Numeric keypad skills, covered in a lot of office jobs, help you enter figures quickly and accurately. Spend a few minutes of your daily practice on numbers, not only on words.

TypeSkill provides Excel efficiency practice items next to its typing tests so that you can try the full set in one place. Treat them as a timed check, and then build your own sheets for repetition. For the Word side of the sitting, read our Word efficiency preparation guide, and for the overall plan see the RSSB LDC typing test guide.