Sales and Inventory Data Analysis Quiz

Calculate Total Sales: In the Total Sales column, use a formula to calculate the total sales for each product (Quantity Sold * Price per Unit).

Sum of Total Sales: Use the SUM function to calculate the total sales for all products listed.

Find the Average Price: Use the AVERAGE function to calculate the average price per unit across all products.

Maximum and Minimum Sales: Use the MAX function to find the product with the highest total sales. Use the MIN function to find the product with the lowest total sales.

Conditional Formatting: Apply conditional formatting to highlight the Total Sales values greater than $70 in green. Highlight any Quantity Sold values less than 50 in red.

Create a Bar Chart: Create a Bar Chart to visually represent the Quantity Sold for each product. Add a chart title and adjust the labels for clarity.

Sort Data: Sort the data in descending order based on Total Sales.

Create a Budget Sheet (Extension Task): Create a new table with columns: Category, Budgeted Amount, Actual Amount, and Difference. In the Category column, add Sales Revenue, Expenses, and Profit. Use formulas to calculate the Difference between Budgeted Amount and Actual Amount for each category.