• Page size set to A4 

1

 1

 Line spacing: 2nd paragraph – The following …

• Line spacing set to Multiple, 1.15

1

 1

 Find and Replace: (Expect 5 occurrences)

• Only exact/lowercase text 'ozone' replaced
• 'ozone' appears in Arial Narrow font
• 'ozone' appears in Bold and Italic

1
1
1

3 

 Text box: Nitrogen dioxide … from heart disease.

• Text box inserted
• Size: 9 cm high by 8 cm wide
• All data moved into text box (No mark if copied)
• Text box top left corner aligned to 'air' (Inspection)

1
1
1
1 

4 

 Columns: DOES IT MAKE … fuels and vehicles.

• Text placed in two columns
• Width of first column set to 8 cm
• Width of space between columns 1 cm

1
1
1 

β 

 Multilevel List: On the road … keeping windows closed.
(Note to marker: Mark from ruler)

• Multilevel List applied to given text
• Level 1: Format 1, 2, 3 (No full stop or bracket)
• Level 1: Aligned at 0 cm text indent at 1 cm
• Level 2: Format a), b), c)
• Level 2: Aligned at 1 cm text indent at 2 cm

1
1
2
1
2

 7

Source changed: UK Health Department

• Type of source: Website
• URL: http://www.airquality.co.uk

1
1

2

Bibliography

• (Any) automatic bibliography inserted

1

1

Watermark

• Picture 1Clean watermark inserted
• Scale: 150%

1
1

2

Inspect document

• All hidden text removed

1

1

Small caps: UNESCO: Marine Pollution

• Font changed to Small caps

TOC

• Table of Contents inserted
• Heading 1 style: 1st heading: 'Marine Pollution'
• 'Marine Pollution' at top of the next page

1
1
1

Hyphenation

• Hyphenation options: None OR Paragraph formatting exceptions: Don't hyphenate

Caption: Picture 1: © Malik Naumann | Marine Photobank

• Appropriate caption inserted (Alt + F9)
• Caption is the picture's Alt text:

Hyperlink: Picture 2: © Chris Deacutis

• Hyperlink removed from picture (Right click on image to check if hyperlink is removed)

Image: Picture 4: © NOAA

• Restored to original colour (Not greyscale)

Cross reference (Accept any picture & page no.)

• Linked to (any) picture IOC UNESCO
• Only page number displays (Alt + F9)

Footnote

• Footnote inserted on 'UNEP'
• Footnote numbering format set to A, B, C, …
• Footnote set to 'Restart each page'
• Footnote text inserted (Environment Programme)

Field: NumWords (Alt + F9) {NUMWORDS \*MERGEFORMAT}

• NumWords field inserted

Page numbering

• Automatic page numbering in Tildes format
• Page numbering inserted in footer
• TOC page and cover page not numbered, third page starts as number ~1~
• Page numbering continues on all remaining pages

Cell A1: Picture

• Picture 3Logo inserted
• Fits cell A1 (Mark by inspection)

1
1

2 

3.2

Cell A3: Fill

• Pattern fill is the same as cell A2

1

1 

3.3

Worksheet renamed

• Sheet1 worksheet renamed to Missions

1 

1 

3.4

Cell F3:
=COUNTIF(F6:F55,">55000")

• COUNTIF and range: (F6:F55)
• Criteria: ">55000"
  OR ">R55000" OR ">R55 000.00"

1
1 

2 

3.5

Column G: Conditional Formatting
= $C6:$C55 ="Air"
OR
=$C6 = "Air"

• Formula: =C6:C55 ="Air"
• Absolute cell referencing not applied to rows: $C6:$C55 OR C6:C55
• Conditional formatting applied to G6:G55
• Format: Any fill colour

 2
1
1
1

5

3.6

 Cell J6:
=HLOOKUP(D6,Categories!$B$1:$D$2,2,TRUE)
OR
=LOOKUP(D6,Categories! $B$1:$D$2)
OR
=XLOOKUP(D6, Categories! $B$1:$D$1, Categories!$B$2:$D$2,,-1)

• LOOKUP function appropriately structured (HLOOKUP OR LOOKUP OR XLOOKUP)
• Lookup value: D6
• Table array: Categories!$B$1:$D$2
  OR Categories!$A$1:$D$2
  OR Categories!B1:D2
  OR Categories!A1:D2
• Row index number: 2

1
1
1



1

4

3.7

Cell K6:
=IF(E6<TODAY(),"Complete",IF(E6-TODAY()<=60,"Notify","*"))
OR
=IF(E6>=TODAY(),IF((E6-TODAY())<=60, "Notify","*"),"Complete")
OR
=IF(E6<TODAY(),"Complete",IF(E6-TODAY()>60, "*","Notify"))
OR =IF(DAYS(E6,TODAY())<0,"Complete", IF(DAYS(E6,TODAY())<=60,"Notify","*"))

• Function: Nested IF
• First condition
• Output for first condition
• Second condition
• Output for second condition
• Output for third condition

1
1
1
1
1
1

Cell D3:
=SMALL(E7:E153,2)

• Function: SMALL
• Cell range: E7:E153
• 2

1
1
1

Cell B7: Data Validation

• Data validation source: $J$7:$J$8

1

Cell G7: Text functions
=LEFT($D$4,RIGHT(F7,1))
OR
=LEFT($D$4,MID(F7,2,1))
OR
=RIGHT($D$4,RIGHT(F7,1))
OR
=MID($D$4,RIGHT(F7,1))

