Die skool wil 'n musikconcert in die gemeenskap bevorder - NSC Computer Application Technology - Question 7 - 2016 - Paper 1
Question 7
Die skool wil 'n musikconcert in die gemeenskap bevorder.
7.1 Maak die 7Form_Vorm-dokument oop.
Verander die kommentaarnkenmerk ('comments property') van die dokume... show full transcript
Worked Solution & Example Answer:Die skool wil 'n musikconcert in die gemeenskap bevorder - NSC Computer Application Technology - Question 7 - 2016 - Paper 1
Step 1
Maak die 7Form_Vorm-dokument oop.
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
Open the 7Form_Vorm document.
Step 2
Verander die kommentaarnkenmerk ('comments property') van die dokument na 'CAT Exam'.
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
Change the comments property of the document to 'CAT Exam'.
Step 3
Voeg 'n toepaslike vormveldkontrole ('form field control') langs die teks 'Name' in, om 'n gebruik te stel en sy/haar naam in te vul.
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
Insert a suitable form field control next to the 'Name' text to allow users to input their name.
Step 4
Redigeer die vormveldkontrole ('form field control') langs die teks 'Surname' om die van in hoofletters 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
Edit the form field control next to 'Surname' to display entries in uppercase letters.
Step 5
Vind die teks 'The top selling ...'.
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
Locate the text 'The top selling ...' in the document.
Step 6
Voeg 'n afkruisvormveldkontrole ('drop-down form field control') in die ruimte wat voorsien is, om die volgende DRIE opsies in te sluit:
Beatles
Elvis Presley
The Beach Boys.
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
Add a drop-down form field control in the designated area with the options: Beatles, Elvis Presley, The Beach Boys.
Step 7
Stoor en maak die 7Form_Vorm-dokument oop. Moet NIE die vorm sluit voor dit gestoor word NIE.
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
Save and keep the 7Form_Vorm document open without closing it.
Step 8
Maak die 7Compt_Kompet-dokument oop. Voltooi 'n possamevoeging ('mail merge') soos volg:
Gebruik die Learners_Leerders-werkblad in die 7Data-sigblad as die databasis vir die possamevoeging.
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
Open the 7Compt_Kompet document. Complete a mail merge using the Learners_Leerders worksheet in the 7Data worksheet as the database.
Step 9
Voeg 'n velde 'Name_Naam' en 'DOB Geboortedatum'-saamvoeging in die pos as gevolg daarvan in die leë sál.
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
Include the fields 'Name_Naam' and 'DOB Geboortedatum' in the mail merge in the designated area.
Step 10
Voltooi die possamevoeging en stoor her 7Data. MOET NIE DRUK NIE.
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
Complete the mail merge and save the 7Data document. Do not print.
Step 11
Maak die 7Sixties_Sestigs-databasiss oop.
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
Open the 7Sixties_Sestigs database.
Step 12
Bied enige metode om hierdie data in dollar-geldeheid gekoop?
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
Provide any method to report this data in dollar currency.
Step 13
Hoeveel beleggers het die munt in enige dollar-geldeheid gekoop?
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
Count the investors who purchased the coin in any dollar currency, which totals 77.
Step 14
Metode:
Filter op CoinFaceValue: Kriteria: Bevat '$'
OF Filter op CoinCurrency: Kriteria: Bevat 'Dollar'
=COUNTIF(M2:M101,"Dollar")
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 a filter on CoinFaceValue for criteria containing '$' or filter on CoinCurrency for criteria containing 'Dollar'. Use the COUNTIF function.
Step 15
Hoeveel langtermynbeleggers het 'n begindatum in September?
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
Count the long-term investors who have a start date in September, which totals to 3.
Step 16
Metode:
Filter op InvestmentTerm: 'Long' EN Filter op StartDate: Datums in periode: 'September'.
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
Apply a filter for InvestmentTerm as 'Long' and for StartDate as any date in September.
Step 17
Wat is die naam van die gewilde munt wat verskyn?
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
The name of the popular coin that appears is either 'Maple Leaf' or 'Eagle'.