Page size

• Page size changed to A4 ✓

Margin

• Top margin set to 2 cm ✓
• Gutter position set to left ✓

Style

• New style 'Love Gold' created ✓
• Based on the 'Heading 1' style ✓
• Text centred horizontally ✓
• Any border applied ✓
• New style applied to heading ✓

Citation

• 'Pinn&Co, J' citation inserted after the heading ✓
• Page number 3 displayed ✓
• Year (2012) displayed ✓

Line spacing

• First paragraph line spacing set to multiple ✓
• At 1.2 ✓

Spacing

• First line indent applied to second paragraph ✓
• Set at 2 cm ✓

Find and replace

• Text 'nano' replaced with 'NANO' in small caps ✓
• 4 occurrences of 'nano' replaced ✓

Thesaurus

• 'Alchemist' replaced with word from suggested list: experimenters, transformers, pseudoscientists, etc. ✓

SmartArt

• Last shape filled with picture 1Gold_Goud ✓
• Text added to the last shape ✓ ('Gold Bricks')
• Layout changed to 'Closed Chevron Process' ✓
• Automatic caption inserted ✓ ('Processing Gold') (ignore if caption is centred)

Bibliography

• Any automatic bibliography inserted ✓

Watermark

• Any text watermark added on any page ✓
• Text changed to 'Love of Gold' ✓ (accept any part of text)

Table of contents

• Table of contents updated ('Index' to be included) ✓
• 2 levels of headings displayed ✓
• Page number displayed with solid tab leader ✓
• 'Fancy' format used ✓ (Small caps)

Comment

• Any comment added to word 'resources' ✓

Cross reference

• Cross reference on text 'production is slowly declining' added (text does not display) ✓
• Entire caption is displayed 'Table 1: Year-on-year changes' ✓

Text inserted

• All the text from 2Trade_Handel inserted ✓
• Text replaced in the correct position ✓

Image

• Image cropped correctly ✓
• Image rotated/flipped ✓ (camel appears on left)
• Any border with any border width added to image ✓

Edit table

• Table auto fitted to window ✓
• Any row height set to 1 cm ✓
• Cells in first column merged ✓
• Any content in cells centred vertically and horizontally ✓
• Argument in MIN function changed to LEFT ✓

Text to table

• Text added as first row to table ✓
• Any predefined table style applied ✓
• Alternative table title text inserted ✓ ('Changes')
  (Note to marker: Check table properties to see if changes were made in Alt Text.)

Link

• Document 2Predict_Voorspel inserted ✓
• Displays as icon ✓
  (Note to marker: Award one mark only if learner used a hyperlink with no icon.)

Table of figures

• Table of figures updated (2 automatic entries) ✓

Index

• Index inserted ✓
• Appears as one column ✓

Page numbers

• Automatic page numbers inserted in header/footer ✓
• Display vertically in left or right margin ✓

Cells A1:G1:

• Cells A1:G1 merged and centred ✓
• Text wrapped ✓

Number formatting (B3:B14):

• Number formatting used ✓
• Negative values displayed in red font colour (any number format) ✓
  (Note to marker: Do not award any marks if conditional formatting was used.) 

Conditional formatting:

• Conditional formatting applied to columns B to F ✓
• Cells with lowest ten values appear shaded (not font colour) ✓
  (Note to marker: The top '10 negative numbers' will be shaded.)

Cell B15:
=AVERAGE(B3:B14)

• AVERAGE function ✓
• Correct range (B3:B14) ✓

Cell B16:
=LARGE(Five,2)

• LARGE function ✓
• Named range 'Five' ✓
• 2 ✓

Cell G3:
=IF(F3>=0,A3,"*")
OR
=IF(F3<0,"*",A3)

• IF function ✓
• Test: F3>=0 OR F3<0 ✓
• "*" displayed if cell F3 is negative ✓
• Month displayed if cell F3 is positive or 0 ✓
  (Note to marker: Accept if only > or < is used in the condition.) 

Graph/chart:

