Recording Cash Sales; Cash Over The actual cash received from the day's cash sales was $9,755, and the amount indicated by the cash register total was $9,655. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. What is the amount deposited in the bank for the day's sales? 4 b. What is the amount recorded for the day's sales? c. How should the difference be recorded? of $ should be recorded as d. If a cashier is consistently over or short, what action should be taken? The following data is available: REQUIRED: a. What is the amount deposited in the bank for the day's sales? b. What is the amount recorded for the day's sales? c. Calculate the difference between the amount deposited and the amount recorded. Using formulas and cell references from the problem data, perform the required analysis. Enter cash shortage, if any, as a negative value. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWv2 for grading