the hotel places uniform orders each quarter. Management would like to see just how many items are purchased each quarter by each department so they can decide whether they need to stop selling items or sell them more frequently. You will help by summarizing the quarterly worksheets and consolidating the data. You will also share a copy with the assistant manager to update any necessary items.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Excel. Download and open the file named Excel_BU04_Assessment1_Order.xlsx. Grader has automatically added your last name to the beginning of the file name. Save the file to a location where you are storing your files.

0

2

Group the Q1 through Q4 worksheets