• Column graph/chart inserted ✓
• Correct data =Stats!$A$3:$A$14,Stats!$F$3:$F$14 used ✓
• Chart title inserted  ('Production 2015') below the chart ✓
• Data labels  displayed inside ✓ data series
• Month names (horizontal axis labels) displayed in 8.5 pt font size ✓
• 'August' series filled with green colour ✓
  (Note to marker: Ignore if the legend appears on the graph/chart.)

 Data sort:

• All data sorted by date of birth (column C) ✓
• Youngest to oldest ✓ (newest to oldest)

Cell A3:
=CONCATENATE(LEFT(B3,3),RANDBETWEEN(1,250))
OR
=LEFT(B3,3)&INT(RAND()*(250)+1)

• CONCATENATE OR & ✓
• LEFT  (B3,3) ✓
• RANDBETWEEN ✓ (1,250) ✓
  (Note to marker: If RAND was used accept any correctly used function to round off the number, such as INT, TRUNC or ROUND.)

Cell G3:
=F3+H3/24

• F3 ✓
• +H3/24 ✓

Cell D3:
=COUNTIF(Shift_Skof!D3:D252,"AR001")

• COUNTIF function ✓
• Criteria range: Shift_Skof!D3:D252 ✓
• Criteria: "AR001" ✓ (not name or surname) 

Cell E4:
=SUMIF(Shift_Skof!D3:D252,"BD002", Shift_Skof!H3:H252)

• SUMIF function ✓
• Criteria range: Shift_Skof!D3:D252 ✓
• Criteria: "BD002" ✓
• Sum range: Shift_Skof!H3:H252 ✓
  (Note to marker: Allocate marks only if name AND surname columns were correctly used.)

Column F:
=VLOOKUP(D3,Scale_Skaal!$A$2:$B$8,2)
OR
=VLOOKUP(D3,Scale_Skaal!A$2:B$8,2)

• Lookup Value: D3 ✓
• Table array: Scale_Skaal!$A$2:$B$8✓ OR
• Table array: Scale_Skaal!A$2:B$8
• Absolute cell referencing applied correctly ✓
• Column index number: 2 ✓
• Copied to other cells ✓
  (Note to marker: Accept A1:B8 as lookup range.)

Cell I5:
=IF(E5>60,"Experienced",IF(H5>20,"Experienced", ""))
OR
=IF(OR(E5>60,H5>20),"Experienced","")
OR
=IF((E5>60)+(H5>20),"Experienced"," ")

• Syntax of IF function is correct ✓
• Criteria E5>60 ✓
• Criteria H5>20 ✓
• "Experienced" shows if either of the criteria is true ✓
• " " OR "False" ✓

Field: Name

• Field size set to 15 ✓

Field: Surname

• Required set to 'Yes' ✓

Field: Gender

• Default value set to 'Male' OR 'M' ✓

Field: YearsEmployed
Validation Rule

•  >0 ✓ and ✓ <50 ✓
  OR
  >=1 and <=49
  OR
  Between 1 and 49
• Validation text
  Any suitable message that refers to range between 1 and 49 ✓

Field: IDNum
Input Mask: 000000 0000 000 will appear as
000000\ 0000\ 000;
OR
000000\ 0000\ 000
OR
000000" "0000" "000"

• Correct character 0 ✓
• Two spaces correctly placed ✓
• Thirteen valid placeholders ✓

