t Creating a Worksheet and Charting Data Michelle Barry, President of Pro Fit Marietta, needs a worksheet that summarizes the following data regarding the first quarter sales of training videos. Michelle would like the worksheet to include a calculation of the total sales for each type of video and a total of the sales of all of the videos. She would also like to know each type of video's percentage of total sales. Number Sold Price Pilates 156 29.99 Step 392 14.99 Weight Training 147 54.99 Kickboxing 282 29.99 Yoga 165 34.99 Create a worksheet that provides Michelle with the information needed. Include appropriate worksheet, column, and row titles. Using the formatting skills that you practiced in this chapter format the worksheet in a manner that is professional and easy to read and understand. Insert footer with the file name and add appropriate document properties. Save the file as Lastest 11