• Combination of text functions
• Function: LEFT/RIGHT/MID
• From the text in cell D4
• To extract correct number of characters from cell F7
  (Note to marker: Accept other text functions such as REPT and TEXT if used correctly.)

1
1
1
1

Print area

• Print area set to cell range: A6:H40

1

Cell H10 OR cell H2
=SUMIFS(Quality!H7:H153,Quality!C7:C153,"Eastern Cape",Quality!D7:D153,2018)

• Sum range: Quality!H7:H153
• Criteria range 1: Quality!C7:C153
• Criteria 1: "Eastern Cape"
• Criteria range 2: Quality!D7:D153
• Criteria 2: 2018 OR "2018"
  (Note to marker: Accept cell A2 or cell A10 if it refers to "Eastern Cape" and cell H1 if it refers to 2018.)

1
1
1
1
1

Chart/Graph

• Bar chart/graph created
• Data selected: =Graph!$A$2:$A$10,Graph!$F$2:$F$10 OR
• =Graph!$A$1:$A$10,Graph!$F$1:$F$10
• Bars display from smallest to largest
• Chart title: Health incidents in 2016
• Data labels appear on outside end of each bar

1
1
1
1
1

Field: Coverage

• Field size changed to Decimal

1

1

Field: PollutionType

• Display control: Combo Box
• Row Source: 'Air', 'Land', 'Water'

1
1

Field: Level
Validation rule: Between 100 And 1000 OR >=100 and <=1000 OR >99 and <1001

• 100 and above
• And
• 1000 and below

1
1
1

Field inserted

• Field name: Evidence
• Field type: Attachment, Hyperlink

1
1 

•  Form heading changed to 'Survey'
• Only date appears in form foote
• Ion theme applied to the form
• YearBorn field format changed to Medium Date

• Group by RecyclingActivity
• Function AVG in DropOff
• Average value displays no decimal places

• Only Name, Surname, (YearBorn,) Knowledge, RecyclingActivity, DropOff fields display
• Sorted by Surname ascending
• Knowledge field criteria: 'Yes'
• OR
• RecyclingActivity field criteria: 'Very Active'
• AND
• DropOff field criteria: 15

• YearBorn field criteria: >#1990/12/31#
  OR >=#1991/01/01#
  OR YEAR([YearBorn])>1990
• Calculated field: NewDrop:[DropOff]*10/100+[DropOff]
  OR [DropOff]*110/100
  OR [DropOff]*1.1
  OR [DropOff]+[DropOff]*0.1
• NewDrop:
• [DropOff]
• *
• 10/100 + [DropOff] OR 110/100 OR 1.1

1

1
1
1
1

• DropOff field inserted and moved to correct position
• Grouping inserted on RecyclingActivit
• Any colour applied to the page header
• Sorted by Surname
• Function inserted in group header
• =COUNT (*) OR any other field

Title tags
<title>12345678</title>

• Title tags
• Examination number inserted between two tags

1
1

2 

Font colour: Heading: The Global Crisis …
<h1><font color="red">The Global Crisis of Plastic Pollution </font></h1>

• Font set to a red colour

1 

1 

Picture
<img src="/6_1Plastic.jpg" height="200" width="300"/>

• Attribute scr changed to src
• File extension png changed to jpg

1
1

2 

Table: rowspan
<table border="5" width="300" cellpadding="10">
<tr>
<td rowspan="3">Tons per year</td>
<td>China</td>

• Only column inserted <td…>…</td>
• Text 'Tons per year' inserted in first column
• Rowspan="3"

1
1
1 

3

<body>
<br/>
<a href="/6_1Clean.html">Home Page</a>
<h2>Types of pollution</h2>
<hr size="5" color="Black"/>
<ol>
<li>Air pollution</li>
<ul type="square">
<li>Ground-level ozone</li>
<li>Carbon monoxide</li>
<li>Sulphur oxides</li>
<li>Nitrogen oxides</li>
<li>Lead</li>
</ul>
<li>Water pollution</li>
<li>Light pollution</li>
<li>Noise pollution</li>
<li>Soil pollution</li>
</ol>
</body>

• Hyperlink
  
  • Tag for hyperlink correctly inserted
• Horizontal line
  
  • Horizontal rule tag
  • size="5" (Accept any size larger than "1")
• Unordered list
  
  • <ul>…</ul> tags
  • Type="square"
  • <li>Lead</li>

 1

1
1

1
1
1

Form controls

• Form field set to Current Date (Alt + F9, Form text Date)
• '7' and '14' options appear in drop-down form field control

1
1

2 

Mail merge (Expect 21 letters)

• 7Letter linked to 7Company spreadsheet
• Recipients' list is filtered to
  
  • Level = very high
  • Or OR contains 'high'
  • Level = high
• Merge fields inserted for Company name and Level
• Mail merge completed
  (SELECT * from 'Sheet1$' WHERE 'Level'='very high' OR 'Level'='high'/'Level' LIKE '%high%')

1

1
1
1
1
1

6

Cell D3:
=IF(AND(B3="Low",MONTH(C3)=11),A3," ")

• Criteria: Test if the level is low
• Criteria: Test if the month is 11

1
2 

3 

Filter

• Filtered on column A: Very High
• Filtered on column B: 2021
• Names sorted alphabetically

1
1
1 

 3