The following questions are based on Figure 7 below: в 1 Names of Current Account Balance Fixed Deposit Outcome Customers Balance 2 RM YES/NO 12,000 20,000 9,000 30,000 RM 120,000 100,000 155,000...

Extracted text: The following questions are based on Figure 7 below: в 1 Names of Current Account Balance Fixed Deposit Outcome Customers Balance 2 RM YES/NO 12,000 20,000 9,000 30,000 RM 120,000 100,000 155,000 90,000 Khairie 4 Halim Amirul Asrul 5 6 Figure 7 Required: а. The following independent situations are available: i. Bank Usahawan Malaysia Berhad will approve loan applications to its customer who has a Current Account balance of RM10,000 or more; and a Fixed Deposit Account balance of RM100,000 or more. Determine the formula in cell D3. If the bank changes the policy for the loan approval; where a customer will be given a loan if he has a Current Account balance of RM15,000 or more; or a Fixed Deposit Account balance of more than RM120,000. Determine the new formula in cell D3. ii. Identify the names of customers whose loan applications are NOT approved as in situation (i) and (ii) above. b. Define AND and OR Function. C.