Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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! image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditory Interfaces

Authors: Stefania Serafin, Bill Buxton, Bill Gaver, Sara Bly

1st Edition

1032196459, 978-1032196459

More Books

Students also viewed these Accounting questions

Question

Methods of Delivery Guidelines for

Answered: 1 week ago