Yolanda Robertson, your manager at NuTrends Market Research, has been pleased with your previous work and has assigned you to a project with a new client. Yolanda is preparing a marketing plan for a franchise expansion for the owners of Pizza By Mario. The franchise was started in Michigan and has stores in Ohio, Wisconsin, and lowa. The owners plan to double the number of locations within the next two years by expanding into neighboring states. The owners have provided a confidential franchise sales report to Yolanda in an Excel file named PBMSales.xlsx. Yolanda needs your help with Excel to extract some statistics and calculate franchise royalty payments. With this information, Yolanda will develop a franchise communication package for prospective franchisees. Open the workbook and save it with the name 2-PBMSales. Yolanda has asked for the following statistics and wants you to read the instructions found on the next page before you begin. - A count of the number of stores with sales greater than 500,000 - A count of the number of stores located in Michigan with sales greater than 500,000 - Average sales for the stores in Detroit, Michigan - Average sales for the Michigan stores established prior to 2006 - Total sales for the stores established prior to 2014 - Total sales for the Michigan stores established prior to 2014 Create the formulas for Yolanda in rows 3 to 16 of columns H and I. Create range names for the data so Yolanda will be able to easily understand the formula when she reviews the worksheet. You determine the layout, labels, and other formats for the statistics section. The royalty rate and fee will be completed in Part 2. Save the workbook