please solve using excel and use =formtext to show solutions and include steps.

4. A bank offers different yearly interest rates to its customers based on the size of the deposit in the following way: - For deposits up to 1,000 , the interest rate is 5.5% - For deposits from 1,000 and up to 10,000 , the interest rate is 6.3% - For deposits from 10,000 and up to 100,000 , the interest rate is 7.3% - For all other deposits the interest rate is 7.8% Implement the function Interest(Deposit) in VBA. Note that you can use the BlockIf structure