EXCEL ACTIVITIES
C O U N T I F A N D S U M I F
3Platfroms (Platform)
1.1 Insert a function in cell E6 to determine the total subscription fee (column D) for all the
'Netflix' (column C) users. (4)
3Airline
1.2 Insert a COUNTIFS function in cell D6 to determine how many movies 'James Gunn' has
directed with a 'Worldwide Box Office' (column H) of more than $1 000 000. (4)
3Projects
1.3 Use a COUNTIF function in cell F3 to determine how many projects have a budget greater
than R 55 000.00 (column F). (2)
3Touirists (Data)
1.4 The peak tourist season in Egypt is from October to May and the off-peak season is from
June to September.
Use the SUMIF function in cell C5 to determine the total number of tourists who visited
Egypt during the peak season (column B) in 2019 (column G). (3)
3Sales (2024)
1.5 Insert a COUNTIFS function in cell D5 to determine how many products have a delivery
shipment method with a total cost of R1 000 or more. (4)
3Budget (2024June)
Insert a SUMIFS function in cell E3 to determine the total food budget for all the
mammals that arrived after 2015. (5)
Page 1 of 3
C O N D I T I O N A L F O R M A T T I N G
3Projects
1.23 The data in column G incorrectly displays values for recycling air pollution.
Apply a spreadsheet feature to column G to fill the cells with a colour of your choice
whenever the targeted pollution (column C) is indicated as air pollution. (5)
3Tourists
1.24 Use a spreadsheet feature to apply a fill colour of your choice to the cell range C8:G19
when the number of tourists is lower than the average for the five years (2015 to 2019). (3)
4Costs
1.25 Apply a spreadsheet feature to column E to display a solid fill green data bar to the
cells. The higher the value the longer the bar should be. (3)
1.26 3Tourists 2022
Apply conditional formatting to cells F20:F31 to format the cells with a blue fill colour
when the amount for shopping in a particular month in 2021 is greater than the amount
for shopping in the same month in 2020. (4)
N e s t e d I F
1.27 4Costs
A country only qualified for a discount if the country participated in 100 or more events
(column F) AND had more than 10 000 athletes (column G).
Insert a nested IF function in cell J5 to display 'Yes' if the country qualified for a discount
or 'No' if the country did not qualify for a discount.
Copy the function down to the other cells. (6)
3Tourists
1.28 The totals in column H should calculate the total number of tourists per month from
2015 to 2019; however, this does not happen as expected for all the months.
Insert a formula in cell I8 to display the text 'Correct' if the total in column H
corresponds with the total number of tourists from 2015 to 2019, or else the text 'Error'
must display.
Copy the formula down to the other cells. (7)
4Sightings
1.29 Game drives are classified as follows:
(6)
Page 2 of 3
Insert a nested IF function in cell D7 to classify the game drive time using the time in
cell E7 and the time of day in cells J1:O3.
Page 3 of 3
