the jurrasic era

Task 1
You have decided to open a Savings Account.
You will pay £120 per year into this account.
Your bank has two different saving schemes:
· Account A pays a yearly interest of 5% of the account balance at the end of the previous year.
· Account B pays you an additional 50% of your yearly deposit, every year.

1. Create the calculations needed to fill the Account Balance fields automatically (Cells B3-B32 & C3-C32) (10 marks)
2. Use an IF Function to display the account that performs better for each Year (Cells D3-D32) (10 marks)
3. Apply Conditional Formatting to highlight which accounts performs better (Cells D3-D32) (10 marks)
4. Draw a line ...