Question: lick on any cell in Columns A:F. Insert a PIVOT TABLE in the existing worksheet, defining the location where you want the PivotTable report to
lick on any cell in Columns A:F. Insert a PIVOT TABLE in the existing worksheet, defining the location where you want the PivotTable report to be placed as cell H3 within the existing worksheet. NOTE 1: DO NOT INSERT A PIVOT CHART, AS WE ARE ASKING FOR A PIVOT TABLE HERE...A PIVOT CHART IS A DIFFERENT ITEM. Note 2: the upper left-hand corner of your pivot table should be in cell H3, in the same sheet as your data set. Hint: you may need to scroll back up to the top of your worksheetin order to select cell H3. **IMPORTANT NOTE: This next portion of the assignment will be graded on a curve to an overall score of 85% based on responses from all of your classmates. Originality matters here. Originality will be rewarded, lack of originality will not be rewarded...so be innovative in the design of your pivot table. Your explanation of a relevant business question and your arrangement of a pivot table to answer your business question will be an integral part of the curved grading process. Be as specific and detailed as possible. The quality of your writing matters. The use of proper spelling matters. The use
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
