Maak die 4Excursions-sigblad op wat besonderhede oor 'n vakansieprogram bevat waar skoolgroepe in Desember 2023 die diereitun besoek het - NSC Computer Application Technology - Question 4 - 2024 - Paper 1
Question 4
Maak die 4Excursions-sigblad op wat besonderhede oor 'n vakansieprogram bevat waar skoolgroepe in Desember 2023 die diereitun besoek het.
4.1 Skuif ('Move') die Tri... show full transcript
Worked Solution & Example Answer:Maak die 4Excursions-sigblad op wat besonderhede oor 'n vakansieprogram bevat waar skoolgroepe in Desember 2023 die diereitun besoek het - NSC Computer Application Technology - Question 4 - 2024 - Paper 1
Step 1
Skuif ('Move') die Trip-werkblad sodat dit voor die Q4_6-werkblad verskyn.
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 Excel, right-click on the tab of the Trip worksheet and select 'Move or Copy...'. From the dialog box, choose to move it before the 'Q4_6' worksheet and click OK.
Step 2
Voeg 'n funksie in sel C3 om te bepaal hoeveel skole uit die Oos-Kaap ('EC') die diereitun gedurende Desember besoek het.
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
Use the formula =COUNTIF(E7:E153, "EC") in cell C3. This function counts the number of occurrences of 'EC' within the specified range.
Step 3
Voeg 'n funksie in sel G3 in om die datum te bepaal waarop die skole die diereitun die meeste besoek het ('most frequent date').
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 G3, use the formula =MODE(H7:H153) to calculate the most frequently occurring date that the schools visited.
Step 4
Voeg 'n kombinasie van funksies in sel D7 om die kontaknommers in die volgende formaat te vertoon.
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 D7, use the formula =CONCATENATE("+27", RIGHT(C7,9)) to format the contact numbers correctly, ensuring that they are displayed in the International format.
Step 5
Voeg 'n funksie in sel F13 om die afgeronde getal te bereken: G13/30.
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 F13, enter the formula =ROUNDUP(G13/30, 0), which will round up the result of G13 divided by 30.
Step 6
Kolom H: Datavalidering (Data Validation).
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
Apply data validation for column H by setting the start date criterion to '2023/12/01' and link it to the relevant cell reference (H30) in the Q4_6-worksheet.
Step 7
Voeg 'n funksie in sel I12: =IF(OR(DAY(H12)=16),"Badge","")
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 I12, use the function =IF(OR(DAY(H12)=16), "Badge", "") to check if the day of H12 is the 16th, and return 'Badge' if true.
