Journalise the following transactions: a) shyam became insolvent. a first and final compensation of 75 paise in a rupee was received from his official. he owed a debt of 50,000. b) received cash 25,000 for a bad debt written of last year. c) rent due to landlord 40,000. d) depreciation on office furniture 5000. e) salaries due to staff 50,000. f) paid income tax 1,50,000. g) received commission 25,000 half of which is in advance.

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding