QUESTION 1: WORD PROCESSING                                                                                                                                                                                                  Theme: Walk 4 Paws 2021 Klipheuwel is organising a Fun Walk / Run event. The Microsoft Office Suite is being used to prepare the documents and files that will be needed. Open the document 1_InfoBrochure and format the information document as follows: 1.1 Change the page size to A4.    (1) 1.2 Locate the heading ‘Walk 4 Paws — Walk 4 Paws 2021’ at the top of the document. Change the font to Arial Black 16 pt. (2) 1.3 Locate the two images of the park and the walker on page 1 and adjust them to appear as follows: RIGHT CLICK ON BUTTON AND OPEN THE PICTURE-EXAMPLE IN A NEW TAB TO VIEW:     (3) 1.4 Locate the heading ‘Information Brochure’ on page 1. Change the style of the heading to the Heading 1 style.   (1) 1.5 Locate the paragraph under the heading ‘Information Brochure’ and do the following: Remove the hanging indent from the paragraph. Change the line spacing to 1.5. Replace the yellow highlighting with a light paragraph shading of your choice. Add a red paragraph border with a width of 2¼ pt. (7) 1.6 Locate the hyphen in the paragraph under the heading ‘Background’. Change the hyphen to an en dash. (1) 1.7 Locate the image and the first paragraph under the heading ‘Bring a Blanket.  Adjust the image and the flow of text around it to appear as follows: RIGHT CLICK ON BUTTON AND OPEN IN NEW TAB TO VIEW:   (2)  1.8 Locate the text “High for our … 4” high!’ under the heading  “Bring a Blanket“  and change it to appear as follows: High N for our Bring a Blanket thermometer which is already 4′ high!       Do the following: Insert the ‘high five’ symbol (Wingdings 2, character code 78) as shown. Replace the double smart quotation mark with a single straight quotation mark (3) 1.9 Locate the first paragraph under the heading ‘Health Benefits’ and do the following: Replace the dashed underline under the word ‘make’ with a double underline. Locate and correct the three spacing errors. (3) 1.10 Locate the table under the heading ‘Records to Break’ and change it to appear as follows: RIGHT CLICK ON BUTTON AND OPEN THE EXAMPLE IN A NEW TAB TO VIEW:   Note also the following: The height of the top row is exactly 0.8 cm. The 4th column is shaded the same colour as the top row. The outside border is thicker than the inside borders. (7) 1.11 Locate the table under the heading ‘Six Main Events’ and change it to appear as follows: RIGHT CLICK ON BUTTON AND OPEN THE EXAMPLE IN A NEW TAB TO VIEW:   Note the following: The direction of text in the 1st   column The alignment of text in the 2nd column The number of columns (3) 1.12 Locate the text ‘22 January 2021’ under the heading ‘Fees’. Replace the soft space between ‘22’ and ‘January’ with a hard space, to ensure that the entire date ‘22 January 2016’ will always appear on the same line. (1)   SAVE YOUR WORK AS 1_InfoBrochure Upload AND CONTINUE TO THE NEXT QUESTION. YOU WILL CONTINUE TO WORK ON THIS SAME FILE THAT YOU HAVE SAVED NOW.  

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..  

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 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.