Function:
=(Date() ✓- [Birthdate]) ✓ /365 ✓
OR
=(Now()-[Birthdate])/365.25
OR
=(Year(Now())-Year([Birthdate])

• Fixed/Standard ✓
• Age field formatted to zero decimal places ✓
• Suitable label relating to age inserted ✓
  (Note to marker: Accept the function
  =Round ✓ ((Now()✓-[Birthdate]✓)/365.25✓,0✓) for the first 5 marks.)

• Only Name, Surname and ContactNum fields display ✓
• Additional fields added (ContactNum, Gender, Permanent) ✓
• Gender criteria: "F" ✓ and ✓ Permanent criteria: "No" OR FALSE OR 0 ✓
  (Note to marker: 34 records expected.)

• New field Salary created ✓
• Calculation: [Notch] ✓ *1200 ✓
• Calculated field Salary formatted to currency ✓

• Sorted in ascending order according to Surname and Name fields ✓
• Surname field appears before the Name field ✓
• Notch criteria 12 ✓
• OR operator (or separate criteria line) used ✓
• Birthdate criteria <#01/01/1956# OR <=#31/12/1955# OR YEAR([Birthdate])<1956 ✓(ignore format of year)
  (Note to marker: 9 records expected.)

• 5Mine_Myn picture ✓ inserted in report header ✓
• Function inserted in the Permanent group footer/header ✓
• Function: =Count(*) ✓ OR =Count([Name]) or on any other field
• Average function moved to report footer ✓
• Replaced AVERAGE with AVG in function ✓

Heading
<h1 align="center"><font color="yellow">Jewellery Design</font></h1>

• Heading alignment set to centre ✓
• Heading font colour changed to yellow ✓

Horizontal line
<hr width="60%" size="8">

• Horizontal line inserted ✓
• Line width set to 60% ✓
• Line size set to 8 ✓

Open lines
<br/><br/>

• Break tag inserted <br/> ✓
• Two open lines inserted ✓

Bold
<b>You can buy high quality …</b>

• Bold tags applied to correct paragraph ✓

Image
<img src="/6J.png">

• 'src' attribute inserted ✓
• Correct file used "6J" ✓
• Image displays correctly ✓ (correct extension used) 

Alternative text
<img src="/6J.png" alt ="Jewellery">

• Alternative text tag inserted ✓
• Correct text inserted "Jewellery" ✓

Table
<table border=5>
     <tr>
           <td>Jewellers use:</td>
           <td>Precious stones</td>
      </tr>
      <tr>
           <td>Jewellers work with:</td>
           <td>
                        <ul>
                        <li>Plastic</li>
                        <li>Enamel</li>
                        <li>Perspex</li>
                        </ul>
          </td>
     </tr>
     <tr>
           <td colspan="2">Jewellers create their own beads and jewellery made from ostrich eggshell, leather and wood</td>
      </tr>
</table>

• The table consists of three rows and two columns ✓
• Correct text appears in each cell ✓
• Unordered list inserted ✓
• Correct tags identify items in list ✓
• Last row: cell (colspan) spans 2 columns ✓

Hyperlink
<a href="http://www.southafrica.net.za">Go to Jewellery design website</a>

• Hyperlink tags inserted <a href></a> ✓
• Tags inserted to link to the correct file "http://www.southafrica.net.za" ✓
• Hyperlink inserted on correct text 'Go to Jewellery design website' ✓

Mail Merge

• Source table Clients linked with 7Statem_Staat ✓
• Merge fields Initials and Surname added in the correct place (accept if only one field) ✓
• Space inserted between two fields (do not allocate if only one field inserted) ✓

Form controls

• 'Date' form field set to 'Current date' ✓
• 'Amount Due' form field set to display in 'Number' and 'Currency'  and default value set to zero ✓
• 'Cash' option added to drop down form field ✓

Insert graph/chart data

• 'Gold fields' mine name appears ✓
• Value '211' inserted correctly for Newmont Mining ✓

Page orientation

• Page orientation of only indicated text changed to landscape ✓

Header

• Text 'Choices' inserted in header on any/all pages ✓
• Applied to landscape pages only ✓ (Link to previous removed) 

Line breaks

• 'Keep lines together' setting applied to all paragraphs in document ✓

Hyphenation

• Automatic hyphenation applied to text ✓
• Hyphenation limit set to 2 consecutive lines ✓

What is the size of the spacing AFTER the paragraph in the 'Title' style?

• Auto ✓ (Accept any paragraph spacing)

How many times does the EXACT word 'Gold' appear in this document?

• 8 ✓

What is the alternative text title of the picture found at the end of the document?

• Gold Nugget ✓

What is the name of the artistic effect applied to the picture at the end of the document?

• Film Grain ✓