PracticeVideosBlogFlashcardsEspañol
All Practice Exams

120+ Free ICDL Advanced Spreadsheets Practice Questions

Pass your ICDL Advanced Spreadsheets (ICS, Ireland) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
120+ Questions
100% Free

Loading practice questions...

Same family resources

Explore More ICDL Ireland (Irish Computer Society)

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

ICDL Data Analytics (ICS, Ireland)

Practice Questions

ICDL Coding Principles / Computing (ICS, Ireland)

Practice Questions

ICDL Computer & Online Essentials (ICS, Ireland)

Practice Questions

ICDL Digital Marketing (ICS, Ireland)

Practice Questions

ICDL Image Editing (ICS, Ireland)

Practice Questions

ICDL Cyber Security (ICS, Ireland)

Practice Questions
2026 Statistics

Key Facts: ICDL Advanced Spreadsheets Exam

20 tasks

Official ICDL Advanced Spreadsheets certification test length

ICDL Foundation Advanced module test specifications

60 minutes

Time allowed for ICDL Advanced module certification tests

ICDL Foundation Advanced module test specifications

75% pass mark

Candidates need 15 out of 20 tasks correct to pass

ICDL Foundation Advanced module test specifications

7 categories

Formatting; Formulas; Charts; Analysis; Validating; Productivity; Collaborative Editing

ICDL Advanced Spreadsheets Syllabus Version 3.0

Syllabus 3.0

Current Advanced Spreadsheets module syllabus on ICDL Global

ICDL Advanced Spreadsheets Syllabus 3.0 PDF

Pivot tables

Create, refresh, filter, group, and sort pivot tables per syllabus section 4.1

ICDL Advanced Spreadsheets Syllabus 3.0

Macros

Record, run, and assign simple macros to custom buttons per syllabus section 6.4

ICDL Advanced Spreadsheets Syllabus 3.0

100

Free original practice MCQs on OpenExamPrep across all Advanced syllabus categories

OpenExamPrep

ICDL Advanced Spreadsheets is an Irish ICS/ICDL Ireland Professional module testing pivot tables, scenarios, macros, advanced functions, and workbook security at Accredited Test Centres nationwide. The live exam has 20 tasks in 60 minutes; you need 75% (15/20) to pass. This free 100-question bank gives extra multiple-choice practice across all seven official Advanced syllabus categories.

Sample ICDL Advanced Spreadsheets Practice Questions

Try these sample questions to test your ICDL Advanced Spreadsheets exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 120+ question experience with AI tutoring.

