The following information pertains to lance company.1. cash balance per bank, july 31, $7,328. 2. july bank service charge not recorded by the depositor $38. 3. cash balance per books, july 31, $7,364. 4. deposits in transit, july 31, $2,700. 5. $2,016 collected for lance company in july by the bank through electronic funds transfer. the collection has not been recorded by lance company. 6. outstanding checks, july 31, $686.1- prepare a bank reconciliation at july 31, 20172- journalize the adjusting entries at july 31 in the books of lance company

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