I

1. Please create the Table below in Excel. Your table should begin in cell B5. In the first row of the table merge the cells, so that it becomes one cell and put the following title within this cell: New Customer Account Balances at New Liberal Jamaican Bank Ltd, as at April 30, 2022 (the name should be bold and centred, font size 18 in the first row spanning the table ) (5 marks) Last Name First- Name Lowest Savings Interest /NO Interest Custom er Rank Allen Johnson Black James Amy John Sarah Keisha Luke Rachael Byron Donovan Personal Savings Account 8000 28000 64600 47400 32800 23100 19500 37000 Customer Accounts and Balances Current Joint Total Average Highest Savings Savings Savings Savings Sales Account Account 15000 21000 25400 66000 39400 89000 44500 67000 56700 56000 64700 69000 78400 76000 38000 52000 Brown White Brown Anderson 2. Save this file with the name Customer Accounts-YourIDNumber eg. (Customer Accounts-2020XXXX ) 3. Using the correct function, Insert the current Date and Time in Cell A3. [2 mark] 4. Sort the Last-Name column of the Table in Ascending Order. [1 mark] 5. Count all the Names in the Last Name Column using an appropriate function(Place answer in B17) [2 mark] 6. Calculate the Total Savings for each of the customers above [1 mark] 7. Calculate the Average Savings for each customer. [1 mark] 8. Use an appropriate function to calculate the Highest Savings for each customer. [1 mark] 9. Use the correct function to calculate the lowest Savings figure for each customer. [1 mark] 10. Format all figures above to currency and to two places of decimal. [2 marks] 11. For each of the Customers in the column Interest/No Interest you are going to insert a function that will place "Interest if the Total Savings of the Customer is greater than or equal to 150,000 and "No Interest" if the Total Savings is less than 150,000. [5 marks]