YOU HAVE NOW COMPLETED THIS PAPER. CLICK ON THE SUBMIT BUTTON. A NEW QUIZ WILL OPEN WHERE YOU MUST UPLOAD THE 4 FILES YOU HAVE SAVED.   PLEASE GO TO THE EXAM CONNECT BUTTON ON THE FRONT PAGE DURING THE EXAM IF YOU EXPERIENCE ANY PROBLEMS WITH YOUR PAPER OR UPLOADING YOUR FILES.

  CONTINUE TO WORK ON THE FILE YOUR HAVE SAVED JUST NOW AS 1_InfoBrochure_Upload   1.13 Locate the table under the heading ‘Walk / Run Basics’ and do the following: Change the text ‘H2O’ to appear as ‘H2O’. Sort the walk / run tips by the number of votes, in descending order. Change the Word formula in the bottom right cell to show the total number of votes, without decimal places.   (6) 1.14 Locate the two paragraphs in blue text under the heading ‘Registration and Starting Times’ and do the following: Join the two paragraphs into a single paragraph. Copy the heading ‘Registration and Starting Times’ and all the text in blue to a new document. Save the new document as a plain text file in your exam folder with the name Instructions.txt. (4) 1.15 CONTINUE WORKING ON THE FILE  1_InfoBrochure_Upload Locate the five lines of text in green under the heading ‘Awards Function’. Format the text as in the following screenshot (without the border), by following the instructions below it: RIGHT CLICK ON BUTTON AND OPEN IN NEW TAB TO VIEW:   Do the following: Format the four lines as a bulleted list. Use the Symbol Character Code 197 as bullet points. Align the bullets against the left margin.   (3) 1.16 Locate the bulleted list under the heading ‘Sequence of Events’. Change the list to display 5 items as follows (without the border): RIGHT CLICK ON BUTTON AND OPEN THE EXAMPLE IN A NEW TAB TO VIEW:   (3)  1.17 Locate the two shapes under the heading ‘First Aid’ and adjust them to be displayed as follows and group the shapes so that the whole graphic acts as a single unit.:   (2)  1.18 Locate the text in blue under the heading ‘Key Personnel’ and format it to appear as shown below: RIGHT CLICK ON BUTTON AND OPEN THE EXAMPLE IN A NEW TAB TO VIEW:   (2)  1.19  Locate the text ‘Date: Tuesday, 31 05 2016’ under the heading ‘Closing’. Remove the italics. Change the format of the date field, so that the date is displayed as Tuesday, 31 May 2016. (2)  1.20 Insert the file name of this document as a field in the page header, against the right margin. (4)  1.21 Replace all occurrences of the word ‘gathering’ with the word ‘function’.  Format all the replaced words in red. (3)  1.22 Insert automatic page numbering in the footer in the following format:      (3)  1.23 Locate the heading ‘Appendix: Route Map’ on the last page of the document. Use a page break to ensure that this heading appears at the top of a new page. Copy the image of a map, found at the button below, and paste it under the heading ‘Appendix: Route Map’. RIGHT CLICK ON BUTTON AND OPEN IN NEW TAB TO VIEW:   (3)  1.24 Perform a spell check on the document, and correct all spelling mistakes. (2)   Save your rile as 1_InfoBrochure_Upload. You will submit your file in the next quiz after completing and submitting this paper.  

Question 1 – Word Processing Text file   Upload your saved version of Instructions.txt here (NO PDF FILES)

Question 1 – Word ProcessingUpload your saved version of 1_InfoBrochure_Upload.docx here (NO PDF FILES)

Additional answer upload space – only use in an emergency.

Question 1 – Word ProcessingUpload your saved version of 1_InfoBrochure_Upload.docx here (NO PDF FILES)

