3.1 Change the column width of column B to 40 pt and apply text wrapping to cells B8:B55 - NSC Computer Application Technology - Question 3 - 2022 - Paper 1
Question 3
3.1 Change the column width of column B to 40 pt and apply text wrapping to cells B8:B55.
3.2 Insert a function in cell C3 to display the average population (column... show full transcript
Worked Solution & Example Answer:3.1 Change the column width of column B to 40 pt and apply text wrapping to cells B8:B55 - NSC Computer Application Technology - Question 3 - 2022 - Paper 1
Step 1
3.1 Change the column width of column B to 40 pt and apply text wrapping to cells B8:B55.
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 change the column width of column B, navigate to the header of column B, right-click, and select 'Column Width'. Enter '40' and click 'OK'. To apply text wrapping, select cells B8:B55, go to the 'Home' tab, and click on 'Wrap Text' in the alignment section.
Step 2
3.2 Insert a function in cell C3 to display the average population (column E).
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
In cell C3, enter the formula: =AVERAGE(E8:E55) to calculate the average population from the specified range.
Step 3
3.3 Insert a function in cell C4 to display the number of islands where the word 'part' appears in the description of the Formation in column B.
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
In cell C4, use the formula: =COUNTIF(B8:B55, "*part*") to count the number of islands that contain the word 'part' in their description.
Step 4
3.4 Insert a SUMIFS function in cell C5 to display the total population (column E) for all oceanic type islands (column C) with an area larger than 1000 km² (column D).
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
In cell C5, enter the formula: =SUMIFS(E8:E55, C8:C55, "Oceanic", D8:D55, ">1000") to sum the population for oceanic islands with an area greater than 1000 km².
Step 5
3.5 Apply conditional formatting to Area (km²) (column D), using the 3 Flags icon sets as follows:
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
Select column D (D8:D55), go to the 'Home' tab and click on 'Conditional Formatting'. Choose 'Icon Sets' and select '3 Flags'. Then, set the conditions for Green (>= 280000), Orange (30001 to 279999), and Red (<= 30000) to apply the respective flags.
Step 6
3.6 Insert a formula in cell F9 to display the population per km² for the Bahamas.
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
In cell F9, use the formula =E9/D9 to calculate the population density for the Bahamas using the population in column E and the area in column D. Format the cell to show no decimal places.
