| ECDL | FETAC | |||
| 1 | Formatting | Adjust Column Widths | Y | Y |
| Font size/Type/Bold/Italic/Underline/Number styles/ | Y | Y | ||
| Currencies/Decimal Places/Thousands style(comma) | Y | Y | ||
| Alignments/Colours(Fill and Font) | Y | Y | ||
| Date formats/Numbers in % style/Merge and Centre | Y | Y | ||
| Text orientation (direction) | Y | N | ||
| Add borders | Y | N | ||
| 2 | Clearing Formats (Edit-Clear-Formats) | Y | Y | |
| 3 | Undo | Y | Y | |
| 4 | Use of +,-,/,* (Arithmetic operators) | Y | Y | |
| 5 | Copy formula: | Relative Cell Referencing | Y | Y |
| (Use of Fill Handle) | Absolute Cell Referencing | Y | Y | |
| 6 | SUM Function | Y | Y | |
| 7 | AVERAGE Function | Y | Y | |
| 8 | Add and Delete rows and columns | Y | Y | |
| 9 | Recalculate using formulas after adding rows/columns | Y | Y | |
| 10 | Sorting the spreadsheet | Y | Y | |
| 11 | Copying and Pasting | Y | Y | |
| 12 | Mouse Options: | Select cells/ Move cells/ Copy Formulas | Y | Y |
| 13 | Creating Charts and Chart Wizard options | Y | Y | |
| 14 | Selecting adjacent and non adjacent cells for creating charts | Y | Y | |
| 15 | Protection options | N | Y | |
| 16 | Hiding options | N | Y | |
| 17 | Freeze Panes | N | Y | |
| 18 | Split screen | N | Y | |
| Other Functions | ||||
| 19 | IF (with logical operators AND, OR, NOT) | N | Y | |
| 20 | A selection of | MAX/MIN/ABS/INT/ | ||
| these: | SQR(SQRT)/COUNT | Max/Min only | Y | |
| 21 | LOOKUP | N | Y | |
| 22 | DEPRECIATION | |||
| 23 | NPV | |||
| 24 | DATE/TIME | N | Y | |
| 25 | Show Formulas only | N | Y | |
| 26 | Set up options | Margins/Fit one page/ | Y | Y |
| Header&Footer/Portrait/Landscape | Y | Y | ||
| Print row/column identifiers | N | Y | ||
| 27 | Print a specified area of spreadsheet | N | Y | |
| 28 | MACROS (At least 5 commands) | N | Y | |
| ECDL only | ||||
| 29 | Copy and paste to move or duplicate cell | |||
| contents in another worksheet | Y | N | ||
| 30 | Search and replace | Y | N | |
| 31 | Import objects (image files/graphs/text files) and resize them | Y | N | |