First page: 'Precious Metals'

• Font type changed to 'Verdana' ✓
• Strikethrough effect removed ✓

Picture

• First image flipped for text to read from left to right ✓

Picture

• Height and width set to exactly 5 cm x 5 cm (or 4.57 x 5 or 5 x 5.47 if aspect ratio still checked) ✓
• Aspect ratio unchecked (if 5 cm x 5 cm allocate mark) ✓

First page

• Cover page/some pages/all pages are vertically aligned as 'center' ✓

'Metal' style

• 'Coin' style changed to 'Metal' ✓

Table of contents

• Table of contents updated (see heading 'Bullion') ✓
• Four levels display (see 'Annexure A' headings) ✓

Hyperlink

• Hyperlink removed from the word 'nuggets' ✓
  (Note to marker: Do not award mark if the word 'nuggets' is deleted.) 

Table

• Row 2 merged ✓ and text centred ✓
• Palladium shape filled with 'Gold, Accent, Lighter 60%' or '80%' (OR one shade lighter (blue or gold)) ✓
• Any column border changed to double line/thick border line ✓
• Formula field insert: =SUM(Above) ✓
• Formula formatted to display comma separator 000,000,000 OR ###,###,### OR #,##0 ✓
• Metals measured in tons sorted ✓
• In descending order ✓ according to number

Index entries
{XE "Precious Metals:silver"}

• 'silver' marked as a sub-entry for the marked index entry 'Precious Metals' ✓

Spelling of 'totaling'

• Spelling of the word 'totaling' corrected to 'totalling' ✓

Find and Replace: Word 'platinum'

Automatic numbering

• Automatic numbering (1., 2., 3.) applied to subheading 'A question of value investing' ✓
• 'Continue numbering' applied to the second sub-heading (rest of numbering automatically adjusted) ✓
• Number position set consistently against margin/to approximately 0 ✓
• Text indent of subheading set consistently (to approximately 1.25 cm)✓
• Text alignment under one or more subheadings is justified ✓

Index

• Index updated ('commodity markets' appear in Index) ✓

Page border/Watermark

• Any page border added to the document ✓
• 2PalMetal ✓ image inserted as washout watermark ✓
• Scaling of watermark/picture is set to 150% ✓

Bookmark

• 'History of Palladium' linked to 'History' bookmark ✓
• Bookmark 'Applications' removed ✓
  (Note to marker: Do not award second mark if the text has been deleted.) 

Text box and callout shape

• Text box changed to any callout shape ✓
• Text in shape/text box reads from bottom to top ✓
• All text clearly visible ✓
• Position of shape/text box fixed to its position page ✓
  (Note to marker: 'Move object with text box' should be unchecked to allocate fourth mark.) 

Caption

• Caption label 'Picture' used (do not accept typed text) ✓
• Caption added with caption text ✓ ('Beautiful rings')
• Caption placed above image ✓

Form controls

• Page break/Section break (Next page)/Page break before inserted before 'Quiz' ✓
• 'Full Name' text form field maximum length set to 12 ✓
• 'Full Name' text form field format set to 'First capital' ✓
• Any checkbox form field added ✓
• Any dropdown form field added ✓
• Option values set to Russia, South Africa, Ethiopia (accept if only some options entered) ✓

Table of figures (Use Alt + F9 to mark)

• Any automatic table of figures inserted ✓
• 'Simple' format used for table of figures ✓ (sentence case, in bold)
• Page numbers don't display in table of figures ✓

Rename worksheet

• 'Sheet1' renamed to 'Platinum' ✓

Cells A1:E1:

• Cells A1:E1 merged ✓
• Font size is 16 ✓
• Any gradient fill added to cells A1:E1 (not normal fill) ✓

Cell E2:

• Comment removed from cell E2✓

Cell E3:
=(D3-B3)/B3*100

• Correct cells: D3-B3 OR B3-D3✓
• Correct use of brackets ✓
• Division: /B3 OR D3 relative to 1st bullet ✓
• *100 ✓ (accept formatting as a percentage instead) 

Conditional formatting: Cells B8:D11

• Conditional formatting applied to cells B8:D11 ✓
• Top/Bottom rule ✓ set to 40 ✓ % ✓ (or values that rank in top 4)
• Any border applied ✓

Chart/Graph

• Data selection extended to cells A3:D5 OR A2:D5 ✓
• Data for 'South Africa' filled with 3Platinum image ✓
• Any stacked effect applied ✓
• Legend moved to bottom ✓
• Vertical axis display years (2014, 2015 and 2016) ✓

Cell D10: (Check for building blocks)
=LEFT(B1,TRUNC(B10/550))
OR
=LEFT(B1,INT(B10/550))
OR
=LEFT(B1,ROUNDDOWN(B10/550),0)
OR
=RIGHT(B1,TRUNC(B10/550))
OR
=MID(B1,1,(TRUNC(B10/550)))
OR
=IF(B10/550>=5,"*****",IF(B10/550>=4,"****", IF(B10/550>=3,"***",IF(B10/550>=2,"**","*"))))

