.

Applying price rates - Use conditional formats. - Use functions. - Create formulas that use ranges and functions. EXERCISE: Moola Bank offers clients savings and charge (credit) accounts with the following interest rates depending on the daily balances of those accounts: Interest rates according to account balances: After including that table in a duly named worksheet, you have to create a new worksheet called "Interest rates" where you have to calculate the daily interest rates earned for each of company A's accounts. 1. Determine each account's table column based on the type of account (savings or charge account). 2. Calculate the interest rate based on the previous column and on the account balance. 3. Calculate the daily earned interest for each acoount, bearing in mind that the interest rate detailed in the table is the annual rate. After including that table in a duly named worksheet, you have to create a new worksheet called "Interest rates" where you have to calculate the daily interest rates earned for each of company A's accounts. 1. Determine each account's table column based on the type of account (savings or charge account). 2. Calculate the interest rate based on the previous column and on the account balance. 3. Calculate the daily earned interest for each account, bearing in mind that the interest rate detailed in the table is the annual rate. GSI: Business \& Excel Solutions Intermediate 2022-2023 academic year