ICT - IGCSE

Spreadsheets

To open Adobe .pdf files install Adobe Acrobat Reader. To watch Help movies or take quizzes/tests install Adobe Flash Player. To open spreadsheet files install Microsoft Office or Open Office (free).

If you see all data in one column, with many commas, when you open a .CSV file in Excel like this (example) please follow the following instructions (for Windows XP) or instructions (for Windows 7/8) to fix it. To print to Adobe .pdf install doPDF.

Spreadsheets Practical Demonstration:

• Spreadsheets Demonstration
  • TREES.CSV
  • CODE.CSV
• Spreadsheet Skills
• Spreadsheet Demo Mark Scheme

Spreadsheets Tests:

To print to Adobe .pdf install CutePDF.

• a (Lookup Function / Entering Data) - Demo steps 1 - 3 (?Help, ?Help, ?Help & ?Help)
• b (Countif Function) - Demo step 6 (?Help & ?Help)
• c (Simple Formulae) - Demo step 14 (?Help)
• d (Whole) - Demo step 15 (?Help)
• e (Complex Formulae) - Demo step 16 (?Help)
• f (IF Function) - Demo steps 3, 4, 12 , 13 & 17 (?Help, ?Help, ?Help & ?Help)
• g (SumIf) - Demo step 18 (?Help)
• h (Format) - Demo steps 3, 5, 9, 10 & 19 (?Help, ?Help & ?Help)
• i (Interrogation) - Demo steps 26 - 29 (?Help, ?Help, ?Help, ?Help & ?Help)

Spreadsheets Practical Full Test

Spreadsheet Theory:

To take quizzes/tests you will need to install Adobe Flash Player.

• Spreadsheet Quiz

Spreadsheets Theory Test