"Function: AVERAGE; Formula: Divide; Cell Referencing" Some cells are merged. Using Excel to Assess Accounts Receivable Student Work Area PROBLEM 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 3M's 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 Average collection period

Function: AVERAGE; Formula: Divide; Cell Referencing Using Excel to Assess Accounts Recelvable Student Work Area PROBLEM 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 Gompany reported the following amounts. Net sales $ 23.1. billion Accounts receivable, net Compute 3M's accounts receivable turnover and the average collection Beginning of year 3.20 billion period in days. End of year 3.25 billion Accounts receivable turnover x 7 Average collection period