The school hosted a water games event to raise funds - NSC Computer Application Technology - Question 4 - 2017 - Paper 1
Question 4
The school hosted a water games event to raise funds.
NOTE:
- Use formulae and/or functions for ALL calculations in the spreadsheet.
- Use absolute cell references... show full transcript
Worked Solution & Example Answer:The school hosted a water games event to raise funds - NSC Computer Application Technology - Question 4 - 2017 - Paper 1
Step 1
4.1 Remove the hyperlink set on the heading 'Water Games'.
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 remove the hyperlink from the heading 'Water Games', right-click on the cell containing the hyperlink, select 'Remove Hyperlink' from the context menu.
Step 2
4.2 Insert a formula in cell E3 to determine the number of weeks that have passed between the date in column D and the current date.
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 E3, enter the formula:
=INT((TODAY()-D3)/7)
This calculates the number of weeks since the date in column D.
Step 3
4.3 Remove the value 'Black' as an option in the validation list for the whole column.
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 remove 'Black' from the validation options in column G, select the entire column, go to Data > Data Validation, edit the list, and exclude 'Black'.
Step 4
4.4 A participant ID should be created for each participant. Create the participant ID in cell I3 as follows.
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 I3, input the following formula:
=LEFT(C3,2)&" "&RANDBETWEEN(0,99)&LOWER(F3)
This formula takes the first two letters of the surname, adds a space, a random number between 0 and 99, and the gender in lowercase.
Step 5
4.5 Use an appropriate LOOKUP function in cell J3 to display the award that Jemima Garrison will receive based on her score in cell H3.
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
In cell J3, use the following formula:
=HLOOKUP(H3,Awards_Toekenning!$A$1:$E$3,2,FALSE)
This formula looks up the score in cell H3 and retrieves the corresponding award from the Awards_Toekenning worksheet.
