A pivot table would be an appropriate tool for each of the following actions except O A. calculating the average cost of each product model by plant location. OB. locating one specific sales transaction. O C. calculating the total costs for each product model by month within a particular year. OD. summarizing transaction data by store location