PLEASE INCLUDE THE CELL REFERENCES AND FORMULAS TO ENTER FOR THE ABSWERS BECAUSE I DO NOT INDERSTAND HOW TO USE EXCEL

12 The company's collection history indicates that credit sales are collected as follows: 30% in the month of the sale 60% in the month after the sale 8% two months after the sale 2% are never collected Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong. covery following files Save ep. a v3 (1) xhx. dint sone the im A, vister ior. flais time the MM cos(1)dx tiant sime the IBM t las ame the Fis av2 abisx diat trine the 1Au tsherty Bifin. t to sarve? A B C D F G H E 21 Requirements 1 Prepare a sales budget for all four months, showing the breakdown between cash and credit sales. 2 Prepare a cash collections budget for December and January. a. Use cell references from the prior requirement, if applicable. For help completing the requirements, watch the video walk through. Saving \& Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCELPROJECTS 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open c. Click Upload button under step 3 d. Click Submit button under step 4 Viewing Results 1. Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link; this will bring up your Score Summary 4 Within Srore Summarv window. click on Downinad funner riphti to download the snreadsheet with feed lecovery 5 me the lollowing tin. hewp. 2.43a 83(1) who. undal bime se. 210MM Hak vinkis or that2 (1) ale: andleither in ty arfe 54 ist A3aive Rixcta waind laitintithe 1414M inatsieny durfo 1. 1. Prepare a sales budget for all four months, showing the breakdown between cash and credit sales. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab 2 or if you type the numbers in, you will be marked wrong.) 2. Prepare a cash collections budget for December and lanuary. (Always use cell references and formulas where appropriate to receive full credit. If vou copy/paste from the instructions tab 1) or if you type the numbers in, you will be marked wrong. Uie cell references from the prior requirement, if applicable.) Recovery the following fles. Sarve o kecp. 6.43ay3(1)x sex. subed last time the 544avalse 10rin catnd lint time the 1.3a-w2 (1)alus. and last mon the. p. iftesi 2 st Arefluintime the: 1. Bat 42 (2) x ts x. whiliut time the tsikn: Huntsbeny HT. A. B C D. E F. G H 14 Iyou mine iterererices Irom tor A 1222222 27 28 29 30 31 32 33 34 35