Question: Can someone help me with this excel sheet? I need to create a pie diagram based of that data given. Also coupd you please include

File Home Insert Draw Page Layout Formulas Review View Help PROTECTED VIEW Be careful-Files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enat A1 fx Premiere Movie Source B D E G H Premiere Movie Source April 2021 Data WN 4 Genre 5. Action & Adventure 6 Comedy 7 Drama 8 Horror 9 Sci-Fi & Fantasy 10 Other Genres 11 Weekly Totals 12 13 14 15 Week 1 2,105 1,800 1,645 1,206 1,795 1,001 9,552 Week 2 1,985 1,805 1,503 1,121 1,845 945 9,204 Week 3 2,241 2,045 1,475 945 1,765 948 9,419 Week 4 2,424 1,945 1,304 917 1,695 Category Totals 8,755 7,595 5,927 4,189 7,100 3,883 % of Month Summary 23.4% 20.3% 15.8% 11.2% 19.0% 10.4% 100.0% 989 9,274 37,449 16 17 18 19 Exp19_Excel_Cho3_CapAssessment_Movies Project Description: You are an assistant manager at Premiere Movie Source, an online company that enables customers to download movies for workbook. You are ready to create charts to help represent the data so that you can make a presentation to your manager a fee. You need to track movie download sales by genre. You gathered the data for April 2021 and organized it in an Excel later this week, Steps to Perform: Step Points Possible Instructions 1 0 2 6 3 5 Start Excel. Download and open the file named Exp19_Excel_Cho3_Cap Assessment_Movies.xlsx Grader has automatically added your last name to the beginning of the filename. You want to create a pie chart to show the percentage each category contributes to the monthly movie downloads Select the ranges A5:A10 and F5:F10. Create a pie chart and move it to a chart sheet named April Pie Chart The chart needs a descriptive title that is easy to read Type April 2021 Downloads by Genre as the chart title, apply bold, 18 pt font size, and Black, Text 1 font color. Percentage and category data labels will provide identification information for the ple chart Add category and percentage data labels in the inside End position. Remove value data labels and the legend. Apply 14 pt font size and Black, Text 1 font color. You want to focus on the comedy movies by exploding it and changing its fill color, Explode the Comedy slice by 7% and apply Dark Red fill color 5 assing Catagory 4 5 2 6 A best practice is to include Alt Text for accessibility compliance Add Alt Text: The pie chart shows percentage of downloads by genre for April 2021. (including the period)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
