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.1Small caps: Extract from Report Font: mall caps
1.2Text Effect (inside shape\ KWAZULU NATAL Text Fill: Gradient fill ype: Rectangular
1.3Style AND Indentation (Showcasting style\ Paragraph i ndentation: Left set as
1.5cm
1.4Citatio (Department of Statistics South Africa\ Citation in rd paragraph
1.5SmartArt SmartArt: Circle Relationship Level 1: Tourism Text 'Tourism': 14 pt Level 2: Employment, Transport, Food Note to marker: Accept if SmartArt graphic appears below
Q1โ Section header โ
1.6Find: 'tourism' Match case + Find whole words only Format: Highlight Accept any colour
1.7Columns AND Page Orientation: PUBLIC RELATIONS effects of the pandemic. Required text in 2 c olumns
Q2โ Section header โ
2.1Drop Cap: Position: Dropped (Not n margin
0.5cm
2.2Paragraph bo rder Please share via the number of shares
2.3Hyperlink: Win! Win! Win! Hyperlink inserted to: https://go afari .co .za/
2.4.1 Form Control: Age field Form control: Drop down form field /Combo/List box content control Options: <35
2.4.2Form Control: Cell Number field Type: Regular ext Maximum length: 1 (Accept values
2.4.3Form Control: Extra entries field Type: Calculation Expression: =Share *2 Alt+F9: FORMTEXT
2.5Table anipulation /Text to table Table appears (3 rows 3 columns\
2.6Signature L ine feature Signature ine feature applied
Q2โ Section header โ
3.1Cell A : Format Format of cell A1 9 applied to cell A
3.2Cells A4 to G4: Vertically Centred and Border lines /Column Width Vertically Centred Thick
3.3Cell B18: =ROUNDUP((B17/100000\*8,0\ OR =ROUNDUP((SUM(B5:B16\/100000\*8,0\ ROUNDUP B17 OR SUM(B5:B16\ /100000
3.4Cell G5: =IF(COUNT( B5 F5 \=5,SUM( B5 F5
3.5Cells F20:F31: Conditional Formatting This orksheet dit ule
3.6Chart/Graph Data series for 2021: Series Value: Data!$C$20:$C$31 Data series for 2020: Series Name: 2020 Legend: below Axis: Number format : 'Use 1000 Separator'
Q4โ Section header โ
4.1Cell 3: MAX(G7:G 105\ OR =LARGE(G7:G105,1\ Function:
4.2Cell D4 =SUMIFS(G7:G105,C7:C105,"Mpila Camp",H7:H105, "TRUE"\ OR =SUMIFS(G7:G105,H7:H105,"TRUE",C7:C105,"Mpila Camp"\ Sum range: G7:G105 Criteria range 1: C
4.3Cell A7: =VLOOKUP(B 7,Rangers!$B$2:$E $22,3\ Lookup value: B7 Table array: Rangers!$B$2:$E $22 OR
4.4Cell D7: Nested IF function modification =IF(E7<$O$2,"Morning",IF(E7>=$O$3,"Night", "Afternoon"\\ OR =IF(E7>=$O$3,"Night",IF(E7<$O$2,"Morning", "Afternoon"\\ OR =IF(E7>=$O$3,"Night",IF(E7>=$O$2,"Afternoon",
4.5Cell F 7: =E7+TIME(2,45,0\ OR =TIME(HOUR( 7\+2,MINUTE( 7\+45,
Q5โ Section header โ
5.1.1Field: Surname Required Yes
5.1.2Field: MemberNo (Input Mask\ 00000 "@tv l"
5.1.3Field: TravelDate Format: Medium Date Show Date Picker: Never
5.1.4Field: Accommodation (Lookup\ Row Source Type Table/Query
5.1.5Field: IDCopy Field ID Copy inserted Position: Below Surname field
5.2Image Logo inserted in the form header Image size : 9 cm wide x 4 cm high Date field:
5.3Transport criteria: Taxi OR Private BookingAgent criteria: EasyStay GroupSize criteria: >
5.4BookingAgent Total Group By Cost: Total: SUM Query: qry5_5
5.5Calculated field: DOB : [ ar ] & Left([ ID ],6\
5.6Fields displayed: Surname Name GroupSize Accommodation and
Q5โ Section header โ
Q6โ Section header โ
6.1.1Body tag: Text attribute <body text=" lue" </body> Attribute:
6.1.2Heading 2 tags: Did you know? <h2> Did you know? </h2> Heading 2 tags inserted
6.1.3Bold tags he Dolphin Coast year
6.1.4Link tags </p>For more information e mail: <a href = mailto:
6.2<img src="6_2Flamingo. jpg " width="500"/> <table bgcolor="beige" border="5" height="10" > <tr> <td colspan
Q6โ Section header โ
Q7โ Section header โ
7.1.2Table calculation and Textbo Cell calculation: KwaZulu Natal: 100
7.3Cell M2: (Note to marker: OR function not IF statement\ =OR(F2=$B$11,F2=$B$12,F2=$B$13,F2=$B$14,F2=$B$15\ Versioning: Candidate and Marker MSO 365 Marker in MSO 2016/2019/2021 Cell reference: F2 Reference to all 5 options in the OR function
Q7โ Section header โ