New York University Schweizer Distribution in Local Restaurants Worksheet

Please follow the direction attached and answer each question in the attached excel file. please make sure to follow the notes below:

Make sure that new worksheets identified in A – G below are to the right of the Solution worksheet tab and are in the order listed below. (0.3)

The Solutions worksheet collects the answers to Bob’s questions. For each of Bob’s questions, select the name from the drop-down list in the Name column and manually type in the answer for each question in the Total column

Each new worksheet should begin as a copy of the Customer Relations worksheet. Insert the PivotTable in the same new worksheet as the data table, beginning in cell N1 (0.3)

After completing each PivotTable and finding the answers to Bob’s question, turn off the Pivot Table’s Field List (0.3)