Data Validation Tasks (3 points): Restrict the 'Age' column to accept only values between 18 and 100. Create a drop-down list for the 'Gender' column with options 'Male', 'Female', and 'Other'. Ensure that the 'Review Rating' only accepts values between 1.0 and 5.0. Basic Formula Calculations Use Column T U on Shopping_trends to summarize the following calculations Calculate the total revenue generated from the 'Purchase Amount (USD)' column. 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 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'. 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 Apply conditional formatting to highlight 'Purchase Amount (USD)' higher than 50 in green and below20 in red. Use icon sets to represent 'Review Rating' levels (e.g., stars or flags). Creating Different Charts Create a chart of your choice to show the
