ICDL Spreadsheets (ICDL) study plan

Enter formulas using cell references and the arithmetic operators + - * / and ^

Distinguish relative, absolute, and mixed references, and convert one to another by editing the reference

Build a multi-sheet formula that pulls a value from another worksheet

Apply the order of operations correctly and use parentheses to force evaluation order

Write SUM, AVERAGE, MIN, MAX, and COUNT over contiguous and non-contiguous ranges

Use IF with a logical test and both a true and false result

Select, copy, and move cell ranges using keyboard and mouse, including non-adjacent selections

Fill a formula down and across a range and verify each copied reference adjusted as intended

Insert and delete rows and columns without breaking existing formulas

Adjust column widths and row heights to a specified size and to auto-fit

Open, save, and save-as a workbook in the required file format, and switch between open workbooks

Use the undo and redo tools to recover from an editing mistake

Apply number formats for currency, percentage, and fixed decimal places

Format cells with bold, italic, borders, shading, and text alignment

Copy formatting between ranges using the format painter or paste-special formats

Clear contents versus clear formatting and explain the difference in a note

Insert, rename, reorder, and delete worksheets within a workbook

Group or reference across multiple worksheets to total values by category

Use named ranges in at least two formulas

Apply a function such as COUNTIF or ROUND and verify its result against a manual check

Create a column or bar chart from a selected data range and label the chart title and axes

Change the chart type and reposition it on the sheet

Add or remove a data series and adjust the source range

Format chart elements such as legend position and data labels

Set print orientation, margins, and scaling to fit the sheet on one page

Define and repeat print titles and set a print area

Insert headers and footers with page numbers and the file name

Preview a worksheet before printing and correct any split columns

Complete a timed full-length practice set covering all seven domains

Review every missed item and redo the underlying task until correct

Consolidate a personal checklist of the shortcuts and functions you still hesitate on

Finalize a clean, formatted, print-ready workbook that combines formulas, charts, and output settings