Excel Assignment – Sales Tracker (Short Version)

Instructions:

Apply Formatting:

• • Bold and center the headers.
  • Format date as DD-MMM-YYYY.
  • Format currency columns (Unit Cost, Total) in ₹.

Add Formulas:

• • Insert a new column Recalculated Total = Units × Unit Cost.

Sort the Data:

• • First by Region (A–Z), then by Total (Largest to Smallest).

Bonus:

• • Highlight Total > ₹1000 using Conditional Formatting.

Complete this Assignment and Post Your Work on SSI DIGITAL COMMUNITY - Data Analytics Community