\\begin{tabular}{|l|l|l|l|} \\hline \\multicolumn{1}{|c|}{ A } & C & E \\\\ \\hline \\end{tabular} Download \"Customer.xlsx\" file and do the following tasks. Upload the file to Submissions menu in D2L. (a) Create a Pivot Table worksheet that shows \"Rent vs Own\" (horizontal) by \"Region\" (vertical). In the Value part of pivot table, show \"Count of Customers ID\", \"Sum of Total Purchases\" and \"Sum of Num Purchases\". (b) In the Customer data worksheet, use SUMIF result in cell H4 to show Sum of Total Purchases amount (\\$) who Own the house. (c) In the Customer data worksheet, use AVERAGEIF result in cell H5 to show Average of Total Purchases amount (\\$) whose Num Household is 4. (d) In the Customer data worksheet, use COUNTIF result in cell \\( \\mathrm{H} 6 \\) to show Count Number who has more than 4 Household. (e) In the NPV worksheet, calculate the following NPV using Excel financial function and with five interest rates \(5 when you have \\( \\$ 17,000 \\) as initial cost of investment one year from today and return from first year \\( (\\$ 6,000) \\), second year \\( (\\$ 7,000) \\), and third year \\( (\\$ 8,000) \\). (f) In Solver worksheet, complete \"Pony Espresso\" with maximum total revenue. (g) In Scenario worksheet, complete \"Project\" as requested in the Tech Plug-In and show \"Summary\" worksheet