\fPART B: Pivot Table and Recommended Charts (5 marks) i. Calculate gross profit for each customer along with product name and payment type using Pivot Table; categorising the columns by salesperson ii. Calculate sales revenue by each salesperson using Pivot Table and illustrate it via Clustered Bar Chart iii. Calculate sales revenue and gross profit earned by each product using Pivot Table and illustrate it via 100% stacked line graph For Pivot Tables and charts, please use a new worksheet and label it as (Pivot and Charts). You must use relevant Excel functions for the tasks assigned. Do not calculate it manually