1A Cork finance analyst highlights cells where expenses exceed budget using colour rules that update automatically when values change. Which syllabus feature is this?
A.Conditional formatting
B.Custom number formatting only
C.Split text to columns
D.Worksheet password protection
Explanation: ICDL Advanced Spreadsheets Syllabus 3.0 task 1.1.1 requires applying conditional formatting. Rules evaluate cell content and apply visual formats dynamically without manual re-colouring.
2You need invoice numbers to display as INV-00042 regardless of the underlying numeric value 42. Which formatting approach does the Advanced syllabus specify?
A.Create and apply a custom number format
B.Wrap text in the cell
C.Split the number across two columns with Text to Columns
D.Hide the formula bar
Explanation: Task 1.1.2 covers creating and applying custom number formats. A format code can add literal prefixes, padding zeros, and fixed text while preserving the numeric value for calculations.
3A CSV export lists "Dublin,Leinster,Ireland" in one column. Which command separates these into three columns in Excel?
A.Text to Columns
B.Paste Special Transpose
C.Scenario Manager
D.Trace Dependents
Explanation: Task 1.1.3 requires splitting text to columns. The Text to Columns wizard parses delimited or fixed-width text into adjacent columns for structured analysis.
4An ICS training workbook contains January sales on Sheet1 and February sales on Sheet2 in separate files. Which worksheet task moves February into the master workbook?
A.Copy or move worksheets between spreadsheets
B.Create a pivot table
C.Record a macro to change page orientation only
D.Apply advanced filter criteria
Explanation: Task 1.2.1 covers copying and moving worksheets between spreadsheets. This consolidates monthly data into one workbook while preserving sheet structure and formulas.
5You need to view rows 1–10 and rows 500–510 of the same worksheet at once, each with its own scroll bar. Which syllabus worksheet skill applies?
A.Split the window into panes
B.Hide rows 11–499
C.Create a pivot table
D.Apply conditional formatting
Explanation: Task 1.2.2 requires splitting a window and moving or removing split bars. Split panes display two or four independently scrollable sections of one worksheet; removing the split restores a single-pane view.
6A payroll officer must prevent colleagues from seeing draft salary columns during a presentation but keep the sheet in the file. Which action matches the syllabus?
A.Hide rows, columns, or worksheets
B.Delete the columns permanently
C.Convert the workbook to PDF only
D.Remove all cell comments
Explanation: Task 1.2.3 requires hiding and showing rows, columns, and worksheets. Hidden elements remain in the file but are not displayed until unhidden.
7A Galway SME wants staff to open a pre-built expense claim layout without overwriting the master file. Which file type should be saved?
A.Spreadsheet template (.xltx)
B.Comma-separated values (.csv)
C.Plain text (.txt)
D.Windows bitmap (.bmp)
Explanation: Task 1.2.4 covers saving a spreadsheet as a template and modifying templates. Templates open as new unsaved workbooks based on the stored layout.
8Conditional formatting rule: "Format cells that are greater than 1000 with red fill." If a cell changes from 900 to 1100, what happens?
A.The cell automatically receives red fill when the value crosses the threshold
B.The user must manually reapply the format each time
C.The rule only evaluates when the workbook is saved
D.The format applies permanently even if the value later drops below 1000
Explanation: Conditional formatting recalculates when cell values change. Rules based on cell content update display dynamically, which is why they suit live dashboards and exception reporting.
9A custom format code `#,##0.00 "EUR"` is applied to cell B2 containing 1234.5. How will Excel typically display it?
A.1,234.50 EUR
B.1234.5EUR with no separator
C.EUR 1,234 (no decimal places)
D.#,##0.00 EUR as literal text in the cell
Explanation: Custom formats use placeholders: # and 0 control digits, comma adds thousands separators, and text in quotes is literal. The underlying value remains numeric for formulas.
10When using Text to Columns on "First;Last;Email" with semicolon delimiters, where will "Email" appear?
A.In the third column to the right of the original cell
B.In the same cell appended to the original text
C.On a new worksheet automatically named Email
D.In the formula bar only
Explanation: Text to Columns places each parsed segment into consecutive columns on the same row. Three delimited parts occupy three adjacent columns starting at the source column.

About the ICDL Advanced Spreadsheets Exam

The ICDL Advanced Spreadsheets module certifies expert-level spreadsheet skills for producing sophisticated reports and complex calculations. Offered in Ireland through ICDL Accredited Test Centres administered by the Irish Computer Society, it covers advanced formatting, statistical and financial functions, pivot tables, scenarios, data validation, macros, external linking, and workbook security. The official certification test contains 20 performance-based tasks over 60 minutes with a pass mark of 75%, aligned to ICDL Advanced Spreadsheets Syllabus Version 3.0.

Assessment

Single ICDL Professional Advanced Spreadsheets certification test with 20 performance-based tasks over 60 minutes at an Accredited Test Centre, aligned to Syllabus Version 3.0.

Time Limit

60 minutes for the official Advanced module certification test.

Passing Score

75% — candidates must answer at least 15 out of 20 tasks correctly to pass, per ICDL Foundation Advanced module test specifications.

Exam Fee

