IGCSE ICT Excel Spreadsheets Practical Exam Task - October/November 2017 | Paper 3 (0417)

00:00 Step 1 - Import CSV files
00:47 Step 1 - Edit Header & Footer
01:31 Step 2 - Merge cells E2 to F2
02:12 Step 3 - Merge cells A1 to H1
02:32 Step 4 - VLOOKUP Destination (B4)
03:04 Step 5 - Average number of visitors a month (F4)
03:17 Step 6 - Percentage change visitors 2014-15
03:37 Step 7 - Replicate formulae steps 4-6
03:51 Step 8 - Apply appropriate formatting
04:10 Step 9 - Save and print formulae
04:46 Step 10 - Print showing values
05:32 Step 11 - Update data and print values
06:41 Step 12 - Total visitors
06:48 Step 13 - Average visitors
06:56 Step 14 - Maximum visitors
07:07 Step 15 - Copy value B4 & replicate
07:33 Step 15 - Most popular destination (VLOOKUP)
07:59 Step 16 - Labels
08:33 Save and print selection of formulae & values
10:04 Filter (3 months) and print extract

ℹ️ TASK INFORMATION
Subject: IGCSE Information and Communication Technology 0417
Provided by: Cambridge Assessment International Education
Session: October/November 2017
Component: Practical Paper 03

💻 SOFTWARE
Spreadsheets - Microsoft Excel
Evidence document - Microsoft Word