Part $1-$ Tasks

Please take a screenshot after taking each step. Place the screenshots in the mentioned Word file specifying which ScreenShot belongs to which task.

Apply the following tasks on the first dataset$($Part$1)$ provided on the first sheet of the shared document.

Task $1-$ Understanding the Dataset

$-$ Explore the data: identify each column's datatype $($text$,$ number, date$).$

Task $2-$ Basic Data Entry and Cell Formatting

$-$ Insert a new column between 'Product' and 'Region', name it 'Category' $($assume

categories like Apparel, Accessories, etc., can be filled manually$).-$ Apply currency formatting to the 'Revenue' column.

Task $3-$ Basic Formulas

$-$ Add a new column for 'Revenue per Unit'. Calculate this by dividing Revenue by

Units Sold.

$-$ Use a formula to calculate the total Revenue and total Units Sold at the bottom of

their respective columns. Task $4-$ Conditional Formatting

$-$ Apply conditional formatting to highlight 'Units Sold' greater than $25.$

$-$ Highlight 'Revenue' greater than $$1,000$ with a different color. Task $5-$ Sorting and Filtering

$-$ Sort the data by 'Revenue' in descending order.

$-$ Filter the dataset to show only products with 'Units Sold' more than $20.$ Task $6-$ Basic Data Analysis

$-$ Use the AVERAGE function to find the average Revenue.

$-$ Find the maximum and minimum Revenue using MAX and MIN functions. Task $7-$ Creating Simple Charts

$-$ Create a bar chart to represent Revenue by Product.

$-$ Create a pie chart to show the distribution of Units Sold by Region. Task $8-$ Introduction to Pivot Tables

$-$ Create a pivot table to summarize Units Sold by Region.

$-$ Include a subtask to modify the pivot table to also show the average Revenue by

Region. Task $9-$ Data Validation

$-$ Set data validation for the 'Units Sold' column to only allow numbers greater than $0.$

$-$ Add a dropdown list in the 'Region' column with predefined regions to prevent incorrect entries.