Module test fees are set by individual ICDL Accredited Test Centres in Ireland; Advanced module pricing varies by centre. Contact your local ICS-accredited centre for the current module price. (Irish Computer Society (ICS) / ICDL Ireland, operating under the international ICDL Foundation digital skills certification programme)

ICDL Advanced Spreadsheets Exam Content Outline

14%

Formatting

Conditional formatting, custom number formats, text to columns, copy/move worksheets, split windows, hide/show, templates.

20%

Formulas and Functions

TODAY, NOW, DAY, AND, OR, SUMIF, COUNTIF, VLOOKUP, HLOOKUP, PMT, FV, DSUM, nested functions, 3-D and mixed references.

12%

Charts

Combined column-line charts, add/delete series, axis min/max/interval, display units, reposition legend and labels.

25%

Analysis

Create/modify/refresh pivot tables, grouping, one- and two-input data tables, multi-column sort, advanced filter, subtotals, scenarios.

10%

Validating and Auditing

Validation criteria and alerts, trace precedents/dependents, show formulas, insert and manage comments.

14%

Enhancing Productivity

Named ranges, paste special arithmetic and transpose, hyperlinks, update/break links, import text, record and run macros.

5%

Collaborative Editing

Compare and merge spreadsheets, password to open/modify, protect worksheet, hide formulas.

How to Pass the ICDL Advanced Spreadsheets Exam

What You Need to Know

  • Passing score: 75% — candidates must answer at least 15 out of 20 tasks correctly to pass, per ICDL Foundation Advanced module test specifications.
  • Assessment: Single ICDL Professional Advanced Spreadsheets certification test with 20 performance-based tasks over 60 minutes at an Accredited Test Centre, aligned to Syllabus Version 3.0.
  • Time limit: 60 minutes for the official Advanced module certification test.
  • Exam fee: Module test fees are set by individual ICDL Accredited Test Centres in Ireland; Advanced module pricing varies by centre. Contact your local ICS-accredited centre for the current module price.

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

ICDL Advanced Spreadsheets Study Tips from Top Performers

1Download the official Advanced Spreadsheets Syllabus 3.0 PDF and tick off each task item as you study.
2Build pivot tables from real sales data — practise refresh, grouping, and filtering until it is second nature.
3Create three named scenarios in a budget model and generate a scenario summary report.
4Record a simple macro for page setup and assign it to a button on the worksheet.
5Practise trace precedents and dependents on multi-sheet models with 3-D references.
6Take timed 60-minute practice sessions to simulate the official Advanced test pace.

Frequently Asked Questions

How many tasks are on the official ICDL Advanced Spreadsheets test in Ireland?

The Advanced certification test contains 20 performance-based tasks delivered in a 60-minute session at an ICDL Accredited Test Centre, per ICDL Foundation Advanced module specifications.

What score do I need to pass ICDL Advanced Spreadsheets?

The pass mark is 75%, which means at least 15 correct tasks out of 20, following ICDL Foundation Advanced module test specifications.

What is the difference between ICDL Spreadsheets and Advanced Spreadsheets?

Workforce Spreadsheets covers essential skills (basic formulas, charts, printing). Advanced Spreadsheets adds pivot tables, scenarios, macros, VLOOKUP, data validation, external linking, and workbook security per Syllabus 3.0.

Which syllabus version does this practice cover?

Questions are aligned to ICDL Advanced Spreadsheets Syllabus Version 3.0, the current Advanced module syllabus on ICDL Global with seven categories from Formatting through Collaborative Editing.

Are pivot tables and macros tested in ICDL Advanced Spreadsheets?

Yes. Syllabus section 4 covers pivot tables, data tables, sorting, filtering, and scenarios. Section 6.4 covers recording, running, and assigning simple macros to buttons.

Are these the official ICDL exam questions?

No. These are original OpenExamPrep multiple-choice items for extra drill. ICDL publishes separate Advanced sample tests on icdl.org; live certification tests use in-application performance tasks not fully replicated here.