Gauteng Prelim 2020 - Q3 Excel

A step-by-step walkthrough of Question 3 - Excel. Paper and data can be downloaded here: https://bit.ly/3jXdR83. Please try the paper before you watch the video. Table of contents (only interactive on desktop/laptop): 00:00 - Introduction 00:23 - Question 3 01:08 - 3.1 Rename change colour of sheet 01:36 - 3.2 Formatting 02:18 - 3.3 Mode 03:05 - 3.4 Sum & conversion 05:06 - 3.5 Countif 08:02 - 3.6 Hlookup 11:45 - 3.7 Concatenate & Randbetween