Open the 3Countries spreadsheet, which contains information about the services provided to people in the different countries, and work in the Services worksheet - NSC Computer Application Technology - Question 3 - 2021 - Paper 1
Question 3
Open the 3Countries spreadsheet, which contains information about the services provided to people in the different countries, and work in the Services worksheet.
3.... show full transcript
Worked Solution & Example Answer:Open the 3Countries spreadsheet, which contains information about the services provided to people in the different countries, and work in the Services worksheet - NSC Computer Application Technology - Question 3 - 2021 - Paper 1
Step 1
Change the border around cell C2 to a thick red border.
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
Select cell C2, then go to the 'Borders' option in the toolbar and choose 'Thick Border' and set the color to red.
Step 2
Insert a function in cell P9 to display the average number of outpatients (column C) treated.
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 P9, enter the formula =AVERAGE(C:C) and set the cell format to display no decimals.
Step 3
Insert a function in cell P11 to determine how many different kinds of services are available for use by the people in the DRC (row 20).
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 P11, use the formula =COUNT(C20:L20) to count the non-empty cells representing different services.
Step 4
Insert a function/formula in cell P13 to determine how many countries were first helped in the 1980s (column B).
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 P13, use =COUNTIF(B:B, "<=1989") - COUNTIF(B:B, ">=1990") to calculate the number of countries first helped in the 1980s.
Step 5
Apply data validation to cell range M5:M75.
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 range M5:M75, go to 'Data Validation', and set the criteria to 'List' with the options: Disastrous, Critical, Moderate.
Step 6
Insert a formula in cell P15 to calculate what percentage of people with DR-TB were treated by MSF in India (row 32).
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 P15, enter =H32/SUM(H:H) to find the percentage of people with DR-TB treated by MSF.
Step 7
How many spreadsheets are found in the 30Pen folder?
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
In cell P17, enter =COUNTA('30Pen'!A:A) to count the total spreadsheets in the 30Pen folder.
Step 8
Change the chart/graph to display as instructed.
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
Select the chart and filter the data to display only Outpatients.
Right-click on the data labels to change them to display names and percentages.
Set the doughnut explosion to 5% in the Format data series pane.
Move the chart to the worksheet named ServiceChart.
