Order ID Order Date Customer Name Region Salesperson Name Product Quantity Unit Price Discount % Payment Status

Unit Price Discount % Payment Status Net Revenue Revenue Month

O001 23-Apr-2025 Megha S South Neha Sharma Printer 2 12000 5 Paid
O002 28-Apr-2025 Naveen South RIYA GUPTA Office Chair 2 7500 6 Paid
O003 07-Mar-2025 Sahil North srikanth verma Mobile 6 18000 8 Pending
O004 14-Feb-2025 Maya West Neha Sharma Mobile 6 18000 8 Pending
O005 20-Feb-2025 Ramesh K North Srikanth Verma Laptop 1 55000 8% Pending
O006 03-Mar-2025 Arjun Reddy East Anita Joseph Laptop 2 55000 6 Paid
O007 11-Apr-2025 Priya West RAHUL NAIR Printer 3 12000 5 Paid
O008 19-Mar-2025 Deepa Menon South Neha Sharma Mobile 4 18000 7 Paid
O009 25-Feb-2025 Manju S East Laptop 3 55000 5 Unpaid
O010 07-Feb-2025 Anita Joseph South Anita Joseph Office Chair 2 7500 8 Paid
O011 03-Apr-2025 Kamal North Neha Sharma Desk 1 9500 3 Paid
O012 17-Feb-2025 Sunil West Rahul Nair Printer 1 12000 4 Paid
O013 02-Mar-2025 Aditya East Neha Sharma Mobile 6 18000 8 Paid
O014 13-Apr-2025 Priya West Neha Sharma Mobile 5 18000 0 Paid
O015 08-Mar-2025 Suresh South RAHUL NAIR Laptop 1 55000 7 Paid
O016 21-Feb-2025 Ritu North RIYA GUPTA Office Chair 3 7500 5 Paid
O017 29-Mar-2025 Kishore East srikanth verma Desk 2 9500 6 Paid
O018 02-Apr-2025 Arun Kumar West Neha Sharma Laptop 7 55000 1 Unpaid
O019 05-Mar-2025 Tanvi South ANITA JOSEPH Printer 2 12000 5 Paid
O020 12-Apr-2025 Gita North Rahul Nair Mobile 4 18000 8 Paid
O021 24-Feb-2025 Neetu South Neha Sharma Desk 3 9500 6 Paid
O022 09-Mar-2025 Rohit West RIYA GUPTA Office Chair 4 7500 4 Pending
O023 15-Apr-2025 Kiran East Neha Sharma Printer 2 12000 5 Paid
O024 18-Feb-2025 Dinesh South Anita Joseph Mobile 3 18000 6 Paid
O025 20-Apr-2025 Sakshi North RAHUL NAIR Desk 5 9500 2 Unpaid
O026 01-Mar-2025 Vagdevi West Neha Sharma Laptop 1 55000 5 Paid
O027 11-Feb-2025 Mahesh East srikanth verma Desk 2 9500 6 Paid
O028 04-Apr-2025 Shalini S South ANITA JOSEPH Printer 3 12000 5 Paid
O029 14-Mar-2025 Neha North RAHUL NAIR Mobile 7 18000 4 Paid
O030 27-Feb-2025 Bhavana West Neha Sharma Office Chair 2 7500 6 Paid
O031 30-Mar-2025 Ramesh South RAHUL NAIR Laptop 2 55000 6 Paid
O032 06-Feb-2025 Arun K East RIYA GUPTA Printer 1 12000 3 Paid
O033 22-Mar-2025 Sameer West Neha Sharma Mobile 3 18000 5 Paid
O034 10-Apr-2025 Asha South Anita Joseph Desk 4 9500 7 Pending
O035 16-Mar-2025 Veena Varma North Neha Sharma Printer 2 12000 6 Paid
O036 05-Apr-2025 Sunita East RAHUL NAIR Mobile 3 18000 5 Paid
O037 26-Feb-2025 Prakash South Neha Sharma Laptop 2 55000 7 Paid
O038 08-Mar-2025 Kavita West Anita Joseph Office Chair 1 7500 4 Paid
O039 17-Feb-2025 Ram North RIYA GUPTA Desk 2 9500 3 Pending
O040 01-Apr-2025 Anil South Neha Sharma Mobile 4 18000 8 Paid
O041 11-Feb-2025 Maya West RAHUL NAIR Printer 3 12000 5 Paid
O042 03-Mar-2025 Jaya East neha sharma Mobile 5 18000 6 Unpaid
O043 29-Mar-2025 Anita North Srikanth Verma Laptop 2 55000 5 Paid
O044 06-Apr-2025 Praveen South ANITA JOSEPH Office Chair 2 7500 6 Paid
O045 23-Feb-2025 Nikita West RAHUL NAIR Mobile 4 18000 8 Paid
O100 27-Feb-2025 Ankit West RAHUL NAIR Printer 2 12000 6 Paid
O046 31-Mar-2025 Kavya East Neha Sharma Printer 2 12000 5 Paid
O047 14-Feb-2025 Sahil North RAHUL NAIR Laptop 5 55000 7 Paid
O048 28-Feb-2025 Meena South RIYA GUPTA Desk 3 9500 4 Paid
O049 21-Mar-2025 Sandhya West Neha Sharma Mobile 6 18000 5 Paid
O050 05-Mar-2025 Suman East Anita Joseph Laptop 1 55000 6 Paid
O051 12-Apr-2025 Naveen South neha sharma Mobile 5 18000 3 Paid
O052 25-Apr-2025 Prashant West RAHUL NAIR Printer 1 12000 5 Paid
O053 08-Feb-2025 Deepa Menon East Anita Joseph Mobile 6 18000 8 Paid
O054 19-Mar-2025 Kumar South Neha Sharma Desk 2 9500 6 Paid
O055 02-Mar-2025 Lakshmi West RIYA GUPTA Office Chair 6 7500 5 Pending
O056 09-Apr-2025 Neha Sharma North RAHUL NAIR Mobile 4 18000 6 Paid
O057 17-Feb-2025 Suresh South Neha Sharma Printer 2 12000 4 Paid
O058 20-Feb-2025 Sunil West Anita Joseph Laptop 3 55000 6 Paid
O059 24-Mar-2025 Vikram East RAHUL NAIR Desk 1 9500 3 Paid
O060 13-Feb-2025 Kamal South Neha Sharma Mobile 2 18000 5 Paid
O061 02-Apr-2025 Rohit North Anita Joseph Printer 3 12000 5 Paid
O062 15-Apr-2025 Priyanka West RAHUL NAIR Laptop 1 55000 6 Paid
O063 27-Feb-2025 Gaurav East Neha Sharma Mobile 2 18000 4 Paid
O064 10-Mar-2025 Rekha South RAHUL NAIR Office Chair 3 7500 5 Pending
O065 18-Apr-2025 Sahil North neha sharma Printer 4 12000 7 Paid
O066 04-Apr-2025 Megha West Anita Joseph Mobile 6 18000 8 Pending
O067 22-Feb-2025 Kishore East RIYA GUPTA Desk 2 9500 6 Paid
O068 03-Mar-2025 Arjun Reddy South RAHUL NAIR Laptop 1 55000 6 Paid
O069 07-Apr-2025 Suman West Neha Sharma Printer 2 12000 3 Paid
O070 16-Feb-2025 Jagdish South ANITA JOSEPH Mobile 3 18000 5 Paid
O071 30-Mar-2025 Asha North Neha Sharma Desk 4 9500 7 Paid
O072 11-Apr-2025 Bhavesh East RAHUL NAIR Mobile 5 18000 6 Paid
O073 05-Mar-2025 Manju S West neha sharma Laptop 2 55000 5 Unpaid
O074 26-Feb-2025 Ritu South Srikanth Verma Office Chair 1 7500 3 Paid
O075 08-Apr-2025 Kunal North RAHUL NAIR Printer 1 12000 4 Paid
O076 14-Mar-2025 Bhavana East NEHA SHARMA Mobile 2 18000 6 Paid
O077 19-Feb-2025 Shweta West Anita Joseph Desk 3 9500 6 Paid
O078 01-Apr-2025 Sahil South RAHUL NAIR Printer 4 12000 5 Paid
O079 24-Mar-2025 Aditi North Neha Sharma Laptop 1 55000 6 Paid
O080 29-Apr-2025 Sunaina East RIYA GUPTA Office Chair 2 7500 5 Paid
O082 21-Apr-2025 Arjun Reddy South neha sharma Laptop 2 55000 6 Paid
O083 06-Mar-2025 Pooja West RAHUL NAIR Desk 1 9500 3 Paid
O084 17-Mar-2025 Shiv North Neha Sharma Printer 2 12000 5 Paid
O085 12-Feb-2025 Ananya East RAHUL NAIR Mobile 3 18000 4 Paid
O086 28-Feb-2025 Ramesh South Anita Joseph Office Chair 2 7500 4 Paid
O087 04-Apr-2025 Pranav West neha sharma Laptop 3 55000 5 Paid
O088 09-Mar-2025 Deepak East RAHUL NAIR Printer 2 12000 6 Paid
 Order ID Order Date Customer Name Region Salesperson Name Product Quantity Unit Price Discount % Payment Status Net Revenue Revenue Month
