NOTE:
Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 3 - 2017 - Paper 1
Question 3
NOTE:
Use formulae and/or functions for ALL calculations in the spreadsheet.
Use absolute cell references ONLY where it is required by the question to ensure that fo... show full transcript
Worked Solution & Example Answer:NOTE:
Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 3 - 2017 - Paper 1
Step 1
3.1 Use a function in cell D4 to convert the population in cell C4 to a number.
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 convert the population from text to a number in cell D4, use the formula:
=VALUE(C4)
Step 2
3.2 Correct the function in cell E89 to remove the circular reference.
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
Correct the function in cell E89 by changing the reference as follows:
=SUM(E4:E88)
Step 3
3.3 Use a function in cell F89 to determine the seventh largest number of visitors arriving in 2016 (column F).
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 find the seventh largest number of visitors in column F, use:
=LARGE(F4:F88, 7)
Step 4
3.4 A code is needed for the city of Ananindeua in cell G4 by combining the last three letters of the city (column A), the number of characters in the name of the state (column B), and a random integer between 100 and 200.
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 G4, create the code by using:
=RIGHT(A4, 3) & LEN(B4) & RANDBETWEEN(100, 200)
Step 5
3.5 Apply a spreadsheet feature to display all the states (column B) that appear only once on the list in a red font colour.
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 conditional formatting on the range B4:B88. Set the rule to format cells with unique values and change the font color to red.
Step 6
3.6 Add a hyperlink in cell C2 in the Summary_Opsom worksheet to link to cell F4 in the Visit_Besoek worksheet.
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
To create the hyperlink, use:
=HYPERLINK("#Visit_Besoek!F4", "Link to F4")
Step 7
3.7 Create a graph/chart using the data in the Summary_Opsom worksheet.
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 the data range.
Insert a chart and set the chart title to 'Visitors'.
Display the 'Total' series as a line graph.
Use the '3Brazil' picture as the plot area background.
Apply pattern fill to the 'National' data series.
Remove gridlines and position the legend to the left.
