Using Excel to Determine Ending Inventory Student Work Area Required: Provide input into cells shaded in yellow in this template. Use a cell references and In its first month of operations, McLanie Company made three mathematical formulas for calculations. purchases of merchandise in the following sequence: Using Excel to Determine Ending Inventory Student Work Area Required: Provide input into cells shaded in yellow in this template. Use a cell references and In its first month of operations, McLanie Company made three mathematical formulas for calculations. purchases of merchandise in the following sequence