Author: Anonymous

Question 3 – Spreadsheet The owners of The Tiger Canyon are…

Question 3 – Spreadsheet The owners of The Tiger Canyon are very interested in other wild animals as well. Open the 3Statistics_Statistieke spreadsheet and continue working in the Animals Hunted_Diere Gejag worksheet that summarises the hunting of wild animals in South Africa over five years. 3.1 Use a spreadsheet feature to remove the drop-down list from cell E4. (1) 3.2 Format the headings in row 3 to appear in the cells as shown in the screenshot: Right-click on this button and select the “Open link in new tab” option (1) 3.3 Format the cells in column K to display the top 3 in the range to a green fill with a dark green text. (2) 3.4 The animal types are stored in column A. Use the FIND function in cell Q18 to determine at which position the ‘i’ in the word ‘tiger’ in cell A18 appears. (3) 3.5 Use a function in cell K29 to calculate the total number of animals, more than 100, that were hunted in column K. (3) 3.6 Calculate the number of animals hunted that appear the most in cell K31. (2) 3.7 Format row 3 of the spreadsheet so that the top row will be visible while scrolling through the rest of the worksheet. (1) 3.8 Use a LOOKUP function in cell M4, and the data in the Table_Tabel worksheet, to display the availibility of the different wild. Make sure that this function can be copied down to cell M26 (6) 3.9 Calculate in cell K33 the % of tigers that were hunted over five years in comparison to the total amount of animals hunted. Round the function down to 2 decimals (4) 3.10 Calculate in cell K35 the highest total number of animals that were hunted in all provinces. (2) 3.11 A code is used to identify the different animals. The animal code is made up with the letters ‘WA’ that appears in cell B29, in lower case, followed by the first three letters of the name of the animal in column A, followed by the last two letters of the name of the animal in column A Example: The code for ‘Aardwolf’ would be waaarlf. Insert a function/formula in cell N5 to determine the code for ‘African Wild Cat’. (7) 3.12 The chart in the ‘Chart_Grafiek’ worksheet displays the number of animals hunted over five years in the different provinces. Format the chart so that it is displayed as in the example below:   Right-click on this button and select the “Open link in new tab” option   Change the chart type so that the chart is displayed as in the screenshot above. Change the colour of the pyramids in the chart so that each pyramid is displayed in a different colour. Minor tick marks must be displayed on the vertical axis of the chart. The title of the vertical axis of the chart must be displayed as shown in the screenshot. The ‘Chart_Grafiek’ worksheet must appear as the second worksheet in the spreadsheet.   Right-click on this button and select the “Open link in new tab” option   (1) (1) (1) (1) (1) 3.13 Continue working in the ‘Table_Tabel’ worksheet and create a hyperlink on the image of the animal to link with cell A24, in the ‘Animals Hunted_Diere Gejag’ worksheet. Ensure that a screen tip, ‘Dodos are extinct’, is displayed. (4) Save and close the 3Statistics_Statistieke spreadsheet. [41]

5.13 Open the Tigers_Tiere report and make the following ch…