• Function(s) used correctly ✓
• Used weight ✓ to determine the correct number of stars ✓
• Extract correct number of stars for all possibilities ✓
• Display stars for all possibilities ✓
  (Notes to marker:
• Accept any valid variation of the nested IF or LOOKUP functions. (Nested IF ✓, division/values ✓✓, conditions ✓, outcomes ✓)
• Check for building blocks.)

Row 3: Formatting

• Any text wrapped ✓

Cell A5:
=CONCATENATE(MID(C5,2,3),B5)
OR
=MID(C5,2,3)&B5

• CONCATENATE function OR & ✓
• MID ✓(C5,2,3) OR appropriate arguments ✓
• B5 ✓

Cell D5: (Check for building blocks)
=VLOOKUP(C5,Qual_Kwal!$A$1:$E$6, RANDBETWEEN(1,4)+1)
OR
=VLOOKUP(C5,Qual_Kwal!$A$3:$E$6, RANDBETWEEN(1,4)+1)
OR
=VLOOKUP(C5,Qual_Kwal!$A$3:$E$6,(RAND()* 3+1)+1)
OR
=VLOOKUP(C5,Qual_Kwal!$A$1:$E$6, RANDBETWEEN(2,5))

• Lookup value: C5 ✓
• Table array: Qual_Kwal!A1:E6 OR Qual_Kwal!$A$1:$E$6 ✓ (A3:E6 can also be used)
• Column index number OR RAND() OR RANDBETWEEN ✓
• Upper boundary (2) OR (1)+1✓
• Lower boundary (5) OR (4)+1✓ 

Cell F4:
=IF(C4="Silver",IF(H4<>"","*",""),"")
OR
=IF(C4="Silver",IF(H4="","","*"),"")
OR
=IF(AND(C4="Silver",H4<>""),"*","")
OR
=IF(C4="Silver",IF(LEN(H4)>0,"*",""),"")
OR
=IF(AND(C4="Silver",H4>0),"*","")

