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).

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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.

Evaluate responses using AI:

OFF

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.

Evaluate responses using AI:

OFF

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.

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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.

Evaluate responses using AI:

OFF