Function: AVERAGE; Formula: Divide; Cell Referencing Some cells are merged. Using Excel to Assess Accounts Receivable Student Work AreaPROBLEM Required: Provide input into cells shaded in yellow in this template. Use the AVERAGE function with cell references in calculating the turnover. Use cell references with mathematical formulas to calculate the average collection period.The 2022 financial statements of 3M Company reported the following amounts. Net sales $ 23.1 billion Accounts receivable, net Compute 3Ms accounts receivable turnover and the average collection period in days. Beginning of year 3.20 billion End of year 3.25 billion Accounts receivable turnover 4.79