Excel Sheet Assignment: Product Sales

• Download PDF

Objective: To practice Excel skills in data manipulation, formatting, and basic functions.

Instructions:

Part 1: Data Entry

1. Open a new Excel workbook.
2. Create a worksheet named “Sales Data.”
3. Enter the following data into the worksheet:

Part 2: Calculations

1. In the “Total Sales” column, calculate the total sales for each transaction (Units Sold * Unit Price).
2. Calculate the total sales for each product.
3. Calculate the grand total of all sales.

Part 3: Formatting

1. Format the “Total Sales” column to display currency with two decimal places.
2. Apply bold font to the headers.
3. Apply a background color of your choice to alternating rows for better readability.

Part 4: Analysis

1. Calculate the average units sold per day.
2. Identify the product with the highest total sales and highlight its row.

Submission Guidelines:

• Save your Excel file as “Excel_Assignment_[Your Name].xlsx”.
• Submit your completed assignment by [Due Date] via Microsoft Teams.

Additional Notes:

• You may use any Excel functions or formulas necessary to complete the assignment.
• Ensure your calculations are accurate and formulas are properly applied.
• Feel free to add any additional formatting or analysis to enhance your worksheet.

Explore More Excel Topics

Microsoft Excel Fundamentals

Microsoft Excel More ...