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.1Edit the author properties to replace the text ' nsert here' with your examination number. (1\
1.2Modify the two colour gradient fill effect of the page colour as follows: Change the second colour to Green, Accent 6, ighter 60%
1.4Edit the table below the heading 'Savings' as follows: Change only the inside borders of the table to any dash line. Format the formula of the 'Total saving (R\ ' to currency with no decimal
1.5Find the multilevel list below the heading 'Places' and format the list to display as shown in the example below. NOTE: Use Webdings character code 118. (3\
1.6
Q2โ Section header โ
2.1Add the Integral built in footer style to the cover page only (2\
2.2Find and replace all the occurrences of the exact word 'nights' so that it is highlighted in a bright green colour. (3\
2.3Edit the Figure 2 image and the shape to display as shown in the example below. NOTE: Ensure that the image and shape move as one object. (4\
2.4Find the citation below the heading 'RECOMMENDATION' and add the text 'Recommended' to the omments bibliography field of the source. (1\
2.5
2.6Insert a table of figures below the heading 'Table of figures:' to display as shown in the example below. (4\
2.7Find the text form field controls below the heading 'Enquiries:' and modify the controls as follows:
2.7.1Edit the text form field next to the text 'Time of enquiry:' to display the time the form was opened for completion. (1\
2.7.2Change the length of the text form field below the text 'How can we help you?' to unlimited. (1\
2.7.3Modify the drop down form field below the text 'Tour name' so that 'European Highlights' appears as the last item in the list. (1\
2.7.4Travellers receive a discount of R100 per traveller. Insert a calculation in the text form field below the text 'Total amount' to automatically calculate the total amount payable. NOTE Use the bookmarks of the text form fields.
2.8Insert the text 'Enquiries' as a watermark on the last page only (3\ Save and close the 2Tours document. [26]26
Q3โ Section header โ
3.1Change the font of the heading in cell A1 to Arial and the font size to 24 pt. (2\
3.2Insert a function in cell G3 to calculate the most common maximum group size olumn of all the tours (1\
3.3Insert a formula in cell G5 to calculate the average length of all the tours olumn Round the answer to the next whole number.
3.4Insert a function in cell G7 to calculate the total cost of all the short break youth package
3.5Insert a suitable lookup function in cell H14 to determine the travel option for the 'Ultimate European' tour name based on the number of days.
3.6Modify the graph/c hart to display as shown in the example below. (5\ Save and close the
Q4โ Section header โ
4.1Delete the worksheet Sheet1 (1\ Work in the Reservations worksheet.
4.2Insert a function in cell G3 to calculate the second lowest cost per group olumn (2\
4.3Insert a function in cell G5 to determine how many plus packages olumn H were booked (2\
4.4Use a combination of text functions in cell E1 to create a traveller username for each traveller The traveller
4.5travel agent is required to pay a deposit of 60% if the cost per group is more than R150 000 otherwise the deposit remains the general deposit % found in cell Insert an IF function in column M to display the deposit.
4.6Modify the conditional formatting in column F to apply any yellow fill colour to the tours that will depart between January March in the Southern emisphere. 4Bookings
Q5โ Section header โ
5.1Open the tbl5_1 table in Design View and edit it as follows: NOTE: Select 'Yes' if a warning message appear.
5.1.1Change the field size of the EmployeeSurname field to 30. (1\
5.1.2Change the format of the DateOfBirth field to Short Date (1\
5.1.3Insert an input mask on the EmployeeID field in the following format: FOUR digits , followed by ONE @ symbol , followed by JobTitle
5.1.5New appointments will only be made if person has 5 to 10 years of experience in the travel industry. Insert a validation rule and validation text the YearsExperience
5.2Modify the frm5_2 form based on the tblStaff table in Design View as follows: Add the
5.3Open the query tblTravelClients tab in Design View. Display only the ClientName nline
5.4Open the based on the tblTravelClients table in Design View. Display the total cost per travel status. Save and close the
5.5Open the qry5_5 query based on the tblTravelClients table in Design View. Modify the query as follows: Display all the clients who have
5.6Modify the rpt5_6 report based on the tblTravelClients table in Design View to display as shown in the example below.
Q6โ Section header โ
6.1
6.1.1Add spacing of 10 between the cells of the table. (1\
6.1.2Centre the image in the top row of the table. (1\
6.1.3
6.1.4Insert the text from the 6_1Info file as the last cell of the table. (2\
6.1.5Create a link to the e mail address as shown at the bottom of the web page. (3\ Save and close the 6_1Travel file.
6.2Open the incomplete 6_2Experiences file in a web browser and also in a text/HTML editor (NOT a word processing program such as Word\. Complete the web page to appear as shown in the example below. Save and close the
Q7โ Section header โ
7.1Open the 7Discount database. The directors of the OneWorld Adventures want a report of the discount they provided. Create a report called Info
7.2Open the 7Refund spreadsheet. OneWorld Adventures will be closing some of their branches in Europe and Asia. ravellers will be eligible for a refund if: The tour confirmation indicates cancelled, AND The tour was scheduled to Europe OR Asia.