How would I do 4-8 on excel??

The data set on the Data sheet lists information about 400 customer transactions. A pivot table has been created below from this data set. For each of the following questions, manipulate the pivot table so that you can see the requested value. Then copy the appropriate pivot table cell and paste it special as a value to the specified cell to the right. The grader will only check that you have the correct numerical values, so you can use any manipulations you want to answer the questions.

1. Cell L3: What is the sum of Total Cost for all transactions by females in the West?

2. Cell L4: What is the average of Total Cost for all transactions by males in regions other than the West?

3. Cell L5: How many transactions were made on Monday mornings?

4. Cell L6: Of all transactions, what percentage were made by males on Tuesday afternoons? Hint: You might need to review Displaying Counts in Various Ways on the Topic page associated with this quiz.

5. Cell L7: What is the sum of Total Cost for all transactions by males on Tuesday evenings, shown as a percentage of the sum of Total Cost over all transactions?

6. Cell L8: For all transactions by females paid with credit cards (Visa or Mastercard), what is the maximum Total Cost amount .

7. Cell L9: What is the standard deviation (StdDev version) of Total Cost for all transactions made on Fridays?

8. Cell L10: What is the sum of Total Cost for all transactions made in May?