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.1Style Island Types Title tyle applied
1.2Image rouping Five images grouped
1.4Drop Cap O of Oceanic ines to drop Distance from text: 1 cm
1.5Columns: island formation. Text placed in two columns Alignment: Justified Hyphenation applied
1.6Image inserted and formatted Image: 1Seychelles inserted Picture style: Soft Edge Oval Layout option: Through or Tight text wrap Position: Top left: 'calmness and
1.8Reference Manage Source Tarbuck City
1.9Edit Citation Author and Year displays (Only Title suppressed\ Pages: 130 140
1.10Find and Replace Find: Island Match case used Find: Island Find whole words Replace with: ymbol (Webdings, Char
Q1— Section header —
Q2— Section header —
2.5SmartArt graphics st level shape: Text inserted: Islands Font colour: White nd level shape:
2.6Field (Alt+F9\ { FILENAME * U pper * MERGEFORMAT }
2.7Page numbering Auto matic page numbering inserted in the footer No page numbering on the first two pages Page numbering starts with 1 on third page and continues Odd page numbers: Right aligned
Q3— Section header —
3.1Column B: Formatting Column Width: 40 pt Wrap ext
3.2Cell C3: =AVERAGE( 8: 55\ Function: AVERAGE Range:
3.3Cell C4: =COUNTIF(B8:B55,"*part*"\ Function: COUNTIF Range: B8:B55 Criteria: part (both wildcards\ (Expected answer: 10\
3.4Cell C5: SUMIFS(E8:E55,C8:C55,"Oceanic",D8:D 55," >1000" OR =SUMIFS(E8:E55, D8:D55,">1000"
3.5Column D: Conditional Formatting Icon s et 3 Flags Green flag icon: >=280 000 Orange
3.6Cell F9: =E9/D9 E9 D9 Formatted to zero decimal places
3.7Chart Density (in millions\ Digtheid (in miljoene data series graph type: olumn chart Primary axis display units:
Q3— Section header —
Q4— Section header —
4.1Background 4Logo inserted s background
4.2Gridlines Gridlines do not display
4.3Column B: =MID(A10,FIND(" ",A10\+1,LEN(A10\\ OR =MID(A10,FIND(" ",A10\+1,LEN(A10\ FIND(" ",A10\ OR =RIGHT(A10,LEN(A10\
4.4Cell 15 =VLOOKUP(F15,Cost!$A$3:$D$18,TravelIers!H15+1\ OR =VLOOKUP(F15,Cost!A1:D18,IF(Travellers!H15="1",2, IF(Travellers!H15="2",3,4\\ Function: VLOOKUP
4.5Subtotal feature (Mark by inspection\ At each change in: Travel Style Reisstyl Function: Max Subtotal added to: Group Cost
Q4— Section header —
Q5— Section header —
5.1.1Field: Name ield size set to
5.1.2Field: StartDate Validation Rule: >= # 15/03/2012# OR 14/03/2012# >=
5.1.3Field: AccessC ode Input Mask: LL @0009 OR LL"@"0009 LL
5.1.4Field: Position Display control: Combo box Row source type: Value list Row source: Manager; Administrator; Accountant
5.1.5Field: IDPhoto Field inserted IDPhoto Data type: OLE object OR Attachment
5.2Rectangle control added around the last four fields (Any\ Command button control added Button Action: Go to Next R ecord
5.3DestinationIsland field moved to be first field Totals option: Group By applied LeisureCost field function: Sum
5.4Query created based on: tblData Only Name, Surname, DateOfBirth and DestinationIsland fields displayed Sorted by Surn
5.5Calculated field 60&Older: Date(\ DateOfBirth /365.25
5.6Display Total LeisureCost field displays full values Calculation =AVG([
Q5— Section header —
Q6— Section header —
6.1.1Font <font face ="Tempus Sans ITC" size= Font a
6.1.2Horizontal line <hr color="black" size="5" /> OR <hr size="5" color="black" /> OR <hr size="5"
6.1.3Hyperlink <center> <a href="https://www.travelstar t.co.za/lp/birthday competition "> <img src="6_1Button.png"> </a>
6.1.4Heading <center> <h3>Fun things to do </h3> </center> Text inserted Fun things to do
6.1.5Ordered List <ol> <li> Visit Port Louis </li> <li>Try Deep Sea Fishing</li> <li> Head to Caudan Waterfront</li> <li>Shop at Chinatown</li>
6.2body> <center> <img src ="6_2Cocoa.jpg" width="250 "height="150"> <img src="6_2Fregate.jpg" width="250" height="150"> <img src="6_2Mustique.jpg" width="250" height="150">
Q6— Section header —
7.1.1Cell D2: Nested IF(AND =IF(AND(YEAR(B2\1960,C2="Mid Range"\, 5, IF(AND(YEAR(B2\1960,C2="Luxury"\,4,0\\ OR =IF((AND(YEAR(B2\1960,C2="Mid Range"\,"5",IF(AND
7.1.2Filter Filter option switched on Filter criteria: 1979 Filter sub criteria: January, February, March (3 records\
7.2Mail merge Recipients' list is filtered to: Travel Style = Luxury Merge field Name Naam Merge field