I need assistance inserting the correct formula into the excel sheet for each box.

AutoSave OFF BES 5 = Chapter 16 Homework Question Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Liberation Sans Insert v V . 12 ab Wrap Text Custom V Av WE 48- 0 Ou 3 DX Delete v Paste V Av 3 Merge & Centre C%) .00 00 20 Conditional Format Formatting as Table Cell Styles Format Sort & Filter v Find & Select Sensitivity Analyse Data Check for Updates B G 1 K L M N 0 Q R S s T U v w 17 19 Office Update To keep up to date with security updates, fixes and improvements, choose Check for Updates. H14 4 x fc =C9*100% A DE F H 1 Functions: SUM; Formula: Multiply; Cell Referencing 2 3 Using Excel to Compute Equivalent Units Student Work Area 4 PROBLEM Required: Provide input into cells shaded in yellow in this template. Use 5 The Smelting Department of Kiner Company has the following production mathematical formulas with cell references to the Problem area. Use the 6 data for November. SUM function with cell references for the totals. 7 8 Units in beginning work in process 2,000 9 Units transferred out 9,000 Compute the equivalent units of production for (a) materials and (b) 10 Units in ending work in process 7,000 conversion costs for the month of November 11 12 Percentage complete, beginning work in process Conversion 13 Materials 100% Materials Costs 14 Conversion costs 20% Units transferred out 9,000 7,000 15 Percentage complete, ending work in process 16 Materials 100% Work in process, November 30 Conversion costs 40% Materials 18 Conversion costs 20 21 Total equivalent units 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Enter Answer + E Ready a + 90%