s question has been opened in a new tab. In order to continue your assignment, please save your Excel question. Stanford Enterprises has provided its manufacturing estimated and actual data for the year end. The Controlier has asked you to compute the predetermined overhead rate, the schedule of cost of goods manufactured, and the schedule of cost of goods sold. Here are some tips for using Excel: - Cell Reference; Allows you to refer to data from another cell in the worksheet. If you entered " =85 " into a blank cell, the formula would output the value from cell 85. - Basic Math Functions: Allow you to use the basic math symbols to perform mathematical functions, You con use the following keys: + (plus sign to add), - (minus sign to subtract). (asterisk sign to multiply), and / (forward slash to divide), For examplo, if you entered - B4+85" in a biank cell, the formula would add the values from those cells and output the result. - sum Functioni Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges. If you. entered "-SUM(C4,C5.C6)" into a blank cell, the formula would output the result of adding those three separate cells. Similarly, If you entered "-SUM(C4.C6)", the formula would output the same result of adding those cells. 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Fer an arrwer to be graded es correct, you mut use an Excel formula: 1. Begin eoch formels with an = sign. 2. Aluference colls, intsoad of entering values. Example; - e3 4 C3 L. McGram Hill Check Answers Legend neoded. Sstmetcac Upe as a nan-praced worksice Mquer: Required: Use the data to fill in the following information. (Use cells D6 to C18 from the elven information to complete this question. If overhead is overapplied, your answer should be displayed as a regatve value. All antwers should be input and dioplayed as posiove values) Use cells 86 to C18 from the ghen information to complete this question. If overhead is overapplied, your answer should be displawed as a negative value. All answers should be input and displayed as positive values.) 2. Prepare a schedule of cost of goods macufactured: (Use cells B to C18 from the glven information to complete this question. All answers should be input and dsplyyed as positive values.) 3. Prepare a schedue of cost of goods sold. Check Answe Legend Graded ceit: needed (Use cells 86 to C18 from the civen information to complete tha quetrion, If ovethead is oweropolied, wour anwer should be displayed as a negative value. All answers sheuld be input and displayed as positive values)