https://1drv.ms/x/s!Ajz1egTFoa8gdkykklqEc58Ex-M?e=BB74Hs&nav=MTVfe0MyOTg2OTRGLTgxMDYtNDQ3Mi1BRDdDLUNGMjM0NkE1RjRDMn0

Company A sells the same product in each of the 50 states in the U.S. The Data worksheet contains a list of states with select balance sheet amounts for each of three years. Each row provides information about one state in one year, including its region and amounts for its four current assets and one current liability. Required: Open spreadsheet Complete two columns on the Data worksheet: Working capita! and Current retro. R1. Cell 12: Enter a formula that results in the working capital amount using the data in row 2. R2. Cell K2: Enter a formula that results in the current ratio using the data in row 2. (Round the current ratio to one decimal place.) :1 R3. Copy down the entries in cells 12 and K2 to all other rows with data. Steps to create a pivot table: 51. Select a cell in the data on the Data worksheet. 52. Select Insert ,l PivotTable. The data range will automatically be inserted. A "Create PivotTable" window should appear. 53. In the window, under "Choose where you want the PivotTalJle report to be placed," select "New Worksheet." A new worksheet should appear with the PivotTalJle. S4. A PivotTable Field List should pop up. Drag elds into rows, colurnns, lters, and values areas as needed. (If this gray work box does not appear, right click in the pivot table and select "Show Field List.\"] Questions: Use the information on the Data worksheet and pivot tables, formulas, andfor functions to answer the following questions. Q1. By what amount is the combined working capital amount of Georgia and North Dakota in 2023 greater than the combined amount in 2022? U Q2. What is the average current ratio in 2021 forthe region{s] with the highest average current ratio? [Round the current ratio to one decimal place.) U Q3. How many of the following states had a current ratio above the industry average of 2.5 in 2022: Illinois, Michigan, South Carolina, and Wisconsin? U Q4. What is Company.r A's overall current ratio for all 50 states combined in 2023'? (Round the current ratio to one decimal place.) Q5. Which of the following statements about current position measures is NOT accurate? A state's working capital could be a negative dollar amount A state's current ratio of .3 indicates that current assets are not sufcie nt to cover current liabilities. The state with the highest working capital amount will always be the state with the highest current ratio. O O O O An increase in a state's current ratio from 1.3 to 1.5 from one year to the next is considered a positive trend