Gce Model Questions Vol1 2025 Computer Studies Question 37

In a sales spreadsheet, column B contains the unit price, column C the quantity sold, and column D the discount rate (as a decimal). Cell E2 contains the formula `=B2*C2*(1-D2)` to calculate the discounted subtotal. Cell F2 holds the tax rate 8 % (entered as 0.08). Cell G2 contains the formula `=IF(E2>1000, E2*(1+$F$2), E2)` to add tax only when the subtotal exceeds 1000. The formulas are copied down to row 5. The data are: | Row | B (price) | C (qty) | D (discount) | |-----|-----------|---------|--------------| | 2 | 120 | 5 | 0.10 | | 3 | 250 | 3 | 0.05 | | 4 | 80 | 12 | 0.00 | | 5 | 200 | 7 | 0.15 | What value appears in cell G5 after the formulas are evaluated?