• Condensed spacing applied to the heading 'What Is Heart Attack…' ✓
• Spacing is 1pt ✓

• Inserted a non-breaking hyphen between the numbers instead of an ordinary hyphen. ✓
• Inserted two times i.e. between 9-1-1.✓

• Automatic caption added for the image. ✓
• Placed above the image. ✓

• Footnote inserted with any symbol. ✓
• Footnote reads as 'Prescribed'. ✓

• 'Happy Heart' style applied. ✓
• To all the three paragraph headings shaded in green. ✓

• Multilevel numbering used✓
• Level 1 is 1)… ✓
• Level 2 is a)… ✓

• Three paragraphs placed in 3 columns✓
• With a line between✓
• Equal column width of 0.5 cm✓
• Applied column breaks to paragraph headings to start from the top. ✓

• Name of the author inserted as 'James Beckerman' in the citation. ✓
• Citation updated in the document to include the name of the author as well. ✓

• Table of Contents inserted on the second page of the document. ✓
• Format used is 'Distinctive'✓
• Only the three styles 'Love Heart', 'Heart Care', and 'Happy Heart' included in the TOC. ✓

• Automatic page numbering inserted in the footer✓
• In any format✓
• No page numbers appear in the first✓ and last page✓
• Page numbering starts from 1 onwards✓

• Text shading added to the heading 'Am I aware'✓
• Any colour✓

Text form field for the heading 'Surname' formatted

• To accommodate 20 characters✓
• And to display in CAPITAL letters✓

Age field formatted so that

• It accepts 2 digits✓
• Help text added to the F1 key✓
• The message reads ' Enter numbers between 20 and 70' ✓

• Check box form added to Male and Female option✓
• Check box size is exactly 15 pt. ✓

• Smoking option added to the existing list. ✓
• And moved to the top of the list. ✓

• Smoking and Fatty Diet grouped✓
• as a single object with the rest of the shapes✓

• 10 cm tab set✓
• Dashed line leader tab set for 4 lines✓

Cell O1:

• Cell O1 formatted to display only the current time. ✓

Cell A2:

• 3_Heart Beat.jpg inserted in cell A2✓
• Height is 1 cm
• Width is 15 cm

Cell A5:
=CONCATENATE(LEFT(B5,1),LEN(C5),E5)
OR
=LEFT(B5,1)&LEN(C5)&E5

• CONCATENATE function OR & sign✓
• LEFT ✓ (B5,1) ✓
• LEN ✓ (C5) ✓
• E5 ✓

Cell H5:
=G5/((H5/$O$2)*(H5/$O$2))
OR
=G5/POWER((H5/$O$2),2)

• G5 ✓
• (H5/$O$2)*(H5/$O$2) OR POWER Function ✓✓
• Absolute cell reference used ✓
• Formatted to zero decimal places✓
  (Note to marker: Accept any other suitable method.)

Conditional formatting:

• Top three values shaded✓
• Thin horizontal crosshatch pattern style applied✓
• Yellow pattern colour used✓

Cell N5:
=VLOOKUP(I5,'BMI Category'!$A$5:$B$12,2,TRUE)

• LOOKUP value: I5✓
• Table array: 'BMI Category'!$A$5:$B$12✓
• Absolute cell reference ✓
• Column index number: 2✓
• Range_Lookup: TRUE✓
• Copied down for the rest of the cells✓

Cell G26:
=COUNTIFS(F5:F24,F5,M5:M24,M21)

• COUNTIFS function ✓
• Range: F5:F24 ✓
• Criteria: F5 OR 'Male' ✓
• Range: M5:M24 ✓
• Criteria: M21 OR 'YES' ✓
  (Note to marker: Accept any other suitable method.)

Cell G28:
=COUNTBLANK(K5:K24)

• COUNTBLANK ✓
• (K5:K24) ✓

Cell G30:
=ROUND(AVERAGE(O5:O24),0)

• ROUND function ✓
• Average function ✓
• Range (O5:O24) ✓
• Zero decimal places ✓

• Cell G32:
  =SUMIF(F5:F24,F6,O5:O24)
  OR
  =SUMIF(F5:F24,"Female",O5:O24)
• SUMIF function ✓
• Range F5:F24 ✓
• Criteria Female or any cell number that contains the value female ✓
• Sum range O5:O24 ✓

Cell P5:
=IF(J5>=120,"Most Likely",IF(J5<80,"Not Likely","Least Likely"))

• IF function ✓
• Condition J5>=120 and value ✓
• Condition J5<80 and value ✓
• Value if all conditions are false ✓
• Correct use of open and closing brackets ✓

Graph

