際際滷

際際滷Share a Scribd company logo

Case Problem: Cooking.xlsx

V
ViscKand

Ulan Michim started a company called Healthy Cooking two years ago to provide prepared meals to retailers and businesses. Lien uses Excel to track customer orders and wants to analyze order data from the first half of the year. The document provides instructions to complete various tasks in an Excel workbook, including filtering orders by amount, formatting tables, sorting data, conditional formatting, filtering with a total row, and including subtotals.

1 of 2
Download to read offline
Buy here: http://homeworknumber.one/products.php?product=Cas e-Problem%3A-Cooking.xlsx Data File needed for this Case Problem: Cooking.xlsx Healthy Cooking Ulan Michim started Healthy Cooking two years ago to provide prepared gourmet meals to retail food stores, living facilities for seniors, and businesses. Lien tracks orders using Excel. She has entered customer order data for the first half of the year in a worksheet, and wants to analyze the data in several ways. Complete the following: 1. Open the Cooking workbook located in the Excels? Case3 folder included with your Data Ales, and then save the workbook as Healthy Cooking. 2. In the Documentation sheet, enter your name and the date. 3. Lien wants to view invoices with order amounts that are either less than $100 or greater than $5000. She tried filtering the orders in the Order Amount Filter worksheet, but is not working as expected. Review the Order Amount Alter worksheet and to the problem. 4. In the Orders worksheet, create an Excel table, and then rename the table as CustOrders. 5. In the CustOrders table, format the Order Amount, Discount, and Net Amount columns so that it is clear that these fields contain dollars. 6. Format the CustOrders table using the table style of your choice.
7. Make a copy of the Orders worksheet, and then rename the copied worksheet as Sort. (Hint: Press the Ctrl key and drag the sheet tab to the right of the current sheet .b to make a copy of the worksheet.) On the Sort worksheet, son the data in ascending order by Customer Type, then in ascending order by Delivered To, and then in ascending order by Customer. 8. Using conditional formatting, highlight all orders in he sorted table that have a Net Amount greater than $4000 in the format of your choice. 9. Make a copy of the Orders worksheet, and then rename the copied worksheet as Filter with Total Row. Filter the CustOrdem table to display all orders with an order date in June 2016 that included a discount. 10. Insert a Total row that calculates the totals for the Order Amount, Discount, and Net Amount columns for the filtered data. 11. In the Customer Type Subtotal worksheet, Lian is trying to Include the sum of the order amount for each Customer Type and the subtotals in the Order Amount field. However, the subtotal for each customer type

More Related Content

Case Problem: Cooking.xlsx

  • 1. Buy here: http://homeworknumber.one/products.php?product=Cas e-Problem%3A-Cooking.xlsx Data File needed for this Case Problem: Cooking.xlsx Healthy Cooking Ulan Michim started Healthy Cooking two years ago to provide prepared gourmet meals to retail food stores, living facilities for seniors, and businesses. Lien tracks orders using Excel. She has entered customer order data for the first half of the year in a worksheet, and wants to analyze the data in several ways. Complete the following: 1. Open the Cooking workbook located in the Excels? Case3 folder included with your Data Ales, and then save the workbook as Healthy Cooking. 2. In the Documentation sheet, enter your name and the date. 3. Lien wants to view invoices with order amounts that are either less than $100 or greater than $5000. She tried filtering the orders in the Order Amount Filter worksheet, but is not working as expected. Review the Order Amount Alter worksheet and to the problem. 4. In the Orders worksheet, create an Excel table, and then rename the table as CustOrders. 5. In the CustOrders table, format the Order Amount, Discount, and Net Amount columns so that it is clear that these fields contain dollars. 6. Format the CustOrders table using the table style of your choice.
  • 2. 7. Make a copy of the Orders worksheet, and then rename the copied worksheet as Sort. (Hint: Press the Ctrl key and drag the sheet tab to the right of the current sheet .b to make a copy of the worksheet.) On the Sort worksheet, son the data in ascending order by Customer Type, then in ascending order by Delivered To, and then in ascending order by Customer. 8. Using conditional formatting, highlight all orders in he sorted table that have a Net Amount greater than $4000 in the format of your choice. 9. Make a copy of the Orders worksheet, and then rename the copied worksheet as Filter with Total Row. Filter the CustOrdem table to display all orders with an order date in June 2016 that included a discount. 10. Insert a Total row that calculates the totals for the Order Amount, Discount, and Net Amount columns for the filtered data. 11. In the Customer Type Subtotal worksheet, Lian is trying to Include the sum of the order amount for each Customer Type and the subtotals in the Order Amount field. However, the subtotal for each customer type