5.13 Open the Tigers_Tiere report and make the following changes:   5.13.1 Remove the field named Gender_Geslag from the report. (1) 5.13.2 Group the report according to the Country_Land field. (1) 5.13.3 Remove the image saved as AnimalLove_Diereliefde which serves as the background of the report (1) 5.13.4 Insert a function in the report to calculate the total number of visitors (adults plus children) per country. Also supply a suitable label for the calculation (4) 5.13.5 Format the image in the report header to zoom. (1) 5.13.6 Insert a hyperlink in the report to link to the Visitors_Besoekers table. (1) 5.13.7 Insert page numbers in the page N of M format in the page footer of the report. The first page of the report should not be numbered. (3) Save and close the Tigers_Tiere report. Save and close the 5Guests_Gaste database [40]

  Maak die Tigers_Tiere-verslag oop en verander as volg:…

  Maak die Tigers_Tiere-verslag oop en verander as volg: 5.13.1  Verwyder die veld genoem Gender_Geslag uit die verslag. (1) 5.13.2  Groepeer die verslag volgens die Country_Land-veld. (1) 5.13.3  Verwyder die prentjie gestoor as AnimalLove_Diereliefde wat as die agtergrond vir die verslag dien. (1) 5.13.4  Voeg ‘n funksie in die verslag in om die totale aantal besoekers (volwassenes plus kinders) per land te bereken. Verskaf ook ‘n geskikte etiket (‘label’) vir hierdie berekening. (4) 5.13.5  Formateer die prentjie in die verslag kopskrif (‘report header’) na ‘zoom’. (1) 5.13.6  Voeg ‘n hiperskakel in die verslag om te koppel (‘link’) met die Visitors_Besoekers-tabel. (1) 5.13.7  Voeg bladsynommers in die ‘page N of M’-formaat in die bladsyvoetskrif (‘page footer’) van die verslag in. Die eerste bladsy van die verslag moet nie genommer wees nie. (3)   Stoor en maak die Tigers_Tiere-verslag toe.        [39] Stoor en maak die 5Guests_Gaste-databasis toe. Laai jou gestoorde weergawe van 5Guests_Gaste.accdb onder Vraag 5.2 in die OPLAAI Quiz op (GEEN PDF / .laccdb LêERS NIE)

Question 2 – Word processing Carli created an electronic for…

Question 2 – Word processing Carli created an electronic form for guests to make bookings Open the 2Bookings_Besprekings document. 2.1 Remove the watermark that appears in the document. (1) 2.2 Group the two images on the first page of the document (1) 2.3 Find all occurrences of the words ‘Tiger Canyon’ and replace them with the words ‘The Tigers Canyon’, highlighted in a yellow colour. (2) 2.4 Locate the bulleted list on page 1 of the document. Right-click on this button and select the “Open link in new tab” option Format the bulleted list as follows: Change the bullets to the Webdings symbol (character code 228).  Align the bullets at 0.5 cm from the left margin. Set the distance between the bullets and the text at 0.5 cm. (1) (1) (1) 2.5 Locate the word ‘distinctly’ in the first paragraph of the text. Use a Word Processor feature and replace this word with a suitable synonym. (1) 2.6 Locate the table on the second page of the document. Insert a caption below the table. The caption must read Table 1: Tariffs. (2) 2.7 Continue working in the third row of the table. 2.7.1 Edit the drop-down field in the second column of the third row as follows: Remove the option R970. Add help text ‘Tariff’ to the control. 2.7.2 Work in the last row of the table. Change the text form field in this row to the current date format. (1) (1) (1) 2.8 Go to the ‘Book now!’ section on the last page of the document. Change the options under the heading ‘Book now!’ to resemble the example below: Right-click on this button and select the “Open link in new tab” option **NOTE: Set AND apply a 6cm hyphenated leader tab, as shown above, to ALL options. (3) 2.9 A table of sources has been created for this document. Insert an automatic bibliography below the heading ‘Bibliography’. (1) Save and close the 2Bookings_Besprekings document. [17]

OM JOU LêERS OP TE LAAI: Maak seker dat die lêers waaraan j…

OM JOU LêERS OP TE LAAI: Maak seker dat die lêers waaraan jy gewerk het gestoor is op jou rekenaar Maak WORD, EXCEL, ACCESS en NOTEPAD++ toe Al jou lêers moet opgelaai word in die OPLAAI quiz wat volg na hierdie quiz. Sodra jy heeltmal klaar is met jou vraestel, klik die “SUBMIT QUIZ” knoppie regs onder Om dan na die OPLAAI Quiz te navigeer moet jy die “NEXT” knoppie klik (regs-onder) en jy het 15 minute om die lêers waaraan jy gewerk het op te laai Let asb: GEEN .PDF of /.laccdb lêers nie.