Question 2. Khalid is running a flower shop since last five years successfully. He has five employees like two salesmen, one cleaner, one shop manager and one accountant. Business growing continuously and expending, so he has opened some more shops in other cities. Due to too much load in accountant department, he decided to do some task himself like to be maintaining cash book, bank dealing and other cash related issues. Ali is commerce graduate, but he is not good in MS. Excel, being a friend you decided to teach him how to maintain three column cash books in MS. Excel The records for the month of April 2020 transactions are as mentioned below 2020 April. 1. Cash in hand OMR. 19,710 and balance at bank OMR. 8,500 (OD) 3. Paid into bank OMR. 9,000. 5. Bought goods for OMR. 1,800 paid cheque. 8. Sold goods to M/S Muhammed for cash OMR. 250. 9. Received a cheque from Shah to whom goods were sold for OMR. 1800. Discount allowed 12.5% 9. Purchased a used printer for OMR. 150. Spent OMR. 25 on its repair. 11. Bank notified that Shah's cheque has been returned dishonored and debited to the accoun In respect of charges OMR. 10. 11. Issued a cheque for OMR 5,500 to ABC LLC in full settlement of his account OMR 5,550. 12. Withdrew from bank OMR. 950. 16. Withdrew for personal use OMR. 850. 18. Paid office expenses OMR. 1,000. 20. Purchased machinery from XYZ LLC for OMR. 9,000 and paid 40% by cheque and balance paid within two months. 21. Purchased goods of OMR 10,000 from Khan LLC on credit and OMR 3,000 from CDC LLC on cash. 23. Received a cheque OMR 3,450 from Nadeem Traders in full settlement of his account of OMR 3,500, paid into bank the same day. 25. Interest credited by the bank in our account RO 650 27. Paid advertisement expense OMR.100 by cheque. 30. Paid rent to landlord "Salim' by a cheque of OMR. 750. Required:- Prepare three columns cash book for the month using MS Excel. (10 Marks)