• Data label added to the highest value in the graph. ✓
• Highest data bar filled with the image 3_Overweight.jpg ✓
• Black outline applied to this data bar ✓
• X axis values displayed in the reverse order. ✓
• Vertical gridlines displayed for both major and minor units. ✓

Customised alternate row colour

• Colour level for Red is 200 ✓
• Colour level for Green is 210 ✓
• Colour level for Blue is 220 ✓

Age column

• Average of ages found at the bottom of the age column. ✓
• Corrected to zero decimal places. ✓

Input mask on the Patient Code field:
>LL-009-"LPH"

• > ✓
• LL ✓
• - ✓
• 00 ✓
• 9 ✓
• LPH ✓

Patient_History table:

• Applied a black gridline and ✓
• Sunken cell effect to the table. ✓

Validation rule to gender field:

• Male ✓ or Female ✓

Validation message to gender field:

• Any appropriate message ✓

• Name, Age, Height (in cm), Body Mass (in kg) and BMR fields are displayed. ✓
• Calculated field name: BMR: ✓
• BMR: 655.0955✓+ (9.5634 * [body mass (in kg)] ✓) + (1.8496*[height (in cm)] ✓) - (4.6756*[age] ✓)
• All the signs used correctly. ✓

• Criteria
  Blood Pressure (Systolic) field: >✓120✓
  OR >=119
• Criteria
  Blood Pressure (Diastolic) field: Between 90✓ And✓ 95
• Criteria
  Suggested Action field: "*✓medical attention"✓

• Name, Gender, Sugar Level and Risk fields inserted ✓
• Heading changed to Patient Sugar Levels✓
• Dividing lines are visible. ✓
• Default form view changed to continuous✓
• 5_Sugar Level.jpg inserted in the detail section✓
• Height and width of the image is 5 cm ✓

• Report created based on qry5_7 ✓
• Report grouped based on Sugar Level (mmol/L) field. ✓
• Grouping intervals set to 10s✓
• Conditional formatting applied to Risk field with patients with Very High  risk shaded in red colour ✓
• =count(*)✓ calculation used in the group footer
• Proper label given for the calculation.✓

Title
<title>Healthy Heart</title>

• 'Healthy heart' appears ✓
• In the browser tab ✓

Font tag
<font face="century gothic" size="3"> </font>

• font face is century gothic ✓
• font size is 3 ✓

Heading style
<h1 align="center">Heart Disease & You</h1>

• Heart Disease & You appear as heading 1 ✓

Bold and Italics formatting
<b><i>Cardiovascular Disease</i></b>

• Cardiovascular Disease made Bold ✓
• Cardiovascular Disease made Italics ✓

NOTE: Reduce 1 mark if tags are not closed in the reverse order.

Horizontal line size and colour
<hr color="black" size=3 />

• Line size set to 3 ✓
• Line color set to black ✓

Table Row and Column:
<tr bgcolor="White">
<th> Blood Pressure Category </th>
<th> Systolic mm Hg (Upper #) </th>
<th> <img src="/6_Heart Pressure.jpg"> </th>
<th> Diastolic mm Hg (Lower #) </th>
</tr>

• Image appears as the third heading in the first row✓
• Image displays correctly ✓

------------------------------------------------------------------------------

<tr bgcolor="red">
<td>Hypertensive Crisis (Emergency care needed)</td>
<td>Higher than 180</td>
<td>or</td>
<td>Higher than 110</td>
</tr>

• Row added at the bottom of the table. ✓
• All the relevant text entered correctly in the row. ✓
• Background colour of the row changed to red. ✓
• All the tags used correctly. ✓

Ordered List
<ol type="A"> </ol>

• Existing unordered list changed to ordered list. ✓
• List numbers appears as uppercase alphabets, e.g. A, B. ✓

Link
<a href ="Healthy life style.pdf">
Click here to view the TIPS on how to live a Healthy
Life Style provided by THE HEART
AND STROKE FOUNDATION SOUTH AFRICA
</a>

• Link moves to ' Healthy life style.pdf ' ✓
• Link works correctly✓

Center tag
<center> Have Your Heart In The Right Place </center>

• The text is centred using the centre tag ✓

Formula used in the shaded region
=SUM(ABOVE)

• SUM function used ✓
• Criteria is ABOVE ✓

Organogram

• Shape added before the shape name Fruits ✓
• New shape given the name Healthy Protein ✓

Death rates worksheet

• Graph edited to include South Africa as well ✓
• All the data values displayed correctly ✓

Cell G7:
='Death Rates'!B7

• 'Death Rates'! ✓
• B7 ✓

Mail Merge:

• Patient Details table in 4_Heart Patients database used as the data source. ✓
• Name and Surname fields added. ✓
• Mail merge completed and saved as 7_AwarenessInvitation ✓

(22 letters expected)