Maak die 7CapeTown-woordverwerkingsdokument op - NSC Computer Application Technology - Question 7 - 2023 - Paper 1
Question 7
Maak die 7CapeTown-woordverwerkingsdokument op.
1. Verander die binneneame ('inside borders') van die tabel na enige blou kleur.
2. Pas die opskrifry ('heading row... show full transcript
Worked Solution & Example Answer:Maak die 7CapeTown-woordverwerkingsdokument op - NSC Computer Application Technology - Question 7 - 2023 - Paper 1
Step 1
1.1 Verander die binneneame ('inside borders') van die tabel na enige blou kleur.
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 die 7CapeTown-dokument, selecteer die tabel en verander die binneneame kleur na 'blou'.
Step 2
1.2 Pas die opskrifry ('heading row') van die tabel aan om te vertoon soos hieronder getoon.
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
Herorganiseer die kolom opskrifte soos volg:
Tourist Name
Tourist Surname
2020/2021
2022/2023
Points
Step 3
1.3 Voeg 'n formule in om die punte vir Allan Nel soos volg te bereken:
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
Gebruik die volgende formule om die punte vir Allan Nel te bereken:
=IF(SUM(LEFT(C6,1))=6,1000,500)
Hierdie formule bied 1 000 punte indien die totale besoeke groter as 5 is, ander slegs 500.
Step 4
2.1 Pas 'n sigbladdeienskap op kolom A toe om die teks in kolomme te rangskik.
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
gebruik die funksie 'Convert Text to Columns' vir kolom A om die data te skei op 'n spesifieke karakter of spasie.
Step 5
Vind en vervang ('Find and replace') al die voorkomste van die woord 'Maybe' met die woord 'No'.
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
Gebruik die 'Find and Replace' funksie om alle instances van 'Maybe' met 'No' te vervang.
Step 6
2.2 Funksie: YEAR(TODAY()), MONTH(C2)-1, DAY(C2).
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
Gebruik die volgende formule in sel D2 om die huidige jaar se verjaardag datum te bereken:
