Product ID Product Category Quantity Unit Price
P001 Refrigerator HOME APPLIANCE 7 45,000
P002 AC HOME APPLIANCE 2 95,000
P003 Laptop DIGITECH 10 42,000
P004 Smart Phone DIGITECH 4 18,000
P001 Refrigerator HOME APPLIANCE 3 45,000
P005 Oven HOME APPLIANCE 10 19,000
P006 TV HOME APPLIANCE 3 27,000
P007 Washing Machine HOME APPLIANCE 4 54,000
P008 Printer DIGITECH 6 8,000
P002 AC HOME APPLIANCE 5 95,000
P009 Monitor DIGITECH 4 14,000
P005 Oven HOME APPLIANCE 9 19,000
P001 Refrigerator HOME APPLIANCE 13 45,000
P002 AC HOME APPLIANCE 3 95,000
P003 Laptop DIGITECH 4 42,000
P004 Smart Phone DIGITECH 6 18,000
P006 TV HOME APPLIANCE 7 27,000
Net Sales Amount Growth Rate Projected Sales Region
10% East Let's calculate the total quantity of all products so
9% West
2% North
5% South Let's find the average sales
10% South
2% South
7% North Let's identify the minimum unit price among the p
2% South
1% East
9% East Let's identify the maximum unit price among the p
1% North
2% East
10% East Let's count the total number of sales transactions
9% West
2% South
5% South
7% East
l quantity of all products sold
mum unit price among the products
mum unit price among the products
umber of sales transactions
Product ID Product Category Quantity Unit Price Net Sales Amount
P001 Refrigerator HOME APPLIANCE 7 45,000 315,000
P002 AC HOME APPLIANCE 2 95,000 190,000
P003 Laptop DIGITECH 10 42,000 420,000
P004 Smart Phone DIGITECH 4 18,000 72,000
P001 Refrigerator HOME APPLIANCE 3 45,000 135,000
P005 Oven HOME APPLIANCE 10 19,000 190,000
P006 TV HOME APPLIANCE 3 27,000 81,000
P007 Washing Machine HOME APPLIANCE 4 54,000 216,000
P008 Printer DIGITECH 6 8,000 48,000
P002 AC HOME APPLIANCE 5 95,000 475,000
P009 Monitor DIGITECH 4 14,000 56,000
P005 Oven HOME APPLIANCE 9 19,000 171,000
P001 Refrigerator HOME APPLIANCE 13 45,000 585,000
P002 AC HOME APPLIANCE 3 95,000 285,000
P003 Laptop DIGITECH 4 42,000 168,000
P004 Smart Phone DIGITECH 6 18,000 108,000
P006 TV HOME APPLIANCE 7 27,000 189,000
Region
East Highlight Expensive Products
West Highlight all rows where the Unit Price is greater than 50,000
North
South Highlight Highest Sales Amounts
South Highlight the top 5 transactions based on Sales Amount
South
North Identify Low Sales Transactions
South Highlight all transactions where the Sales Amount is less than 75,000
East
East Color Sales by Region
North Apply different background colors to transactions based on their Region
East East → Blue
East West → Orange
West North → Green
South South → Yellow
South
East Bold High Quantity Orders
Make the text Bold & Red for any orders where Quantity is more than 5.
Highlight Duplicates
Highlight the duplicate Product IDs
Product ID Product Category Quantity Unit Price
P001 Refrigerator HOME APPLIANCE 7 45,000
P002 AC HOME APPLIANCE 2 95,000
P003 Laptop DIGITECH 10 42,000
P004 Smart Phone DIGITECH 4 18,000
P001 Refrigerator HOME APPLIANCE 3 45,000
P005 Oven HOME APPLIANCE 10 19,000
P006 TV HOME APPLIANCE 3 27,000
P007 Washing Machine HOME APPLIANCE 4 54,000
P008 Printer DIGITECH 6 8,000
P002 AC HOME APPLIANCE 5 95,000
P009 Monitor DIGITECH 4 14,000
P005 Oven HOME APPLIANCE 9 19,000
P001 Refrigerator HOME APPLIANCE 13 45,000
P002 AC HOME APPLIANCE 3 95,000
P003 Laptop DIGITECH 4 42,000
P004 Smart Phone DIGITECH 6 18,000
P006 TV HOME APPLIANCE 7 27,000
Net Sales Amount Region
315,000 East
190,000 West
420,000 North
72,000 South Let's count the total number of sales tr
135,000 South
190,000 South
81,000 North Let's count the number of sales transactions of Home Appliance in Sou
216,000 South
48,000 East
475,000 East Let's calculate the total sales in West r
56,000 North
171,000 East
585,000 East Let's calculate the total value of TV sal
285,000 West
168,000 South
108,000 South
189,000 East
ctions of Home Appliance in South Region
Employee ID First Name Last Name Full Name Proper Name Uppercase Full Name
HRM-123456 RaHim udDin RaHim udDin Rahim Uddin
SCM-112233 faisAl HaSan faisAl HaSan Faisal Hasan
FIN-456789 JamiL HOSSAIN JamiL HOSSAIN Jamil Hossain
MKT-112233 sadia KhatUn sadia KhatUn Sadia Khatun
IT-334455 NaiM RahMan NaiM RahMan Naim Rahman
Lowercase Full Name Department Last 6 Digits of ID Find Repalce Substitute
Product ID Product Category Quantity Unit Price Net Sales Amount Region
P001 Refrigerator HOME APPLIANCE 7 45000 315000 East
P002 AC HOME APPLIANCE 2 95000 190000 West
P003 Laptop DIGITECH 10 42000 420000 North
P004 Smart Phone DIGITECH 4 18000 72000 South
P001 Refrigerator HOME APPLIANCE 3 45000 135000 South
P005 Oven HOME APPLIANCE 10 19000 190000 South
P006 TV HOME APPLIANCE 3 27000 81000 North
P007 Washing Machine HOME APPLIANCE 4 54000 216000 South
P008 Printer DIGITECH 6 8000 48000 East
P002 AC HOME APPLIANCE 5 95000 475000 East
P009 Monitor DIGITECH 4 14000 56000 North
P005 Oven HOME APPLIANCE 9 19000 171000 East
P001 Refrigerator HOME APPLIANCE 13 45000 585000 East
P002 AC HOME APPLIANCE 3 95000 285000 West
P003 Laptop DIGITECH 4 42000 168000 South
P004 Smart Phone DIGITECH 6 18000 108000 South
P006 TV HOME APPLIANCE 7 27000 189000 East
Region Net Sales Amount
East 1,783,000
West 475,000
North 557,000
South 889,000
Product Net Sales Amount
Refrigerator 1,035,000
AC 950,000
Laptop 588,000
Smart Phone 180,000
Oven 361,000
TV 270,000
Washing Machine 216,000
Printer 48,000
Monitor 56,000
Category Quantity
HOME APPLIANCE 66
DIGITECH 34
