IGCSE ICT Excel Spreadsheets Practical Exam Task - October/November 2017 | Paper 3 (0417) скачать в хорошем качестве

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