Fig. 1 is a simplified view of a spreadsheet used by a museum shop. The shop records the number of guidebooks sold and the selling price. Cell F2 contains t...
Question 1 Report
Fig. 1 is a simplified view of a spreadsheet used by a museum shop. The shop records the number of guidebooks sold and the selling price. Cell F2 contains the VAT rate. The shop manager wants a formula in E3 that calculates the selling price including VAT. The formula is copied to later rows, so the VAT-rate reference must not move. The manager will use task B3 to create a chart of sales by product after the calculations are checked.
(a) Create a formula for E3 using the VAT rate in F2. [3]
(b) Explain why F2 should be written as an absolute reference. [2]
(c) Use a suitable number format for E3. [1]
(d) Create a chart type suitable for comparing the number sold for each product. [2]
Answer Details
(a) Use =C3*(1+$F$2) [3]. The multiplier \(1 + 0.20\) adds 20% VAT to the price. An equally valid form is =C3+(C3*$F$2).
(b) Write F2 as $F$2 because the VAT rate must remain in F2 when the formula is copied [2]. Without absolute references, copying down would change it to F3, F4 and so on.
(c) Format E3 as £ currency with two decimal places [1].
(d) Use a bar chart or column chart [2] to compare the number sold for each product.
Download The App On Google Playstore
Everything you need to excel in your exams
