choose Check for Updates. Office Update To keep up-to-date with security updates, foxes, and x Receivables and Revenue vables and Revenue Evaluate liquldity using the quick [acid-test) ratlo and days' sales in recelvabler Northern Products reported the following amounts in its 2019 financial statements. The 2018 amounts are given for comparison 019 2018 Current assets: $9,500 $9,500 7,000 Short-term investments Accounts receivable 70,100 Less: Allowance for uncollectibles Inventory Prepaid insurance Total current assets 7,500)79,000 (S,500) 64,600 189,000 2,200 290,200 99,000 2,200 273,300 106,000 734,000 Total current liabilities Net sales (all on account) Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references where be marked wrong and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will Requirements Compute Northern's quick (acid-test) ratio at the end of 2019. How does the quick ratio compare with the industry average of 0.927 2Calculate the days' sales outstanding for 2019 and compare it with the company's credit a. Use the Excel ROUNDUPO function to find the DSO value. Round to the next whole number b Use a 365-day year for calculations as needed Saving &Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS b. Save your solution in the folder you just created; add-solution-date to end of file name 2 Upload and submit your file to be graded a Navigat 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 te back to the activity window-screen where you downloaded the initial spreadsh INSTRUCTIONS ENTERANSWERS +