Question 4 — Spreadsheet

hiding means the rows stay in the file but are not displayed — a hidden row's data, and any formula depending on it, is completely unaffected; only its on-screen visibility (and, by default, its inclusion in things like printing) changes. Selecting by row headers (not cells) ensures whole rows are hidden, because Hide is a row/column-level command: selecting cells and trying to "hide" them has no equivalent action, while selecting the row numbers themselves targets the entire row as one unit. Do not delete them: deleting removes the data permanently and renumbers every row below, which would silently break any formula referencing those rows by position.

the default order is ascending, which for dates means oldest first — Excel sorts dates as the underlying serial numbers they actually are (each date is stored as a count of days since a fixed starting point), so "ascending" naturally means earliest date first, exactly like sorting ascending numbers means smallest first. Sorting the whole table (all rows) keeps each record together: Excel's Sort dialog, when started from inside a recognised data range with headers, sorts every column in lock-step by the same row reordering. Selecting one column alone and sorting only that column would scramble the data, because that column's values would be reordered while every other column's values stayed in their original row positions — each row would then mismatch its own date, venue, attendance and so on.

one mark for a list-type validation, one for exactly the two items — Data Validation's "List" option is specifically what restricts entry to a fixed set of choices, as opposed to other Allow types (Whole Number, Decimal, Date) that restrict by kind of value rather than by an exact approved list. If Excel says the source is wrong, the separator setting is why, not the spelling: the character that separates list items is read from the computer's regional settings (comma in many locales, semicolon under South African settings, since the comma is already the decimal separator there), so a perfectly spelled list with the wrong separator for that machine's region is rejected as malformed, not as a spelling mistake. If prompted, tick "Apply these changes to all other cells with the same settings" so the fix applies consistently across the whole column rather than just the one cell you edited.

marks for: correct range, data bars, solid (not gradient) green — three independently checkable settings inside the same dialog. By default the bar length grows with the value (lowest value shortest, highest longest), which is what the question asks, because Data Bars scale each bar's length proportionally between the range's minimum and maximum value — that's the entire point of the feature, to make relative size visible at a glance without reading the numbers. Check under Manage Rules → Edit that the direction is not reversed: Conditional Formatting does allow the scale to be flipped (and even allows bars to grow leftward), so a setting that was changed from the default would produce a chart that technically uses Data Bars but shows the wrong values as "longest."

six marks: IF used, AND used, attendance test with >=, satisfaction test with >=, "Flag" as the true result and "" (blank) as the false result, plus the fill to J15 — six independently checkable pieces nested inside one formula. Use >=, not >, because "120 or more" includes 120: a strict greater-than would wrongly exclude a row where attendance is exactly 120, which the wording explicitly includes. The empty quotes "" make the cell appear blank, which is different from leaving the formula's false branch empty entirely (that would be a syntax error) — "" is Excel's way of writing "the text value containing zero characters," which displays as nothing while still being a valid, present formula result. Relative references (no $) let each row test its own values when copied down: with no dollar signs, E4 and F4 automatically become E5/F5, E6/F6 and so on as the formula fills downward, exactly like any ordinary relative reference.

SUMIFS adds values only where all conditions are true — it's built for exactly this "total matching two or more criteria at once" shape of question, as opposed to SUMIF (one condition only) or COUNTIFS (counts matches rather than summing a value). Its order is sum range first (Attendance), then each criteria range followed by its criterion, which is a different argument order from SUMIF specifically so that any number of extra range/criterion pairs can be added after the first without ambiguity. Marks: SUMIFS, sum range, venue range plus criterion, type range plus criterion. SUMIF would not do because it handles only one condition, and this question genuinely needs two (venue AND type) satisfied simultaneously. Match the text exactly as it appears in the data, since SUMIFS criteria compare text literally — "Pitch day" and "Pitch Day" would not be treated as the same value.

one mark for the Line type, one for the correct data and location — Excel offers several sparkline types (Line, Column, Win/Loss), each visualising the same kind of data differently, so the type itself is a deliberate, checkable choice, not just a default. A sparkline sits inside a single cell as a miniature chart, so the Location Range must be E2 and not a range: unlike a normal chart (a separate floating object that can span any area), a sparkline is drawn as cell content, so it can only ever belong to exactly one cell.