VRAAG 3: SIGBLAD
LET WEL:
Gebruik formules en/of funksies vir ALLE berekeninge in die sigblad - NSC Computer Application Technology - Question 3 - 2023 - Paper 1
Question 3
VRAAG 3: SIGBLAD
LET WEL:
Gebruik formules en/of funksies vir ALLE berekeninge in die sigblad.
Gebruik absolute selfverwysings SLEGS waar nodig om seker te maak dat... show full transcript
Worked Solution & Example Answer:VRAAG 3: SIGBLAD
LET WEL:
Gebruik formules en/of funksies vir ALLE berekeninge in die sigblad - NSC Computer Application Technology - Question 3 - 2023 - Paper 1
Step 1
3.1 Vee ('delete') Sheet3 uit die werkboek.
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 workbook where 'Sheet3' is located. Right-click on 'Sheet3' tab and select 'Delete'.
Step 2
3.2 Stel die drukarea ('print area') op selle A12:E62.
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 cells A12 to E62. Then, navigate to the 'Page Layout' tab and click on 'Print Area'. Choose 'Set Print Area' from the dropdown.
Step 3
3.3 Voeg die teks 'Marathon Logo' as die Alt Text van die prent in sel A3 in.
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
Click on the image in cell A3. Right-click and select 'Format Picture'. Go to the 'Alt Text' section and enter 'Marathon Logo' as the title.
Step 4
3.4 Voeg 'n funksie in sel F5 in om die gemiddelde kwalifiserings tyd vas te stel.
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 F5, input the formula: =AVERAGE(I13:I62) to calculate the average qualifying time from the dataset in the specified range.
Step 5
3.5 Die afstand van die wedloop is in sel F3 geregistreer. Vir elke voltoide 5 km vanaf die beginpunt van die wedloop sal 'n meesdente punt op die roete geplaas word.
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 F3, input the total race distance. Use the formula =ROUNDOWN(F3/5, 0) to determine the number of completed 5 km segments.
Step 6
3.6 Elk van die 50 atlete sal 'n spesifieke inskrywingsnommer ontvang. Genereer 'in skrywingsnommer' in sel B20 vir die atleet, Kuda, soos volg.
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 B20, use the formula: =RANDBETWEEN(1,50) to assign a random registration number between 1 and 50 for the athlete Kuda.
Step 7
VOEG JY die 'LOOKUP-funksie' in sel J17 in om die inskrywingsnommer van atlete te bekom.
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 J17, input the formula: =LOOKUP(F17, Band!$A$1:$B$6, 2) to find the registration number associated with the given athlete's data.
