This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.
Q1โ Section header โ
1.1ore information should be added to the cover page. Complete the cover page as follows
1.1.1 Insert your examination number under the heading uthor in the text
1.1.2 Add the 1Climate_Klimaat picture found in the examination folder in the picture control.
1.1.3Apply the Global style to the title 10 Most Common Effects of Global Warming
1.2Adjust the quote One of the most controversial topics in today s age is g lobal warming
1.3Locate the text global warming in the first paragraph of the document and pply any text outline to th
1.4Apply automat ic numbering to the heading Rising Sea Levels (1\
1.5Locate the paragraph that starts with and ends with low lying coast al
1.6Add a bookmark called Heat to the heading 2. Heat Waves
1.7Locate the image below the heading 3. Killer Storms Apply a 3.5 pt border around the image. Add a shadow effect of your choice. (3\
1.8Locate the image below the heading 8. Wars Mark the image with an index entry called
1.9Replace all occurrences of the character with the word and
1.10Locate the page on which the heading 10. Ecosystem Failure appears.
1.10.1Place ONLY this page, including the heading and content in landscape orientation. (1\
1.10.2The shape with the text Soil has not been added to the grouped image. Add the shape to the rest of the group of shapes on this page. (1\
1.11Locate the text on the second last page that starts with and ends with
1.12Locate the image on the second last page under the heading 'Preventive Measures '. Adjust it so that it displays similar to the example below.
1.13Insert an automatically generated index on the last page, so that the index displays similar to the example below. Use the following format options for the index: Use o ne column
1.14Add automatic page numbering as follows: Add the page numbers centred in the page footer. Start the page numbering with 'i' (Roman numeral 1\ on the table of contents page. Use the number
Q2โ Section header โ
2.1Set th e left and right indent ation of the entire document to 3 cm.
2.2Apply a drop cap effect to the heading Nature is Crying, You Should Know as follows: The drop cap
2.3Add an endnote to the heading Nature is Crying, You Should Know as follows: Use the
2.4Change the line spacing of the entire document to ultiple
2.5Centre the text and the image in the document horizontally and vertically on the page. (2\
2.6Add a hyperlink to the picture at the bottom of the page It must l ink with the website
2.7Change the page colour to any colour of your choice. (1\
2.8Add the current date in the page footer. The date should automatically update each time the document is opened. Save and close the
Q3โ Section header โ
3.1ormat the worksheet as follows:
3.1.1Change the background colour of cell A1 to any colour of your choice. (1\
3.1.2Merge cells A1:J1 (1\
3.1.3Rotate the headings of row 2 by 90 degrees. (1\
3.1.4Change the colour of ONLY the bottom border of cells A2:J2 to red. (2\
3.2Use a data format to display all the negative numbers in ells 7:C32 in red and with
3.3Use conditional formatting in column D to display the cell with the HIGHEST value AND the cell with the LOWEST
3.4Use a combination of function to extract the temperature in degrees Fahrenheit ( 131
3.5he following formula is used t o convert degrees Celsius to degrees Fahrenheit:
3.6Use a function/formula i cell G to determine the number of full days that have passed since
3.7Change the page setup as follows: Set the range 32 as the print area.
4.6Create a pie chart in cell O2 to display the severity threat rate per total species
4.7Import the data from the 4Imp file n the examination folder into the
5.1Edit the Survey_Opname table as follows:
5.1.1Change the field size of the Type field to 10.
5.1.2There are currently two primary keys set on the table. Remove the primary key that is not suitable so that only ONE suitable primary key remains
5.1.3Create an input mask on the ID field to ensure that the user enters code as follows: Five compulsory capital letters
5.1.4The Protected field does not display the Yes and No
5.1.5Create a new lookup field called FullStatus Use the data in the Name field
5.2Create a form called frm5_2 based on the Survey_Opname tabl e as follows: Include all the fields of
5.3Open the qry5_ query. Display only the bird and plant types that are protected
5.4Open the qry5_ query. Add the fields SName Status and
5.5Research indicat es that the population of each species will decrease by 1% every year. Open the qry5_5 query Display only the records where a value for the common name ( CName
5.6Create a report called rep5_6 based on the Survey_Opname table The report must display information using a layout similar
Q6โ Section header โ
6.1Correct the HTML tags to isplay the text Save the Elephant in the browser
6.2Add HTML ta to display the 6Eleph_Olif .jpg image
6.3Format the text SAVE THE ELEPHANT with the font Elephant
6.4Increase the font size of the text FROM THE KIDS ANIMAL PROTECTION by 1. (2\
6.5Add a horizontal line with the following properties below the body tag as indicated in the file: Set the line colour to a yellow colour Set the line size to 4
6.6Add a row with the text Asian Elephant to the table The table should appear as follows:
6.7Format the text Physical description with a H eading 2 style
6.8Display the text Proboscidea in italics. (1\
6.9Apply numbering to the text under the heading Threats to lephants
6.10Insert a link on the words Save the Elephant that links to the document 6Save_Red .docx found
Q7โ Section header โ
7.1Locate the text on the first page that starts with What is Global Warming and ends with
7.2Locate the following text on the second last page: Snow Goose Chen caerulescens Canada Goose Branta canadensis Trumpeter Swan Cygnus buccinator Wood Duck Aix sponsa
7.3Insert a text watermark that display the text Birds
7.4Locate the text Figure 1: Comparison of bird species for 2000 and 2014 Use any method to c reate a chart /graph below this text
7.5
7.5.1How many records are there in the database? NOTE No explanation is required. (1\
7.5.2How many birds have not yet been allocated an English name? (2\
7.5.3To which family does the Pardusco (English name\ belong (2\
7.5.4How many birds with an English name containing the word Macaw are there
7.5.5How many unique families are there in the database? (2\ Save and close the 7Answ_Antw document. [19] TOTAL:19