tables
2 sub-questions across 1 paper, 10 marks total.
Computer Applications Technology 2026
Construct the partners table: cellpadding 3; first row black background with white text; add a bottom row that displays the text found in 6_info.txt. Result looks like the screenshot: header Partner | Logo | Website, a row mLab South Africa | (empty logo) | https://mlab.co.za, and a final merged row "YISA | Community Partners | 2026-06-20".
Show answerHide answer
<table border="1" cellpadding="3">
<tr bgcolor="black">
<th><font color="white">Partner</font></th>
<th><font color="white">Logo</font></th>
<th><font color="white">Website</font></th>
</tr>
<tr>
<td>mLab South Africa</td>
<td></td>
<td><a href="https://mlab.co.za">https://mlab.co.za</a></td>
</tr>
<tr>
<td colspan="3"> (paste the text from 6_info.txt here) </td>
</tr>
</table><table border="1" cellpadding="3">
<tr bgcolor="black">
<th><font color="white">Partner</font></th>
<th><font color="white">Logo</font></th>
<th><font color="white">Website</font></th>
</tr>
<tr>
<td>mLab South Africa</td>
<td></td>
<td><a href="https://mlab.co.za">https://mlab.co.za</a></td>
</tr>
<tr>
<td colspan="3"> (paste the text from 6_info.txt here) </td>
</tr>
</table>Why this earns the marks
the seven marks come from: cellpadding="3"; a black background on the first row; white text in that row (needs the font tag in every header cell or equivalent); a new <tr> at the bottom; a single <td> spanning all three columns using colspan="3"; the 6_info.txt text copied correctly; and matching the displayed layout — seven genuinely separate pieces of markup built into one table. Open 6_Info.txt in Notepad and copy the exact text, since the merged bottom row's content is given data, not something you compose yourself. White text on a white page would be invisible, which is why the black background comes first: the two settings only make sense together, and doing them in either order is fine as long as both end up applied — it's the dependency between them (visible text needs contrast with its background) that the marking is checking you understood. If a table already exists, repair it rather than retyping, since the exam rewards fixing specific faults efficiently rather than rebuilding working markup from scratch.
On the Sectors worksheet convert Sectors!A1:B6 to an Excel Table, filter Sector to show names ending with 'Tech', and in B8 use SUBTOTAL to sum the visible Q1 values, choosing a function_num that ignores hidden rows and updates when the filter changes.
Show answerHide answer
Select A1:B6 → Ctrl+T → tick "My table has headers" → OK.
Click the Sector filter arrow → Text Filters → Ends With… → type
Tech→ OK. (Logistics disappears; FinTech, EdTech, AgriTech and HealthTech remain.)In B8 (outside the table):
=SUBTOTAL(109,B2:B6)Save and close 7_Dashboard.xlsx.
Why this earns the marks
marks: table created, filter correctly applied, SUBTOTAL with 109. 109 = SUM that ignores hidden rows, and SUBTOTAL recalculates when the filter changes, unlike plain SUM, which adds hidden rows too — exactly the SUBTOTAL behaviour explained in the spreadsheets notes, now applied to a live filtered table rather than a manually hidden range. Place B8 below the table with a gap row so Excel does not absorb it into the table, because an Excel Table automatically expands to include any data typed immediately adjacent to it — without the gap, your SUBTOTAL cell would become a new table row rather than staying an independent total outside it. If your Sectors sheet Q1 values match Impact, the visible total is 31 (5 + 10 + 11 + 5), which is a useful arithmetic check that the filter and SUBTOTAL are both working as intended, not just present.