B1 (a)i Insert a new row at the top of the spreadsheet and…

B1 (а)i Insert а new rоw аt the tоp оf the spreadsheet and enter the heading ‘Ski Information 2021’ (2) B1 (a)ii Merge and centre cells A1 to E1 (2) B1 (a)iii Formatting of the heading to font size – 24, font style – serif, font enhancement – bold. (3) B1 (b) Sam wants you to use spreadsheet tools to analyse the data for the information included. Use functions to :-   B1 (b)i Display the cost of Equipment Hire. Use vlookup in C2 in the Members worksheet and the table in Details worksheet A14:B16 (HINT -absolute referencing will be needed for ranges) (4) B1 (b)ii Display the cost of the Ski Pass in D2 that includes a 20% discount if the cost of the Equipment Hire is more than 300€ (3) B1 (b)iii Calculate total cost of the Equipment Hire and the Ski Pass in E2 (1) B1 (b)iv Replicate all functions and formula for all members. (2) B1 (b)v Display the total cost of Equipment Hire in E18 (1) B1 (b)vi Format the MEMBERS worksheet so that currency values show the currency symbol (€) with no decimal places (2)   SAVE the spreadsheet as Task B [20]