Question: Excel Problem. Please do problem in excel. Thank you! Insert a formula to calculate value as quantity times price in cell I9, then filldown this

Excel Problem. Please do problem in excel.
Thank you!  Excel Problem. Please do problem in excel. Thank you! Insert a
formula to calculate value as quantity times price in cell I9, then
filldown this formula for all cells in the table. Insert a text
label "Total" in cell H28 and a formula to calculate the total
value in cell I28. Insert two additional rows after row 26. Add

Insert a formula to calculate value as quantity times price in cell I9, then filldown this formula for all cells in the table. Insert a text label "Total" in cell H28 and a formula to calculate the total value in cell I28. Insert two additional rows after row 26. Add two American Syrah wines in those two rows: Carhatt, $34 (750 ml, year 2014, SKU 16769), quantity 10 ; and Cafaro, $35 (750 ml, year 2014, SKU 16874), quantity 15. Delete the row containing the American Merlot from Wildhorse. Change the formatting of the Price and Value columns to include no decimals. After using Excel's Help function to learn how to sort items in a worksheet, sort the information on your worksheet by location, by type, and then by winery, in A to Z order. Change the name of Sheet1 to "Pricing." Create a copy of this worksheet and place it before Sheet2, then change the name of this sheet to "Cost." Add a label at cell C4 of the Cost sheet called "Cost \%" in Bold, Italics. Type 60% as the cost percentage in cell D4 of the Cost sheet. (Make sure this cell is formatted as a percent.) Change the name of the column "Value" to "Cost." Create a new formula in cell I9 to calculate cost as Price times Cost \% times Quantity. (Be sure to use absolute or relative references where appropriate.) Fill the formula in cell I9 down to all items. Save the file as ch2-06_student_name (replacing student_name with your name)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!