Please help fix the problems in red

Current position analysis PepsiCo, Inc. (PEP), the parent company of Frito Lay snack foods and Pepsi beverages, had the following current assets and current liabilities at the end of two recent years: Current Year Previous Year (in millions) (in millions) Cash and cash equivalents $21,834 $12,650 Short-term investments, at cost 7,969 3,157 Accounts and notes receivable, net 7,709 8,137 Inventories 3,353 3,339 Prepaid expenses and other current assets 1,530 1,812 Short-term obligations 7,054 3,895 Accounts payable 14,576 12,923 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. Determine the (1) current ratio and (2) quick ratio for both years. Round your answers to one decimal place Current Year Previous Year 1. Current ratio 3.4 X 2.6 X 2. Quick ratio 2.8 X 2.1 X Current position analysis PepsiCo, Inc. (PEP), the parent company of Frito-Lay snack foods and Pepsi beverages, had the following current assets and current iabilities at the end of two recent years: Cash and cash equivalents Short-term investments, at cost Accounts and notes receivable, net Inventories Prepaid expenses and other current assets Short-term obligations Accounts payable Current Year (in Previous Year millions) (in millions) $21,834 $12,650 7,969 3,157 7,709 8,137 3,353 3,339 1,530 1,812 7,054 3,895 14,576 12,923 Using formulas and cell references, pertorm the required analysis, and input your answers into the current Year and Previous Year columns respectively. Transfer the numeric results for the green entry cells (C16:017) into the appropriate fields in CNOWV2 for gradina a 5 7 3 1. Current ratio 2. Quick ratio Current Year 3.4 28 Previous Year Formulas 20 SUM(CSC10YSUM(C11 C12) SUMDS DOVSUMD11 D12) 2.1 SUMO5.CRYSUMCAT.C12) SUMDE DEYSUMD11 D12)