1a: Write out and explain the formula you would put in H4 so that it refers back to the relevant assumption in H2, but can then be copied across to I4 and then down in cells H5:I7 so that in the relevant cells it refers back to H2 and I2 as appropriate.

1b: Additional products need to be added to the spreadsheet above. In order to accommodate this, you have been asked to edit the spreadsheet and convert the product table (F3:J7) into an Excel table. Outline how you would do this and what benefits there are of converting it to a table.

1c: Using the spreadsheet contained at the top of the page, write out formulas and what answer they would return for the Count, CountA and Countblank formulas which shows what the different formulas do.

F G J NP 1 2 H Mark-up Vat Rate Assumptions: 1.5 1.21 3 Title 4 Product 1 5 Product 2 6 Product 3 7 Product 4 8 9 Total Price 10 Cost Price Mark-up VAT Rate Retail Price 15.00 1.5 1.21 27.23 20.00 1.5 1.21 36.30 20.00 1.5 1.21 36.30 25.00 1.5 1.21 45.38 145.20