Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Excel_4F_Sports_Equipment Preject Description: in the project you ail import Acosas tabiss inta a Data Model with informason rogarding sports equipment purchwes You wil treate a

image text in transcribed
image text in transcribed
Excel_4F_Sports_Equipment Preject Description: in the project you ail import Acosas tabiss inta a Data Model with informason rogarding sports equipment purchwes You wil treate a Fiver fable and FhotChart tom se inported dath. Steps to Perform: Rows area, and the Yoar Ordered field to the Rows area bolow ltom. Add the Cuarkty field to the Values area Change the Number Famat to Number, change the Decimal places to 0 , and then select the Use 1000 Separator () chock box. Insert a 3.D Pie PivotChart and then move the chart to a New sheet and name the new sheet Equipment Chart. Display the Field List and then modity the chart so that only the Supplier feld displays in the Axis (Categories) area. Remove any fields that display in the Legend (Series) area. Apply Style 3 to the chart. Remove the Legond and add the Category Name and Percentage Data Labels, Change the chart bibe to Sports Equipment Purchases and then change the font size to 24 . Insart a focter with the fie name in the left section of the footer. Display the Sports Equipment shoet. Insert a footer in the left section that includes the file name, and then center the worksheet Horizontally on the page. Display the file Properties. As the Tags, type sports equipment and as the Subject, type your course name and soction number. Under Related People, be sure that your name displays as Auther, 12. Save and close the file, and then submit for grading

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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