Please do the below is in EXCEL with showing formula:

Please create the excel table of 118 rows

2. Sort the table based on:

a) Red color of Quantity first, then

b) Green color of Price

c) Customer Name and Location in descending order

3. Use filtering to select those customers whose:

Purchase date is after 15th December, 2022 ;and

Total sales greater than 16000

Format Price Column in BDT

2. Copy the Customer ID, Customer Name and Total Sales column of the filtered data from task-1 sheet to create a new excel table. The format will be like the one given in the example

1. Name the new table as Privilege Board

2. Add a column in the table as Reward and calculate the values for reward as follows:

a) If the total sales of a customer is greater than 21000 then he/she will get a discount of 15% of their sales on their next purchase.

b) The other customers will get a discount of 8% on their next purchase.

c) Highlight those customers who got the minimum discount in blue.

3. Finally convert the table to range.

\begin{tabular}{|l|c|c|c|} \hline \multicolumn{5}{|c|}{ Privilege Board } \\ \hline Customer ID & Customer Name & Total Sales & Reward \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular}