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?