Open the 7Lecture word processing document - NSC Computer Application Technology - Question 7 - 2018 - Paper 1
Question 7
Open the 7Lecture word processing document.
7.1.1 Follow the instruction in the comment in the document AND then remove the comment.
7.1.2 Reject all the track cha... show full transcript
Worked Solution & Example Answer:Open the 7Lecture word processing document - NSC Computer Application Technology - Question 7 - 2018 - Paper 1
Step 1
7.1.1 Follow the instruction in the comment in the document AND then remove the comment.
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 and locate the comment related to the heading 'Lecture on Impressionism'. Follow the provided instruction to apply WordArt. After applying the WordArt, remove the comment by right-clicking it and selecting 'Delete'.
Step 2
7.1.2 Reject all the track changes in the document.
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 the toolbar, click on 'Accept' in the Track Changes group, and select 'Accept All Changes in Document'. This will ensure that all the suggested changes are rejected.
Step 3
7.1.3 Invitations to the lecture must go out to guests.
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
Complete the mail merge using the 7Guests database as the data source for the 7Lecture mail merge document. Filter the recipient list to include only those with 'Painting' as an art form and who have painted more than 60 works. Ensure to replace '<<Name>>' with 'Name' and '<<Surname>>' with 'Surname' in the document.
Step 4
7.1.4 Complete the merge and save the merged document as 7LectureMerge.
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
After ensuring all changes and replacements are made, complete the merge process by choosing the 'Finish & Merge' option and selecting 'Edit Individual Documents'. Save this document as '7LectureMerge' and then close the document.
Step 5
7.2 Open the 7ArtForm spreadsheet.
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 7ArtForm spreadsheet and locate column A. Use the 'Text to Columns' feature from the Data tab, set the delimiter as a comma (';') to split the content of the column into multiple columns.
Step 6
7.3 Open the 7Summary spreadsheet.
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 the 7Summary spreadsheet, apply the SUBTOTAL function to determine the maximum number of artworks based on the artist's birth country. Use the MAX function to achieve this by selecting the relevant range of data.
