ICDL Advanced Spreadsheets exam-day guide
ICDL Advanced Spreadsheets · Prepare for the day ahead.
Your checklist
Photo ID
Bring the same government-issued photo ID you used at registration (passport or national ID card). Before test day, confirm with your approved test centre or ICDL provider which forms of ID they accept, because rules vary by country.
Appointment confirmation and candidate/ICDL ID number
Have your booking reference, test session time, and ICDL candidate number printed or saved offline. You may need them at reception to be admitted to the test.
Test centre location and arrival plan
Check the address, building entrance, floor, and parking or public transport options in advance. Confirm with the provider how early they want candidates to arrive; many centres ask for 15-30 minutes before the scheduled start.
Confirm the software version you will be tested on
ICDL Advanced Spreadsheets is normally assessed in a live spreadsheet application (commonly a recent Microsoft Excel version). Ask the centre which version is installed so your practice matches the ribbon and dialog boxes you will actually see.
Confirm whether your test is at a centre or remotely proctored
If remote, check the provider's requirements in advance: webcam, microphone, screen sharing, a quiet private room, a stable connection, and any software that must be installed or tested beforehand.
Nothing on your person except permitted items
Leave phones, smart watches, notes, printed formula sheets, and USB drives at home or in a locker. Ask the invigilator where to store personal belongings before you sit down.
Request any access arrangements early
Extra time, a separate room, screen magnification, or other adjustments usually must be requested and approved before the test date. Contact the centre as soon as possible if you need them.
Do one full timed practice attempt
Complete a practice set in one sitting, in the same application version, with no notes and no pausing. This trains pacing on multi-step tasks such as building pivot tables, writing lookup formulas, and applying conditional formatting.
Refresh the exact syntax you will type
Review argument order and punctuation for the functions you are most likely to use: VLOOKUP/INDEX-MATCH or XLOOKUP, IF with AND/OR, SUMIFS/COUNTIFS, ROUND, TEXT, and date functions. Check separator conventions in your version.
Know where key tools live
Practise locating Data > Sort and Filter, Data > Data Validation, Data > What-If Analysis, Insert > PivotTable, Insert > Chart, Home > Conditional Formatting, Formulas > Name Manager, and Review > Protect Sheet without hunting through menus.
Comfort items for a seated test
Glasses, a water bottle if the centre permits drinks at the desk, and a light layer in case the room is cold. Confirm the centre's policy on drinks and breaks beforehand.
Plan for a technical failure
Know what the invigilator expects you to do if the application freezes or the connection drops. Save your work often; do not attempt to fix system problems yourself.
Plan the day
Run one complete timed practice test under exam conditions and mark it honestly. Spend the remaining time only on your two or three weakest areas, such as pivot table grouping, nested IF logic, or what-if tools, rather than re-reading everything.
Re-check logistics: confirm the appointment time and address with the centre, confirm the software version and ID requirements, and confirm any access arrangements you requested have been approved.
Do a second, shorter practice session focused on speed. Practise completing small tasks end to end in under a few minutes each: applying a number format, creating a named range, sorting a multi-level list, and building a chart with a secondary axis.
Light review only. Skim a one-page list of function syntax and menu locations, then stop. Pack your ID, appointment confirmation, and travel details. Avoid learning brand-new topics the night before.
Protect your sleep and avoid a late-night cram. Fatigue costs more marks than a missed formula variant.
Eat, arrive at the centre with time to spare, and re-read only your short syntax list while you wait. Leave your phone and notes in the locker as instructed.
Read the instructions on the opening screen, check the clock and note the total test time, then take a few seconds to confirm the application opens the file or workbook the test expects.
Read each task completely before acting, because tasks often have more than one requirement. Do exactly what is asked and no more, since automatic marking checks specific cells, formulas, and settings.
Save frequently using the test's own save or submit mechanism, and watch the time. If a task stalls you, leave it, move on, and return to it if you have time left.
Use any review or navigation feature the test provides to check for unanswered tasks, verify that formulas return values rather than error codes, and confirm that charts and pivot tables are placed where the task asked.
Rules to check
Bring valid photo ID in the name used at registration; you may be refused entry without it. Confirm the accepted ID forms with the test centre in advance.
Phones, smart watches, notes, and any unauthorised materials must be switched off and stored away for the whole session. Keep them out of reach even during any break.
Follow the invigilator's instructions at all times. If equipment fails or a task appears broken, raise your hand and ask for technical help, but do not ask for content help on how to complete a task.
Work only within the test application. Opening other software, browser tabs, or files not provided by the test is normally treated as misconduct.
The test is scored automatically against the task requirements, and ICDL modules are commonly reported pass or fail against a set pass mark. Ask your centre what the pass mark and result turnaround are rather than assuming.
Break policy during the test varies by centre and by whether the test is centre-based or remote. Confirm with the provider before test day whether breaks are allowed and whether the clock stops.
Retake and re-sit rules, waiting periods, and fees are set by the centre or national operator. Confirm the exact policy with your provider before you sit the test.
If you need to reschedule, ask the centre about its notice period as early as possible; cancellation windows differ between providers.