ICDL Spreadsheets study materials
ICDL Spreadsheets study resources

ICDL Spreadsheets (ICDL) case studies

ICDL Spreadsheets · Put your knowledge to work in context.

ICDL Spreadsheets is one of the modules within ICDL CORE, the programme ICDL describes as "Core digital skills for employability and productivity." It certifies that a candidate can work confidently with spreadsheet software - opening and saving files, entering and editing data, building formulas and functions, applying formatting, producing charts and preparing sheets for printing or sharing. Because it is a core rather than a professional module, it suits students, job-seekers, public-sector employees and anyone who needs a recognised, vendor-neutral proof of everyday spreadsheet competence alongside word processing and other core skills. ICDL states that its certification is available in more than 100 countries through a network of more than 20,000 testing centres, so the module is delivered through accredited centres rather than as a single global online test. Preparation should be hands-on: work through each skill area in a real spreadsheet application, practising cell references, relative versus absolute addressing, common functions, number and conditional formatting, chart selection and print setup. The ICDL Spreadsheets case studies are 5 cases and about 1,495 words.

1

The Shared Budget Workbook That Doubles Its Totals

A treasurer maintains a monthly budget workbook. Column A holds 40 category names.

340 words, about 2 min
2

The Grade Sheet Where Averages Look Wrong

A teacher builds a class results sheet. Column A is student name, columns B–F are five test scores, column G is the average.

291 words, about 1 min
3

The Chart That Misrepresents the Sales Trend

A manager has quarterly sales: Q1 100, Q2 105, Q3 108, Q4 160. They insert a column chart, then set the vertical axis minimum to 90 (instead of 0) so the differences 'show up better'.

280 words, about 1 min
4

The Formula That Breaks When Copied Down

A clerk has unit prices in B2:B11 and quantities in C2:C11. In D2 they type =B2 C2 and copy it down to D11 - it works.

280 words, about 1 min
5

The Report That Must Print Cleanly

An analyst has a worksheet 60 rows long and 9 columns wide. They need to print it for a meeting.

304 words, about 2 min