O089 31-Mar-2025 Suman North ANITA JOSEPH Mobile 4 18000 8 Paid
O090 23-Feb-2025 Ragini South Neha Sharma Desk 2 9500 5 Paid
O091 02-Apr-2025 Nikita West RAHUL NAIR Printer 3 12000 5 Paid
O115 05-Apr-2025 Asha East neha sharma Mobile 4 ₹ 18000 6 Pending
O080 29-Apr-2025 Sunaina East RIYA GUPTA Office Chair 2 7500 5 Paid
O092 11-Mar-2025 Santhosh East neha sharma Mobile 2 18000 3 Paid
O093 07-Feb-2025 Sahil North RAHUL NAIR Laptop 4 55000 7 Paid
O094 20-Apr-2025 Meena West Neha Sharma Office Chair 3 7500 6 Pending
O095 25-Mar-2025 Ashok South ANITA JOSEPH Printer 2 12000 5 Paid
O096 16-Apr-2025 Arun Kumar West Neha Sharma Laptop 7 55000 1 Paid
O097 05-Feb-2025 Bhavya East RAHUL NAIR Mobile 2 18000 5 Paid
O098 15-Mar-2025 Vinod South Neha Sharma Desk 1 9500 3 Paid
O099 18-Apr-2025 Pratik North Anita Joseph Office Chair 4 7500 4 Paid
O100 27-Feb-2025 Ankit West RAHUL NAIR Printer 2 12000 6 Paid
O101 08-Apr-2025 Sahil South Neha Sharma Mobile 3 18000 5 Paid
O102 22-Feb-2025 Shalini S East ANITA JOSEPH Desk 4 9500 6 Paid
O112 1/4/2025 Priya West Neha Sharma Printer 3 12000 5 Paid
O103 01-Mar-2025 Deepa Menon West ANITA JOSEPH Mobile 6 18000 8 Paid
O104 04-Mar-2025 Megha S North RAHUL NAIR Printer 2 12000 5 Paid
O105 10-Mar-2025 Naveen South neha sharma Office Chair 2 7500 4 Paid
O106 14-Feb-2025 Sahil West RAHUL NAIR Laptop 5 55000 7 Paid
O107 30-Mar-2025 Kumar East neha sharma Mobile 3 18000 5 Paid
O108 26-Feb-2025 Ramesh K North Srikanth Verma Laptop 1 55000 8% Pending
O109 09-Apr-2025 Tejaswini South Anita Joseph Printer 2 12000 5 Paid
O110 03-Feb-2025 Bhavana West RAHUL NAIR Desk 2 9500 4 Paid
O111 19-Mar-2025 Neha East NEHA SHARMA Mobile 4 18000 6 Paid
O113 12-Feb-2025 Arjun Reddy South RAHUL NAIR Desk 2 9500 6 Paid
O114 24-Mar-2025 Pradeep North Anita Joseph Laptop 2 55000 5 Paid
O116 15-Feb-2025 Maya South RAHUL NAIR Printer 3 12000 4 Paid
O117 21-Apr-2025 Neha Sharma West ANITA JOSEPH Desk 2 9500 5 Paid
O118 02-Mar-2025 Dinesh North Neha Sharma Office Chair 1 7500 6 Paid
O119 07-Apr-2025 Suresh East RAHUL NAIR Mobile 5 18000 7 Pending
O120 16-Feb-2025 Ramesh South Neha Sharma Printer 3 12000 6 Paid
O121 11-Mar-2025 Aditi West RAHUL NAIR Laptop 1 55000 5 Paid
O122 22-Feb-2025 NoteDate South Neha Sharma Mobile 2 18000 4 Paid
O123 02-Apr-2025 Pranav North Anita Joseph Desk 3 9500 6 Paid
O124 08-Mar-2025 Gita West RAHUL NAIR Printer 2 12000 5 Paid
O125 17-Feb-2025 Sahil East Neha Sharma Mobile 6 18000 8 Paid
 Questions Answers
List 3 issues (anomalies) you found in the dataset and explain how it affects the analysis
Fill the “Net Revenue” and “Revenue” columns in the Orders sheet using formulas.

For orders where Payment Status = Paid:

- Net Revenue = Quantity × Unit Price × (1 − Discount%)
- Revenue = Quantity × Unit Price
Create a pivot table showing Net Revenue for each Region. Mention the Region with highest Net Revenue
Calculate the Total Revenue (Answer using formula)
What percentage of total orders are Unpaid or Pending? (Answer using formula)
1. Fill the “Month” column in the Orders subsheet by extracting the month from the Order Date using a
formula.
2. Insert a new subsheet with name "Products sold" & build a summary table that shows the total
quantity sold for each product, month-wise. (Answer using formula, Rearrange columns if required)
3. Mention which month and which product recorded the highest total quantity sold based on the
summary.
Determine whether higher discounts lead to higher revenue? Explain your conclusion using supporting
numbers or statistics from the data.