QUESTION 2: WORD PROCESSING    2.1 Open the document file 2_Signup. Remove the page colour. (1) 2.2 Set the top margin to 2 cm. (1) 2.3 Locate the heading ‘Walk 4 Paws 2021 – Entry Form’ at the top of the document. Format the heading with a Small caps font effect. Change the paragraph ‘After’ spacing of the heading to 12 pt. (2) 2.4 Change the drop cap in the first paragraph to appear as follows:   The distance of the drop cap from the text is 0.15 cm. (3) 2.5 Locate the sentence starting ‘The closing date…’ in the first paragraph. Place the sentence on a new line in the same paragraph.     (1) 2.6 Locate the text in blue and use an appropriate word processing technique to format it to appear as shown below: (This is not a clickable link):   (2) 2.7 Locate the paragraph ‘IMPORTANT: All entry fees … in lieu of a receipt’ and format it to appear as follows:   Also do the following: Expand the character spacing of the word ‘IMPORTANT’ by 2 pt. Set the right indentation of the paragraph to 1 cm. (3) 2.8 Locate the text in green. Use tab settings at 2 cm, 8.5 cm and 15 cm to display the text as shown below.   (4) 2.9 Locate the SmartArt diagram and adjust it to appear as follows:   (2) 2.10 Locate the text ‘Cut here’ under the SmartArt diagram. Use an existing tab setting to add a dotted line that extends to the right margin as follows:    Adjust this tab to 8.2cm alignment right. (2) 2.11 Add a watermark containing the text ‘Example’ as shown below. (Note that only the watermark on the page is shown, not the other page content.)       (3)   Save your file as 2_Signup_Upload. You will submit your file in the next quiz after completing and submitting this paper..  

  QUESTION 3: SPREADSHEET                                                                                                                                                                Open the spreadsheet file 3_Entries. 3.1 Change the width of column A so that all the surnames are fully visible.   (1) 3.2 Change the height of the second row to 35.   (1) 3.3 Hide column F (Classification).   (1) 3.4 Format cells A1:F2 so that they are displayed as follows:   (5) 3.5 The cellphone number of JB Visser in cell E3 is displayed without the leading zero. Make the necessary correction.    (1) 3.6 The amount owed by each participant is the Basic Fee (column I) plus the cost of a Goody Bag (column J). The Outstanding Amount (column L) is calculated by subtracting the Amount Paid (column K) from the amount owed. Insert a formula in cell L4 to calculate the Outstanding Amount for LT Dempers. Copy the formula down to calculate the outstanding amounts for all the other participants.     (4) 3.7 Insert a function in cell D18 to calculate the total amount paid by all the participants. Display the answer in Rand format. (3) 3.8 Use functions to determine the following age statistics at the bottom of the spreadsheet: 3.8.1       Cell K20:    The age of the youngest competitor.            3.8.2       Cell K21:    The average age of the competitors. Format the answer as a number without decimal places.                                          (5) 3.9 A businessman has agreed to donate R5 to the SPCA for every kilometre completed by each competitor.  The distance to be completed by each competitor is stored in column H  Insert a function in cell D20 to calculate the total amount of the donation, assuming that every competitor completes the full distance of his / her event (3) 3.10 Format the date in cell D23 to be displayed in the format 31 May 16.            Please note: Do not change the date function in this cell. (1) Save your file as 3_Entries_Upload. You will submit your file in the next quiz after completing and submitting this paper.  

YOUE HAVE NOW COMPLETED THIS PAPER. CLICK ON THE SUBMIT BUTTON. A NEW QUIZ WILL OPEN WHERE YOU MUST UPLOAD THE 4 FILES YOU HAVE SAVED.   PLEASE GO TO THE EXAM CONNECT BUTTON ON THE FRONT PAGE DURING THE EXAM IF YOU EXPERIENCE ANY PROBLEMS WITH YOUR PAPER OR UPLOADING YOUR FILES.

QUESTION 2: WORD PROCESSING    2.1 Open the document file 2_Signup. Remove the page colour. (1) 2.2 Set the top margin to 2 cm. (1) 2.3 Locate the heading ‘Walk 4 Paws 2021 – Entry Form’ at the top of the document. Format the heading with a Small caps font effect. Change the paragraph ‘After’ spacing of the heading to 12 pt. (2) 2.4 Change the drop cap in the first paragraph to appear as follows:   The distance of the drop cap from the text is 0.15 cm. (3) 2.5 Locate the sentence starting ‘The closing date…’ in the first paragraph. Place the sentence on a new line in the same paragraph.     (1) 2.6 Locate the text in blue and use an appropriate word processing technique to format it to appear as shown below: (This is not a clickable link):   (2) 2.7 Locate the paragraph ‘IMPORTANT: All entry fees … in lieu of a receipt’ and format it to appear as follows:   Also do the following: Expand the character spacing of the word ‘IMPORTANT’ by 2 pt. Set the right indentation of the paragraph to 1 cm. (3) 2.8 Locate the text in green. Use tab settings at 2 cm, 8.5 cm and 15 cm to display the text as shown below.   (4) 2.9 Locate the SmartArt diagram and adjust it to appear as follows:   (2) 2.10 Locate the text ‘Cut here’ under the SmartArt diagram. Use an existing tab setting to add a dotted line that extends to the right margin as follows:    Adjust this tab to 8.2cm alignment right. (2) 2.11 Add a watermark containing the text ‘Example’ as shown below. (Note that only the watermark on the page is shown, not the other page content.)       (3)   Save your file as 2_Signup_Upload. You will submit your file in the next quiz after completing and submitting this paper..