excel assignment

1. Open the House workbook located in the ExcelB ▸ Case2 folder included with your Data Files, and then save the workbook as Tea House in the location specified by your instructor.

2. In the Documentation worksheet, enter your name and the date.

3. Make a copy of the Orders worksheet, and then rename the copied worksheet as March. In the March worksheet, use advanced filtering to display all sales in March in Sweden and all sales for Janet Leverling.

4. Make a copy of the Orders worksheet, and then rename the copied worksheet as Sept. In the Sept worksheet, use advanced filtering to display all records for Laura Callahan with sales greater than $1,500 in September.

5. In the Summary worksheet, complete the summary analysis for France. Use the DAVERAGE and DSUM functions to enter formulas in row 11 to average and sum the orders in March for France. Format the range B11:C11 with the Accounting format and no decimal places. Set up an appropriate criteria range in rows 1 and 2.

6. In the Summary worksheet, complete the summary analysis for the United Kingdom (UK). Use the AVERAGEIFS and SUMIFS functions to enter formulas in row 12 to average and sum the orders in March in the U.K. Format the range B12:C12 with the Accounting format and no decimal places.

7. Save the workbook, and then close it.