Be Sure to Mark answers on scantron ences: You will perform the role of the Excel spreadsheet application ollowing the expressions shown in the second table below. Follow these written instructions and answer questions Q.50-Q.56 on scantron only plified cost and pricing worksheet below is to show in column A: Show typical Cost of Goods for merchandise purchased for resale In column B: To Use a standard percent markup to set a Sales Price (Percent shown in top assumption cell In column C: Show the Markup amount (increased amount over COG) In column D: Show the Net Margin (amount of sales revenue remaining after subtracting CoG) Below, the first row is Row 1 with label "Worksheet", and first numeric data of 400 is entered into cell AS. Worksheet Percent Column A Column B COG (from Sales price 0.15 Column Markup C Column D vendor) (COG+Markup) amount Net Margin 460 345 230 115 400 300 200 100 60 60 To answer the questions on the following page use the formulas in the figure below, as created by a new employee. 1 Test 2- Revision 2 Bu2so Fall 2015 2 Percent 3 Column A 0.15 Column B Sales price Column C Column D 4 COG (from vendor) (COG+Markup) Markup amount Net Margin 5 400 6 300 7 200 8 100 AS+S852) A5B2 =A5"B2