Select the worksheet Transactions. 29. Add suitable formatting for the title in cell A1. 30. Add a Transaction number in column E for each transaction, starting with T0001, T0002, T0003, etc. 31. Insert a new column in between column D and E. Label it Country Name in row 3. 32. In the new Column E, for each of rows 4 and higher, get the country name using the VLOOKUP function to the table on worksheet Country Codes. 33. In column I, label it Currency Name in row 3. 34. For any error values in column E, display Not found. 35. In Column I, for each of rows 4 and higher, get the currency name using the VLOOKUP function to the table on worksheet Currency Codes. 36. For any error values in column I, display Not found. 37. Add suitable borders for the table. 38. Add suitable heading formating for the table. 39. Add conditional formatting to highlight when the amount is 100.00 or greater. 40. In cell B47, enter the text TOTAL. In the Amount column row 47, calculate the sum of the amounts. 41. In cell B49, enter the text MINIMUM. In the Amount column row 49, calculate the minimum of the amounts. 42. In cell B50, enter the text MAXIMUM. In the Amount column row 50, calculate the maximum of the amounts. 43. In cell B51, enter the text AVERAGE. In the Amount column row 51, calculate the average of the amounts. 44. In cell B52, enter the text MEDIAN. In the Amount column row 52, calculate the median of the amounts. 45. In cell B54, enter the text MOST. In the Store Country and Currency Code columns, calculate the most common values in each of those columns using the MODE.SNGL function. Pures College of Technology 200 & 300 - 1450 Midland Avenue Toronto, ON M1P 4Z8 Tel: 416-498-5558 PURES COLLEGE OF TECHNOLOGY 46. Insert a new column to the right of the Amount Column. Use the Quick Analysis tool to create a running total of the amounts into the new column. 47. Save the workbook.