In a data set containing order number, city, customer, product, quantity sold, and gross profit, a pivot table would be an appropriate tool to answer which of the following questions? O A. What is the gross profit generated by products within each city? OB. What is the gross profit generated from each customer? OC. What is the gross prot generated by each product? D. All the listed questions could be answered by using a pivot table