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

00:00​ Place automated file name and path in the header
00:27 Import CSV file to Excel
01:00 VLOOKUP function for resort name
01:43 VLOOKUP function for location
02:16 Nested IF to calculate advertising costs
03:55 SUMIF function to calculate number of rooms by location
04:48 Print showing formulas *
05:33 Print values

* To display row and column headings click page setup - sheet and you will find a checkbox for it.

(NOTE: Steps 13-17 have been omitted from this video to focus on the formulas and functions)

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

💻 SOFTWARE
Spreadsheets - Microsoft Excel