The Tasks Below Should All Be Completed On The Project 1 Worksheet
The Tasks Below Should All Be Completed On The Project 1 Worksheet
The Tasks Below Should All Be Completed On The Project 1 Worksheet
1 Create a Clustered Column Chart in A13 that displays each Department, the Hours
2 Add a Linear Forecast Trendline that forecasts 3 periods for Gross Pay.
3 Create a secondary Axis that displays the Gross Pay as a Line Chart.
H+ Sports
Department Comparison for November 2016
Shipping Sparklines
557
$29.66
$16,518.39
The tasks below should all be completed on the Project 2 worksheet
Create a PivotTable on this worksheet beginning in G10 that includes all fields in the table. D
1 SKU#), Price as Values, Date as Columns. Group by Date by Days, Months and Quarters
Create a calculated field to calculate the Total Sales of each Order. Name the Field "Total Sa
2
Create an Area PivotChart. Position the PivotChart so the upper-left corner of the chart is in c
Using the Slicers, filter the data to show only Green Items sold.
3
4 In cell H7, use the GETPIVOTDATA function to return the total sales of Green Clothing sold in
H+ Sport
Monthly sales report - Store #18 - Chicago, IL
Women's Clothing Sales - 2016
Name the Field "Total Sales". Add QTY Sold to Rows under Color.
ft corner of the chart is in cell A7. Insert a Slicer for Color and QTY Sold.
Total Sales of
Green Clothing
sold in Oct.