Calculate Average and Maximum of Profit;

$2-$Sort data based on Order Date, Segment and Quantity;

$3-$ Calculate the summation of Quantity of "Furniture" Category sold in "Los Angeles" City $($Do not use PivotTable$)$;

$4-$ Calculate the average Profit in "San Diego" City $($Do not use PivotTable$)$;

$5-$ Count the number of Products from "Accessories" Sub$-$Category purchased in "San Francisco" $($Do not use PivotTable$)$;

$6-$ Insert a column to write "Free Gift" automatically if the Quantity is more than $20$ or Sales is less than $100$ and discount is less than $2$;

$7-$Insert a PivotTable that shows Sales based on the Segment;

$8-$Insert a PivotTable that counts Profit of each Category in different States;

$9-$Insert a PivotChart to show Sales of each Sub$-$Category in different regions visually;

$10-$ Use Conditional Formatting to show Profit greater than $0$ with Green color and less than $0$ with Red color;

$11-$ Find duplicate values in the Customer Namecolumn and highlight them;

$12-$ Find the days between Order Date and Ship Date;

$13-$ Data in the Customer Name column is not clean. Clean data in terms of spacing and spelling;

$14-$ Create a drop$-$down list for selecting among Ship Modes;

$15-$ Replace $"$BA$"$ in Order ID column with $"$CA$"$ using Excel$$functions;$$