Calculate the Total Purchase Amount by US State

Determine the average 'Review Rating' for each 'Category'.

Count the number of sales by seasons

Lookups and IFS statements $(4$ points$)$:

Continue to use Column T & U to create an empty cell to enter a customer ID$,$ followed by the logical statements

Use vLookup or xLookUP to find the 'Payment Method' for a given 'Customer ID$\text{'}.$

Create an Ifs statement to categorize customers into 'New', 'Returning', and 'Loyal' based on the 'Previous Purchases' $($e$.$g$.,0-10$ New, $11-20$ Returning, $21+$ Loyal$).$

Conditional Formatting $(2$ points$)$:

Apply conditional formatting to highlight 'Purchase Amount $($USD$)\text{'}$ higher than $$50$ in green and below $$20$ in red.

Use icon sets to represent 'Review Rating' levels $($e$.$g$.,$ stars or flags$).$

Creating Different Charts $(4$ points$)$:

Create a chart of your choice to show the distribution of 'Category'.

Design a chart of your choice to display the total 'Purchase Amount $($USD$)\text{'}$ by $\text{'}$US State'.

Basic Dashboard Creation $(5$ points$)$:

Create a new worksheet titled 'Dashboard'.

Use cell references to display key metrics like total revenue, number of sales by seasons and average rating

Insert the created charts into the 'Dashboard' worksheet and arrange them neatly.