7.1 Maak die 7Lecture-woordverwerkingsdokument oop - NSC Computer Application Technology - Question 7 - 2018 - Paper 1
Question 7
7.1 Maak die 7Lecture-woordverwerkingsdokument oop.
Volg die instruksie in die kommentaar ('comment') in die dokument EN verwyder dan die kommentaar.
7.1.2 Verwyde... show full transcript
Worked Solution & Example Answer:7.1 Maak die 7Lecture-woordverwerkingsdokument oop - NSC Computer Application Technology - Question 7 - 2018 - Paper 1
Step 1
Maak die 7Lecture-woordverwerkingsdokument 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 document titled '7Lecture' in your word processing software. Follow the instructions specified in the comment provided in the document. After understanding the comments, delete them as instructed.
Step 2
Verwyder ('Reject') al die veranderingsspore ('track changes') in die dokument.
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
Go to the 'Review' tab in your word processing software and utilize the 'Reject' option to remove all changes tracked in the document. Ensure that any comments or tracked changes are fully cleared to finalize the document.
Step 3
Uitnodigings na die lesing moet aan die gaste gestuur word.
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
Conduct a mail merge using the guest data from the '7Guests' database. Ensure that only the relevant recipients for the lecture are selected, and replace the placeholder fields such as <Name> and <Surname> with the actual data from your source.
Step 4
Maak die 7ArtForm-sigblad oop.
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
Open the '7ArtForm' spreadsheet. Utilize the 'Text to Columns' feature found under the 'Data' tab to split the data in column A into multiple columns based on the delimiter ':' (colon). Ensure that the text is reorganized accordingly.
Step 5
Maak die 7Summary-sigblad 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 '7Summary' spreadsheet. Use the SUBTOTAL function to determine the highest number of artworks classified by the artist based on their birth dates. Store and finalize the results.
Step 6
Maak die 7Timeline-sigblad oop.
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
Sort the artist data in alphabetical order and arrange the years chronologically from earliest to latest. Next, in column D, implement formulas to perform the following tests:
Test 1: Check if the artist in the current row for the current year matches the one in the previous row.
Test 2: Check if the artist had a piece in the previous year, verifying that the difference in the year is 1.
If both tests return TRUE, indicate with 'True'; otherwise, indicate with 'False'.
