Reference no: EM133170263

Now that you have finished adding columns to Sheet 1, make a copy of 'Sheet1' and name that sheet 'Filter'. Also create a new empty sheet called 'Answers': this is where you will note the observations required below.

1. Apply a filter to the 'Filter' sheet in order to answer the following question: How many orders are there with a price in "Luxury" where the order was placed in the summer? In addition to applying the filter to sheet Filter, note the answer in the Answers worksheet.
2. Make another copy of 'Sheet1' and call it 'Filter2.' Then apply filters to the copied data in this new sheet in order to answer the following question: How many zip codes contain orders in the Top 0.1% of Extended Price where the Shipped Quantity is in the bottom 10%? 
3. Make another new copy of 'Sheet1' and call it 'Highlight3.' Then apply conditional formatting to the copied data in this new sheet in order to highlight orders taken via phone where the payment method was MC.