ICDL Spreadsheets (ICDL) case studies
ICDL Spreadsheets · Put your knowledge to work in context.
ICDL Spreadsheets is the spreadsheet component of ICDL, a modular digital-literacy certification delivered through Accredited Test Centres. This is an independent study page, not an official ICDL publication. ICDL describes itself as a global social enterprise committed to raising standards of digital competence in the workforce, education and society, and its certification is available through a worldwide network of testing centres. The spreadsheets module is aimed at candidates who need to demonstrate practical spreadsheet competence for study, employment, or professional development. Topics on this exam: Using the application, Cells, Managing worksheets, Formulas and functions, Formatting, Charts, and Prepare outputs. The ICDL Spreadsheets case studies are 5 cases and about 3,216 words.
1The forecast that will not recalculate
Your finance colleague emails you a file named Q1-forecast.xlsx. You open it and the formula bar is greyed out; a yellow bar reads PROTECTED VIEW and the sheet will not accept typing.
657 words, about 3 min2The export that sums to zero
A sales export pasted from a supplier portal fills A1:H4001. Column A holds Order ID, column F holds Amount showing 12,480.00 in every populated cell.
501 words, about 3 min3The invoice summary that reports nothing
An invoicing workbook has 320 order rows in 2:321. Column D holds the region exactly as typed ('North', 'South', 'East'), column F the order value pasted from a portal export, and column H the line total, H2 containing =F2 G2 filled down.
635 words, about 3 min4The year chart that lies
A workbook holds 24 months in A1:C25. Column A holds labels typed as text - 'Jan-24', 'Feb-24' and so on; column B is units sold; column C is revenue in dollars.
681 words, about 3 min5The fourteen-page pack that prints wrong
A 14-page monthly pack lives in one worksheet. The summary occupies A1:F40 and the detail table A42:H900.
742 words, about 4 min