Business Case Studies & Business Publications

PivotTable Practice Problems

Alizamir, Saed, Gu...

Exercise

PivotTable Practice Problems

Alizamir, Saed; Gustafson, Ben

QA-0985 | Published February 4, 2026 | 4 Pages Exercise

Collection: Darden School of Business

Add To Cart Buy Now

Product Details

In this set of three problem vignettes, the fictional manufacturing company BizCo has hired the reader for their skills in data analysis. Each vignette provides a scenario that BizCo is working through—real estate investment, assessing product performance, and analyzing employee sales performance—alongside an Excel spreadsheet of relevant data. Students will use PivotTables for data analysis to address the problems and questions confronting BizCo in each scenario. Accompanying the problem set are instructional video supplements produced by the authors with Darden Video Production. This set of PivotTable problems is part of a three-part set of data analysis exercises. It may be used independently or in conjunction with two other exercise sets: "Decision Tree Practice Problems" (UVA-QA-0986) and "Optimization Practice Problems" (UVA-QA-0987).