Open the 4Air spreadsheet and work in the Quality worksheet - NSC Computer Application Technology - Question 4 - 2021 - Paper 1
Question 4
Open the 4Air spreadsheet and work in the Quality worksheet.
4.1 Insert a function in cell D3 to determine the second smallest air quality index (AQI) count per yea... show full transcript
Worked Solution & Example Answer:Open the 4Air spreadsheet and work in the Quality worksheet - NSC Computer Application Technology - Question 4 - 2021 - Paper 1
Step 1
Insert a function in cell D3 to determine the second smallest air quality index (AQI) count per year (column E).
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To find the second smallest AQI count in column E, use the formula:
=SMALL(E7:E153, 2)
This will return the second smallest value from the specified range.
Step 2
Add the option 'Urban' to the existing data validation rule in cell B7 using the list in cells J7:J8.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To add 'Urban' to the existing data validation in cell B7, go to the Data Validation settings and update the source to include 'Urban' along with the existing values from J7:J8.
Step 3
Insert a combination of text functions in cell G7 to display the number of exclamation marks (!) using the AQI level in column F and the data in cell D4.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To determine the risk rating based on AQI levels in column F, the following combination of text functions can be used:
=REPT("!", ROUNDUP(F7/10, 0))
This formula generates exclamation marks based on the AQI level.
Step 4
Set the print area to cells A6:H40.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To set the print area in Excel, go to the Page Layout tab, click on 'Print Area', and then select 'Set Print Area'. Highlight cells A6:H40 to define this as the print area.
Step 5
Use a SUMIFS function in cell H2 and the data in the Quality worksheet to determine the health incidents of all the measuring stations in the Eastern Cape in 2018.
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Use the following SUMIFS function to calculate the total health incidents for the Eastern Cape in 2018:
