Question: Please anyone ! i am stuck on question 8 ! 7. Create a pie PivotChart from the PivotTable. a. Display the data labels using the

Please anyone !

i am stuck on question 8 !

7. Create a pie PivotChart from the PivotTable. a. Display the data labels using the Inside End option. b. Hide the chart title. 8. On the Data Table worksheet, create a one-variable data table to determine the amount of money that would be raised if 150 DVD s were sold at the various prices listed. Review the formula in cell C7 to identif the appropriate cell to use as the input cell for the data table. 9. How many DVDs would the library need to sell at $1.50 each to raise $500 ? Use Goal Seek to find a for cell F9 that will result in a value of 500 for cell 10. Save and close the workbook. File Horne insert pagelayout formulas Data Review View Help outa type senx fros Ge a translam Data Cueies s Connedions 87 12 1 Initial Estimate Price per DVD 4 5 6 8 16 10 20 21 2120 22 23 24 - 150.00 50.75 51.00 Format Shape Comments E

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!

1. On the Documentation sheet, do the following: a) Enter your name in cell B3. b) Make your name link to your email address. c) Add a screenTip that says Please email me with questions d) Use an...

pls help with explanation!! inportant. Download the resource files needed for this project from the Resources link. If the files download in a zipped folder, lake sure to extract the files after...

Can someone please help me with this? In this project, you will work with sales data from Topt Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will...

3. Copy the OldTownStore worksheet from the OldTownSales workbook (downloaded from the Resources link) to the capstone project. a. Open the Excel file OldTownSales. b. Copy the worksheet...

Steps to complete this project: Important : Download the resource files needed for this project from the Resources link. If the files download in a zipped folder, make sure to extract the files after...

Open the start file EX2019-Capstone-Level3 . Note: If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the worksheet so you can modify it The...

please help 2.1f the workbok opens in Protected View, click the Enable Editing button in the Message Ear at the top of the workbook so you can modify the workbook 3. Convert the shoe sales data in...

help with questions 7-13 please 7. Add a slicer to the table so you can filter by shoe name. Use the slicer to display data for the Sperry shoe only. Notice the effect on the chart. 8. Create a...

BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67...

P L U G - I N T3 Problem Solving Using Excel 2010 LEARN IN G OUT C O ME S 1. 2. 3. 4. 5. Describe how to create and sort a list using Excel. Explain why you would use conditional formatting using...

An engineer tests a new magnetic flux sensor consisting of a two-dimensional square membrane, 3.50 cm on each side. The sensor measures the magnetic flux through the membrane. The engineer places the...

In Exercises 1-3, identify the quadric with the given equation and give its equation in standard form. 1. 4x2 + 4y2 + 4z2 + 4xy + 4xz + 4yz = 8 2. x2 + y2 + z2 - 4yz = 1 3. -x2 - y2 - z2 + 4xy + 4xz...

if the yield curve is inverted, which of the following is true? investors expect future short terms rates to decrease the economy is exected to grow rapidly long terms bonds have lower interest rate...

Wan Yu Tang purchased a cell phone plan from Endless Journey Wireless. His first monthly invoice for service totaled $65, which included a $15 roaming charge.Without understanding the meaning of a...

You are the owner of Jimmys Electric, a small electrical construction company. Because of reduction of building in the area, it is necessary that you terminate Milton Youngs employment. He is an...

Wallenda Jorgenson is in the real estate market to buy a home. She has been attending open houses on her own and has found a house that she wants to buy. She has asked Daniel Thompson,a real estate...