• Criteria 1: Check that the precious metal is silver: C4="Silver" ✓
• Criteria 2: Check if a value appears in column H OR column I: H4<>"" ✓
• Correct output (''") if metal is not silver ✓
• Correct output ('''') if metal is silver and no value appear in column H OR column I ✓
• Correct output ('*') if metal is silver and value appears in column H OR column I ✓
• Function copied to cells below (any function) ✓
  (Notes to marker:
• Accept any valid test for blank cell including COUNTBLANK(H4) and LEN(H4)=0.
• Accept any other correct test if the correct corresponding output is displayed.) 

Cell M6:
=SUMIF(B4:B53,"*ring*",J4:J53)
OR
=SUMIF(B4:B53,"Ring",J4:J53)+SUMIF(B4:B53, "Earrings",J4:J53)
OR
=SUMIFS(J4:J53,B4:B53,"*ring*")

• SUMIF/SUMIFS function ✓
• Criteria range: B4:B53 ✓
• Criteria: "*ring*", OR "Ring" AND "Earrings" ✓
• Sum range: J4:J53 ✓

Cell M7:
=COUNTIF(C4:C53,"Gold")

• COUNTIF function ✓
• Range: C4:C53 ✓
• Criteria: "Gold" ✓

Cell M8:
=COUNTA(H4:H53)
OR
=COUNT(E4:E53)-COUNTBLANK(H4:H53)
OR
=COUNTA(B4:B53)-COUNTBLANK(H4:H53)
OR
=COUNTIF(H4:H53,"*")

• Correct function ✓
• Correct range (accept column I) ✓
  (Note to marker: If COUNTA(range)-COUNTBLANK(range) structure is used accept columns (B,C,D,E,G,J) as correct range for COUNTA and columns (H or I) as correct range for COUNTBLANK.)

Field: Metal

• Field size set to 33 ✓

Field: Stones

• Format changed to Yes/No OR Lookup ✓

Field: Grams

• Required property set to Yes ✓
• Validation Rule: >10 ✓ and ✓ <=80 ✓ OR Between 11 and 80
• Appropriate validation text inserted that refers to correct range (more than 10 and less than or equal to 80) ✓

Field: JewelleryType

• 'Watch' option does not appear✓
• 'Bangle' option appears ✓
• In second position ✓

Field: JewelleryId

• Input Mask: LLLA09
  LLL ✓
  A ✓
  0 ✓
  9 ✓ 

Field: ValuationDate
Default value: DATE()+60
OR #2016-10-19# + 60
OR NOW()+60
OR #2016/12/18#

• DATE() OR NOW() OR Actual date ✓
• + 60 ✓

• Label added ✓ and examination number in form header ✓
• Combo box or list box added ✓
• Combo box values based on tb5_2 ✓ and bound/linked to InvestmentTerm field ✓
  (Row Source: tb5_2 OR Select[tb5_2]. [InvestmentTerm] FROM tb5_2 OR "Long"; "Medium"; "Short" AND Row Source Type: Table/Query OR Value List)

• InvestorCountry: Total: Group By ✓
• Criteria: 'United States' ✓ (or correct variations)
• NumberOfCoins: Total: Sum ✓

• Fields displayed: InvestorName, InvestorSurname, InvestmentDate and/or new field (CheckMatch) ✓
• Criteria InvestmentDate: >=#1975-01-01# ✓ OR >#1974-12-31#
  AND ✓
  <=#1989-12-31# ✓ OR <#1990-01-01#
  OR Between #1975-01-01# AND #1989-12-31#
  OR Year([InvestmentDate]): Between 1975 and 1989
• Calculated field: CheckMatch: ✓ [InvestorCountry] ✓ = ✓ [InvestorOrigin] ✓
  OR CheckMatch: IIF(✓) ([InvestorCountry]= [InvestorOrigin](✓✓),"True","False")
  (Note to marker: 50 records expected.)

• Grouping changed to InvestmentTerm field ✓
• Field InvestmentTerm appears in group header/footer ✓
• Function inserted in InvestorCountry group footer or group header ✓
• =COUNT ✓ ([InvestorSurname]) ✓ or any other field OR Count(*)
• Suitable label (must refer to number of investors) ✓

Heading, alignment and font colour
<h1 align="center"><font color="red">Rhodium Investment: The Rarest of Precious Metals</font></h1>

• 'Rhodium Investment: The Rarest of Precious Metals' appear as heading 1 ✓
• Alignment: center ✓
• Font colour: red ✓
  (Note to marker: Accept if font changes implemented with a paragraph tag.) 

Horizontal line
<hr width="90%"/>

• Horizontal line added ✓
• Line width set to 90% ✓

Background image
<body background="6Rh.jpg">

• background="6Rh.jpg" inserted correctly ✓
• In body tag ✓

Unordered list and line break
<ul type="square">
<li>Diesel catalytic converters</li>
<br/>
<li>Non-diesel catalytic converters</li>
</ul>

• Bulleted list added ✓
• Bullet type: square ✓
• Line break added between bullets (not paragraph) ✓

Image: height, width and border
<img src="/6RMine.jpg" height="100" width="200" border="5">

• Height = 100 ✓
• Width = 200 ✓
• Border = 5 ✓

Formatting: Bold and italics
<b><i>South Africa</i></b> OR <i><b>South Africa</b></i>

• Bold applied to 'South Africa' ✓
• Italics applied to 'South Africa' ✓ 

Link
<a href="/www.ResourceInvestor.com">
www.ResourceInvestor.com</a>

• Link text 'www.ResourceInvestor.com' inserted OR 'http://www.ResourceInvestor.com' ✓
• Link 'href' added correctly ✓
  (Note to marker: The link will work correctly if the web browser opens and the address displays in the address bar. No Internet access is needed.) 

Table: Cell spacing and colspan
<table align="center" border="3" cellspacing = "10">
<tr> <td colspan ="3">Rhodium Prices</td></tr>
<tr> <th>Metal</th>
<th>Year</th>
<th>Price</th></tr>
<tr> <td>Rhodium</td>
<td>2014</td>
<td>R1 235</td></tr>
</table>

• Cellspacing = 10 ✓
• First row: colspan = 3 ✓ (appears as a 'merged' cell)
• Text appears in the first row ('Rhodium Prices') ✓

Print Area

• Print area set ✓

Data validation: G2:G101

• Allow: Whole numbers ✓
• Data greater than or equal to 0 ✓

Data imported

• All data (100 records) imported ✓ to Clients table in database
• Column headings of worksheet used as field names ✓
• Table named as Clients ✓

Track changes

• All track changes accepted ✓ ('Birthstone Chart appears as 16 pt and bold) 

Footnote

• Endnote converted to footnote ✓
  (Note to marker: No marks awarded if a footnote is added in addition to the existing endnote.) 

Paragraph spacing

• Spacing after set to 3 pt after ✓

Tab setting: <<Birthstone_GeboorteSteen>>

• Any leader tab set ✓
• To 8 cm ✓

Mail merge

• Text '<InvestorName_BeleggerNaam>' replaced with the field <<InvestorName_BeleggerNaam>> ✓
• Data source: Month criteria set to 10 ✓

Merge completed

• Mail merge completed ✓ (see letters in 7GemMerge)

How many investors bought coins in any dollar currency?

• 77 ✓
  Method: ✓
• Filter on CoinFaceValue: Criteria: contains '$'
• OR Filter on CoinCurrency: Criteria: contains 'Dollar'
• =COUNTIF(M2:M101,"*Dollar*")
• Sort and count 

How many long term investors have a start date in September?

• 3 ✓
  Method: ✓
• Filter on InvestmentTerm: 'Long' AND Filter on StartDate: Dates in periods: 'September'
• OR add =MONTH(E2) in an extra column – in this case done in column P and use function =COUNTIFS(D2:D101,"Long",P2:P101,"9") 

What is the name of the most popular occurring coin?

• Maple Leaf OR Eagle ✓
  Method: ✓
• 7 COUNTIF/SUMIF for every coin name e.g.=COUNTIF(J2:J101,"Maple Leaf")
• First sort the data according to the coin name, and then use of the SUBTOTAL function to get a subtotal for each coin name
• Pivot table
• Use outline and get subtotal on CoinName