currency
1 sub-question across 1 paper, 5 marks total.
Computer Applications Technology 2026
Convert the micro-grants in column G (GrantUSD) to ZAR at R19.20 per $. In B4, calculate the total Rand value of column G using the rate in B2. Format B4 as South African currency.
Show answerHide answer
Make sure B2 contains the rate 19.20.
In B4 type the formula above (data range as in your sheet). Using
=SUM(G8:G30)*$B$2is also correct.Select B4 → Ctrl+1 → Currency → Symbol R English (South Africa), 2 decimals → OK.
B2: 19.2 (the rate, if not already typed)
B4: =SUM(G8:G30)*B2B2: 19.2 (the rate, if not already typed)
B4: =SUM(G8:G30)*B2Why this earns the marks
the marks cover: using a formula (not typing a total), summing column G, multiplying by the rate, referring to B2 instead of typing 19.2 in the formula, and formatting as Rand currency — five genuinely distinct actions chained into one cell. Referring to B2 means that if the rate changes, the result updates: this is the core reason instruction 13 ("use formulas for every calculation") exists at all — a typed, hard-coded number is a frozen snapshot that silently goes stale the moment its inputs change, while a formula referencing B2 recalculates automatically. Alternative: =SUMPRODUCT(G8:G30,B2), which multiplies every value in the range by the rate and adds the results in one step — mathematically equivalent to SUM-then-multiply, just computed in a different order.