The table below shows term deposit interest rates offered by five banks. Please answer the following questions: (a) Limit the entries to the 7 terms (i.e., 1 month - 24 months) (1 mark). (b) Use functions to work out the highest interest rate for the term selected in part (a) (2 marks). (c ions to work out which bank is offering this rate (2 marks).( use excel. And display the formula and calculation process)

Bank 1 month 3 months 18 months 24 months 3.60% 4.03% Bank A Bank B Term Deposit Interest Rates 6 months 9 months 12 months 3.85% 3.95% 4.05% 3.80% 3.80% 3.95% 3.85% 3.85% 4.00% 4.25% 3.70% 3.70% 3.75% 3.70% 3.92% 4.10% Bank C 3.50% 4.10% 4.15% Bank D 3.60% 3.80% 3.85% 3.90% 4.00% 4.05% 4.10% 3.55% 3.65% 3.90% 3.90% 3.95% 3.95% 4.15% Bank E ) Use funct Bank 1 month 3 months 18 months 24 months 3.60% 4.03% Bank A Bank B Term Deposit Interest Rates 6 months 9 months 12 months 3.85% 3.95% 4.05% 3.80% 3.80% 3.95% 3.85% 3.85% 4.00% 4.25% 3.70% 3.70% 3.75% 3.70% 3.92% 4.10% Bank C 3.50% 4.10% 4.15% Bank D 3.60% 3.80% 3.85% 3.90% 4.00% 4.05% 4.10% 3.55% 3.65% 3.90% 3.90% 3.95% 3.95% 4.15% Bank E ) Use funct