Date Segment City Product Discount Band Units Sold Sale Price

1/1/2016 Government Kolkata Note Book High 1619 40

6/1/2016 Midmarket Mumbai Pen None 2178 15
6/1/2016 Midmarket Delhi Eraser None 888 13
12/1/2016 Government Delhi Sharpner None 1513 12
3/1/2016 Midmarket Delhi Pencil Medium 921 14
6/1/2016 Government Mumbai Long Note Book None 1899 50
6/1/2016 Channel Partners Delhi Sharpner Low 1545 12
6/1/2016 Midmarket Chennai Cello Tape Medium 2470 16
7/1/2016 Enterprise Kolkata Pen None 2666 15
9/1/2016 Government Delhi Note Book None 2146 40
10/1/2016 Enterprise Kolkata Cover File High 345 30
12/1/2016 Midmarket Bangalore Pen Stand Low 615 35
2/1/2016 Government Kolkata Eraser None 292 13
2/1/2016 Midmarket Chennai Cello Tape None 974 16

1) Open an Excel sheet and create the aforementioned database in Sheet 1.

2) Perform best fit wherever necessary.
3) Rename the sheet name as "AIT Information".
4) Go to cell A7 and change the date to 30/01/2023.
5) Go to cell C13 and change the city name to "Mumbai".
6) Go to cell D7 and change the product name as "Note Book".
7) Insert 2 decimal places in sales column.
8) Calculate Incentives (=units sold *5) in column J.
9) Insert INR symbol in Incentives and Sales Amt column.
10) Insert a new sheet and copy the database from "AIT Information" sheet.
11) Now calculate Total Incentives in cell J16.
12) calculate total sales in cell I16.
Sales Amt
63,445.20
32,016.60
11,313.12
17,792.88
12,636.12
93,051.00
18,169.20
38,729.60
39,182.85
84,123.20
10,143.00
21,094.50
3,720.08
15,272.32
Party Jan Feb Mar Total
Ananya 6000 4500 6000
Rahul 8500 7000 6000
Swati 9500 5000 12000
Rakesh 7000 7000 2000
Vishal 4500 5000 8000

1) Open the workbook you created on previous assignment and the data into table. Now apply predefined "Blue Ta
2) Create the aforementioned database in a new sheet.
3) Quarterly report and apply Merge and center.
4) Change font colour of data of Rakesh in cell D5.
5) Total of all values in column E
6) Copy data and paste on new sheet
7) Hide the record of Swati
8) Copy the record of Rakesh and paste it in cell I4
9) Unhide the record of Swati
10) Delete the record of Vishal
Now apply predefined "Blue Table Style Medium 6" on AIT Information table.
SalesmanJan Feb Mar Total
Amit 5600 4500 6540 ProductQty
Riya 8500 6650 6554 X 12
Avi 9500 4556 12000 Y 8
Dipa 6900 6850 2000 Z 15
Rajesh 4500 4585 8020

Revenue250000
Cost 120000
Bonus
Profit

Total commission of Jan, Feb and March

 12% City Wise HRA Calculation
Rate GST @12% 15% 20% 25%
450 Basic Puri Hisar Pune
340 5000
280 10000
15000
20000
SalesmanNet SalesCommission
Divya 73620.00 8835.00
Riya ### 18680.00
Bhupesh 70087.00 8410.00
Amit 60577.00 7270.00
Ravi ### 20250.00
Manjeet ### 24270.00
Vikas 52348.00 6280.00
Rajesh ### 14340.00
Samvika 36473.00 4375.00
Mayank ### 18785.00
SalesmaNet SalesCommission
Divya ### 28075.00
Riya ### 28395.00
Bhupesh ### 20560.00
Amit ### 33625.00
Ravi ### 21060.00
Manjeet ### 32325.00
Vikas ### 16450.00
Rajesh ### 16750.00
Samvika 70748.00 8490.00
Mayank ### 21730.00
SalesmanNet SalesCommission
Divya ### 12215.00
Riya 85871.00 10305.00
Bhupesh 49679.00 5960.00
Amit 99109.00 11895.00
Ravi 13062.00 1565.00
Manjeet 21643.00 2595.00
Vikas ### 13060.00
Rajesh 11617.00 1395.00
Samvika 43245.00 5190.00
Mayank 24058.00 2885.00
Emp_Id DOJ Name Department Pay Rate
E0001 5/12/2016 CB Naidu Acct 200 50
E0002 6/20/2016 Nitish Kumar Admin 190 48
E0003 7/5/2016 Kangana MKT 185 42
E0004 8/5/2016 Lalu Yadav Sales 230 55
E0005 9/3/2016 Manish Singh IT 180 40

1)Assign the suffix for pay columnas '/hr" so that on only entering of value the suffix will be assigned automatically.
2) Assign INR symbol in rate column with 2 decimal places.
3) Change DOJ format as "Long Date".
4) Enter Department name by using custom list.
5) Insert a command in cell E1 as "Enter pay Hr" and insert a picture in the comment background.
6) Highlight pay column in in Green fill if pay /hr is more than 200, yellow fill if pay /hr is between 175 and 200, and
7) Now go to E3 cell and change the value as 220, and check if fill colour will update automatically.
8) Go to G1 and type Total Pay, now calculate total pay using suitable function (=pay*rate)
9) In Total Pay column highlight top 3 items.
10) Now insert icon set in Total Pay column instead of highlighting top 3 items.
11) Go to A5 and cange value as E0002, now highlight the duplicate value in Emp_Id field.
12) Copy the name column in a new sheet in cell A1,ll A1, now type first name and last name in cell B1. Now segrega
13) Go to cell E1 and type 12,then create a linear series by jumping 3 upto 50.
x will be assigned automatically.

nt background.
/hr is between 175 and 200, and red fill for the rest.
e automatically.

ast name in cell B1. Now segregate first name and last name from name field using flash fill.
 Sales Bills & Commission (1)
Cust_I
Cust_Name Bill_Date Sales_Bill Credit_Days Due_Dates
D
CST001 M/S APT Daily Needs 7/22/2016 520000 15
CST013 M/S Gandhi Ashram 8/8/2016 430000 30
CST014 M/S Kohli Brothers 8/27/2016 780000 7
CST025 M/S SK Raja & Co. 9/10/2016 610000 7
CST005 M/S Kala Creation 9/25/2016 490000 15
CST018 M/S Chatori Gali 10/5/2016 770000 30
CST010 M/S Krishna Enterprises ### 290000 15
CST012 M/S Singh Brothers 11/1/2016 650000 15
CST007 M/S Vineet Traders ### 220000 30
CST020 M/S Bennett & Coleman ### 500000 30

Total 2nd Average

Minimum 3rd Lowest
Sales Maximum Sales Bill Highest of Sales
Sales Bill Sales Bill
Bill Sales Bill Bill

1) Calculate Due date (=Bill Date +Credit days)

2) Calulate Total sales bill in cell A15.
3) Find out Max sales bill in cell B15.
4) Find Min sales bill in cell C15.
5) Calculate second highest sales bill in cell D15.
6) Calculate third lowest sales bill in cell E15.
7) calculate Average sales bill in cell F15.
8) Highlight Sales Bill in green for top 3 sales bill.
Numbe Integer Round Round MROU Square
Trunc Rank
r Value Up Down ND Root
55.63
456.231
49
3.1411
-33.33

1) Calculate Integer value in cell range J2:J6.

2) In cell range K2:K6 perform ROUNDUP, and in range L2:L6 perform ROUNDDOWN.
3) In range M2:M6 perform TRUNC function (no decimal places required in resulting range)
4) In range N2:N6 value should be rounded by nearest 5.
5) Calculate square root in range O2:O6.
6) Calculate rank (descending order) in range P2:P6.
resulting range)
Employee Cod Name Dept Post Basic DA
AIT0012 Adarsh Tiwari MKT Executive 8000.00 5000
AIT0013 Sambi Patra MKT Assistant Manager ### 18000
AIT0014 Solomon Roy MKT Sr.Executive ### 7800
AIT0015 Harpal Sokhi FINANCE Assistant Manager ### 9600
AIT0016 Robert Peter FINANCE Executive 8000.00 5000
AIT0017 Sapna Pal FINANCE Manager ### 27000
AIT0018 Amit Sana ACCT Assistant Manager ### 16800
AIT0019 Reema Singh ACCT Executive 6000.00 5000
AIT0020 Rahul Mishra ADMIN Sr.Executive ### 7200
AIT0021 Prakash Chandra ADMIN Executive 6500.00 5000

1) Calculate post of each employee on following basis-

Executive for basic salary <= 10000
Sr. Executive for basic salary 10000-15000
Asst. Manager for basic salary 15000-30000
Manager for basic salary >= 30000

2) Calculate DA 60% of Basic or 5000, whichever is higher.

3) Flat is allotted to Managers and Asst. Managers
4) HRA @ 20% of (Basic +DA) will be given to those employees who are not allotted fl
5) TA Rs 3000 will be given to Managers and Asst. Managers whose Basic+DA exceed
6) Calculate Gross salary using suitable function.
7) Calculate PF @12% of(Basic+DA)
 Flat (Yes/ No)HRA TA Gross PF Net
No 2600 1500 ### 2600 ###
Yes FALSE 3000 ### 9600 ###
No 4160 1500 ### 4160 ###
Yes FALSE 1500 ### 5120 ###
No 2600 1500 ### 2600 ###
Yes FALSE 3000 ### 14400 ###
Yes FALSE 3000 ### 8960 ###
No 2200 1500 ### 2200 ###
No 3840 1500 ### 3840 ###
No 2300 1500 ### 2300 ###

loyees who are not allotted flat

gers whose Basic+DA exceeds Rs 32000, for others TA Rs 1500.
Order DateOrder Number Customer QuantityCategoryUnit Price
12/3/2023 1 Nitesh Sinha 10 Suits
12/5/2023 2 Dholakia 5 Coats
12/10/2023 3 Deepak Kalal 2 Coats
12/12/2023 4 Uma Shankar Singh 10 Ties
12/15/2023 5 Saloni Pathak 5 Coats
12/20/2023 6 Uorfi Javed 6 Ties
12/21/2023 7 Srinidhi 10 Hats
12/23/2023 8 Rina Karmakar 5 Suits
12/26/2023 9 Sharmila Vohra 2 Shoes
12/30/2023 10 Sonali Gupta 10 Hats
12/3/2023 11 Deepali Dutta 6 Ties
12/5/2023 12 Rakhi Sawant 10 Shoes
12/10/2023 13 Deepak Chandra Awasthi 5 Suits
12/12/2023 14 Savita Raut 2 Coats
12/15/2023 15 Aakash Nagpal 10 Hats
12/20/2023 16 Sangeeta Chaturvedi 5 Suits
12/21/2023 17 Priya Tiwari 18 Shoes
12/23/2023 18 Priya Tiwari 3 Hats
12/26/2023 19 Nikita Jain 4 Ties
12/30/2023 20 Sreyashi Pal 12 Shoes
12/3/2023 21 Anshu Dubey 5 Suits
12/5/2023 22 Aru Pathan 15 Coats
12/10/2023 23 Ajay Kumar Mishra 3 Coats
12/12/2023 24 Jayashree 4 Ties
12/15/2023 25 Jatinder Singh 5 Hats
12/20/2023 26 Shashi Kumar 8 Suits
12/21/2023 27 Navdeep 3 Shoes
12/23/2023 28 Sadhana Saini 4 Hats
12/26/2023 29 Manish Gupta 12 Ties
12/30/2023 30 Sukhdev Bhatti 6 Shoes
Discount Amount CategoryUnit Price
Suits 3500
Coats 1500
Ties 200
Hats 100
Shoes 600

1) Calculate unit price based on above mentioned table by using logical function.
2) 5% discount if order qty. >10, else discount 2%
3) Calculate amount using suitable formula.
4) Go to cell P2 and calculate Total sales after 10/12/2023 using suitable formula.
5) Find out how many suits were sold using appropriate formula.
6) Calculate total number of orders for Hats using suitable formula.
sing logical function.

sing suitable formula.

Order Date Zone Product Name Type Qty (Pcs.) Rate Net Price
6/20/2023 West Milk Chocolate Plain 60 ₹ 55.00
8/11/2023 South Fruit & Nut Chocolate Nut 48 ₹ 95.00
6/13/2023 West Dark Chocolate Plain 60 ₹ 80.00
5/10/2023 East Fruit & Nut Chocolate Nut 65 ₹ 95.00
5/14/2023 North Milk Chocolate Plain 100 ₹ 55.00
3/1/2023 East Milk Chocolate Plain 190 ₹ 55.00
5/12/2023 North Dark Chocolate Nut 80 ₹ 80.00
8/14/2023 South Milk Chocolate Nut 60 ₹ 55.00
7/20/2023 East Milk Chocolate Plain 65 ₹ 80.00
5/25/2023 West Fruit & Nut Chocolate Nut 50 ₹ 95.00
7/19/2023 North Dark Chocolate Plain 50 ₹ 80.00
6/20/2023 West Milk Chocolate Plain 80 ₹ 55.00
8/11/2023 South Fruit & Nut Chocolate Plain 45 ₹ 95.00
6/13/2023 West Dark Chocolate Plain 80 ₹ 80.00
5/10/2023 East Fruit & Nut Chocolate Nut 45 ₹ 95.00
5/14/2023 North Milk Chocolate Plain 120 ₹ 55.00
3/1/2023 East Milk Chocolate Plain 80 ₹ 55.00
5/12/2023 North Dark Chocolate Nut 120 ₹ 80.00
8/14/2023 South Milk Chocolate Plain 60 ₹ 55.00
7/20/2023 East Milk Chocolate Plain 75 ₹ 80.00
5/25/2023 West Fruit & Nut Chocolate Plain 60 ₹ 95.00
7/19/2023 North Dark Chocolate Plain 48 ₹ 80.00
6/20/2023 West Milk Chocolate Plain 120 ₹ 55.00
8/11/2023 South Fruit & Nut Chocolate Plain 80 ₹ 95.00
6/13/2023 West Dark Chocolate Plain 75 ₹ 80.00
1) Calculate Net price (discount allowed 5% if order qty. >100 and rate > Rs 75)

2) Set data types for columns as per instructions-

Product Name does not allow more than 30 characters
Qty., rate and net price accept only numbers
Zone accepts only text
Order date does not allow any duplicate value

3) Insert a field after Net Price as "Remarks", and performance will be marked-
Good if Qty. >100, "Average" if Qty. is between 50-99, and "Poor" if Qty. <50

4) Double Rate without using any formula.

Emp ID Name Department Gender Monthly Salary Annual Salary
Emp008 Abu Finance Male 44000 528000
Emp006 Hamnah Finance Female 10000 120000
Emp010 Lucky Finance Female 20000 240000
Emp003 Malik Finance Male 80000 960000
Emp002 Yakub IT Male 30000 360000
Emp018 Divya IT Female 18000 216000
Emp015 Makhan IT Male 28000 336000
Emp014 Prakhar IT Male 40000 480000
Emp012 Aarav Marketing Male 75000 900000
Emp017 Alia Marketing Female 59000 708000
Emp004 Alisha Marketing Female 25000 300000
Emp001 Bhupati Marketing Male 13000 156000
Emp013 Julie Marketing Female 9000 108000
Emp005 Pal Marketing Male 59000 708000
Emp019 Tony Marketing Male 13000 156000
Emp009 Amal Support Male 52000 624000
Emp016 Sikandar Support Female 61000 732000
Emp011 Jai Support Male 44000 528000
Emp007 Sana Support Female 44000 528000

Emp ID Name Department Gender Monthly Salary Annual Salary

Emp017
 Product Rate Quantit
Emp ID Department Laptop 2
Emp014 Mobile 14
SSD Card 6
Earbuds 3
Laptop 2
Mobile 8
Emp ID Name SSD Card 3
Emp011 Earbuds 2
Laptop 22
Mobile 2
SSD Card 2
Earbuds 1
Earbuds 17
Mobile 7
SSD Card 6
Laptop 9

Discount Lookup Table

Quantity Discount %
0 0%
5 1%
10 2%
20 5%
Discount

Rate Lookup Table

Product Laptop Mobile SSD Card Earbuds
Rate 430 390 270 150
Down Payment 15000 What is the Purchased Price of the Motor Cycle?
EMI p.m. 3553
Time 5 years
Interest PA 10%
Present Value

Present Value 45000 1) Find the EMI.

Down Payment 15000 2) From each EMI find out Principal and Interest. Find out gross interest after 2 yea
Time 3 years 3) Assume rate of interest is not given, find out the rate of interest.
Interest PA 10% 4) Find out the duration of the loan.
EMI

Additional Questions

1) If you deposited Rs 800 quarterly and receive 7% interest per annum, what will be the future value after 20 years?
2) You have deposited Rs 500000 for 15 years with 6.5% interest per annum. Out of this you withdraw 15000 at the end of
d out gross interest after 2 years.
ate of interest.

ure value after 20 years?

withdraw 15000 at the end of every year. How much amount will you get after 15 years?
Deal ID Deal Date Deal Owner Company Deal StageAmountDiscountClose Date
12344 7/15/2023 Anand Singh Two Plus Initiate 8000
12345 10/5/2023 Neeti Tamta Coffee Inc Initiate 12000
12346 8/1/2023 Jayant Singh Blue Ocean Negotiate 20000
12347 5/9/2023 Priaynka Julius Triple Solutions Initiate 10000
12348 9/10/2023 Arindam Mishra Bicycle Chain Negotiate 18000
12349 5/2/2023 Anusua Bose Tea Inc Negotiate 5000
12350 10/6/2023 Lipika Agarwal Simple Inc Propose 12000
12351 ### Divya Singh Green MountainsNegotiate 20000
12352 9/8/2023 Pritam Ritu Coffee Inc Qualify 7000
12353 7/4/2023 Ishan Awasthi Elaborate Inc Negotiate 18000

1) Calculate discount by using VLOOKUP function from cell range J2:L5.

2) Calculate close date as follows-

"Initiate"- 30 days after deal date
"Propose"- 60 days after deal date
for others- 75 days after deal date
lose Date From To Discount Budget 2023 Finance
0 5000 0 Sales ###
5000 10000 100 Purchase ###
10000 15000 200 Profit
15000 500
1) What will be sales amount if-
Profit= 825000, at same purchase amou

2)Find sales amount if-

Purchase= Rs 3000000
Profit= 800000
such that Sales Amt <= 4000000
mount if-
e purchase amount?

= 4000000
S. No Name DepartmentGenderMonthly SalaryAnnual Salary
1 Sumit Kushwaha Finance Male 9166.67 110000.00
2 Manoj yadav Marketing Male 12500.00 150000.00
3 Amit Thakur Support Female 7500.00 90000.00
4 Somendra Singh Marketing Female 7083.33 85000.00
5 Mayank Singh Marketing Male 7083.33 85000.00
6 Soni Pal Support Female 6250.00 75000.00
7 Amit Singh Finance Male 5000.00 60000.00
8 Divya Jyoti Support Female 12500.00 150000.00
9 Rahul Mishra Support Female 5833.33 70000.00
10 Anushray Sahni IT Male 5416.67 65000.00
11 Mukul Jain IT Male 4583.33 55000.00
Total 995000

1) Filter the details of Male employees who get >8% of total annual salary.
2) Clear all filters and now filter top 3 monthly salary.
3) Extract records of Finance and Support in another sheet.
4) Copy department column in column J and remove all duplicate values by using Remove Duplicate.
5) Try the same by using Advanced Filter and Conditional Formatting.
6) Highlight the entire rows of database in Greef fill for top 3 Annual Salary and Red fill for bottom 3 Annual Salary.
 % of total annual salary
11.06%
15.08%
9.05%
8.54%
8.54%
7.54%
6.03%
15.08%
7.04%
6.53%
5.53%
100.00%

using Remove Duplicate.

and Red fill for bottom 3 Annual Salary.

Order Id Salesman Zone Product Rate QuantityTotal Price
ORD/34/id Anoop Anand East Keyboard 400.00 10 4000.00
ORD/56/id Nihal Singh North Wireless Mouse 380.00 6 2280.00
ORD/76/id Arun Sharma East LED Monitor 700.00 8 5600.00
ORD/75/id Anoop Anand South Keyboard 400.00 4 1600.00
ORD/05/id Sukhdev Bhatti North CPU Case ### 9 22500.00
ORD/54/id Popat Shinde East Laser Printer ### 9 40500.00
ORD/05/id Popat Shinde East Laser Printer ### 10 45000.00
ORD/45/id Sukhdev Bhatti North CPU Case ### 6 15000.00
ORD/05/id Arun Sharma East LED Monitor 700.00 3 2100.00
ORD/06/id Arun Sharma East LED Monitor 700.00 18 12600.00
ORD/06/id Anoop Anand East Keyboard 400.00 10 4000.00
ORD/07/id Nihal Singh North Wireless Mouse 380.00 6 2280.00
ORD/07/id Arun Sharma East LED Monitor 700.00 8 5600.00
ORD/88/id Anoop Anand South Keyboard 400.00 4 1600.00
ORD/78/id Sukhdev Bhatti North CPU Case ### 9 22500.00
1) Insert heading -"Sales report- April 2024"
2) Copy the data to another sheet and change the heading as "Sales Report- May 2024"
3) Change Order ID and Quantity figures.
4) Go to sheet 3 and consolidate April and may sales reports, and create a link with source data.
5) Change the Quantity figure of F10 as 20 and see the effects in the consolidate table.
6) Subtotal the database by zone-wise Net sales.
Sum of Net Amount City
Segment Bangalore Chennai Delhi Kolkata Mumbai Total Result
Channel Partners 4764100.00 ### ### ### 43596790.00
Enterprise 4016900.00 ### ### ### ### 20028900.00
Government 6273000.00 ### ### ### ### 45415020.00
Midmarket 750100.00 ### ### ### ### 11203250.00
Small Business 90300.00 ### ### ### 25746600.00
Total Result 15894400.00 ### ### ### ### ###

Create a Pivot Table based on Monthly Net Amount, segment with city.
Sum of Net Amount Segment
Months Channel Partners Enterprise Government Midmarket Small Business
Jan 2023000.00
Feb 48000.00 5045600.00 2210100.00 388650.00
Mar 33621000.00 785500.00 649500.00
Apr 2017500.00 8026200.00 114000.00 27000.00
May 1255100.00
Jun 627500.00 2496200.00 15256600.00 3343300.00
Jul 214140.00 1139000.00 2253300.00
Aug 3444600.00 201900.00 3088000.00
Sep 1933500.00 618000.00 2759700.00 3347400.00 19479900.00
Oct 1690550.00 2502000.00 4714800.00 6223200.00
Nov 7980500.00 763500.00 16500.00
Dec 2974420.00 2710900.00
Total Result 43596790.00 ### 45415020.00 ### 25746600.00

Create a Pivot table based on Monthly Net Amount, with segment and date.
Total Result
2023000.00
7692350.00
35056000.00
10184700.00
1255100.00
21723600.00
3606440.00
6734500.00
28138500.00
15130550.00
8760500.00
5685320.00
###
City Sum of Quantity ordered
Bangalore 6760
Chennai 5420
Delhi 10431
Kolkata 7865
Mumbai 8230
Total Result 38706

Create a Pivot table based on city-wise quantity order.

Segment Sum of Net Amount Net Amount by Customer Segment
Channel Partners 43596790.00
Enterprise 20028900.00
Channel
Government 45415020.00 Partners
Midmarket 11203250.00 15%
En
Small Business 25746600.00 Total Result
Total Result 145990560.00 50%

Midmarke
Small Business 4%
9%

1) Create a Pivot chart based on Net Amount with Customer segment.

2) Apply data callout for the same.
3) Insert Slicer for the following-
Bangalore
Delhi
Mumbai
 This shape represents a slicer.
nt by Customer Segment Slicers are supported in Excel
2010 or later.
Channel
Partners If the shape was modified in an
15% earlier version of Excel, or if
Enterprise
7% Channel Partners the workbook was saved in
Enterprise Excel 2003 or earlier, the slicer
Government cannot be used.
Midmarket
Small Business
Total Result
Gov-
ern-
ment
Midmarket 16%
Small Business 4%
9%
City Sum of Unit Price
Bangalore 138750.00
Chennai 59150.00
Delhi 287000.00
750000
Kolkata 55780.00
Mumbai 147080.00 650000
Total Result 687760.00
550000

450000
1) Create a Pivot chart so it will be like the chart shown alongside.
350000

250000

Bangalore; 138750.
150000
Che
50000

Bangalore

Sum of Unit 138750.00

Price
 City-wise Unit Price
750000
Total Result; 687760.00
650000

550000

450000

350000 Sum of Unit Price

Delhi; 287000.00
250000

Bangalore; 138750.00 Mumbai; 147080.00

150000
Chennai; 59150.00 Kolkata; 55780.00
50000

Bangalore Chennai Delhi Kolkata Mumbai Total Result

m of Unit 138750.00 59150.00 287000.00 55780.00 147080.00 687760.00

ce
Date Segment City First_NameLast_Name
1/1/2023 Government Kolkata James Butt
6/1/2023 Midmarket Mumbai Josephine Darakjy
6/1/2023 Midmarket Delhi Art Venere
12/1/2023 Government Delhi Lenna Paprocki
3/1/2023 Midmarket Delhi Donette Foller
6/1/2023 Government Mumbai Simona Morasca
6/1/2023 Channel Partners Delhi Mitsue Tollner
6/1/2023 Midmarket Chennai Leota Dilliard
7/1/2023 Enterprise Kolkata Sage Wieser
9/1/2023 Government Delhi Kris Marrier
10/1/2023 Enterprise Kolkata Minna Amigon
12/1/2023 Midmarket Bangalore Abel Maclead
2/1/2023 Government Kolkata Kiley Caldarera
2/1/2023 Midmarket Chennai Graciela Ruta
6/1/2023 Channel Partners Kolkata Cammy Albares
7/1/2023 Channel Partners Delhi Mattie Poquette
8/1/2023 Government Chennai Meaghan Garufi
9/1/2023 Midmarket Mumbai Gladys Rim
9/1/2023 Small Business Chennai Yuki Whobrey
9/1/2023 Midmarket Chennai Fletcher Flosi
10/1/2023 Government Bangalore Bette Nicka
11/1/2023 Government Kolkata Veronika Inouye
12/1/2023 Midmarket Kolkata Willard Kolmetz
12/1/2023 Government Kolkata Maryann Royster
12/1/2023 Government Delhi Alisha Slusarski
1/1/2023 Government Chennai Allene Iturbide
2/1/2023 Enterprise Mumbai Chanel Caudy
3/1/2023 Channel Partners Delhi Ezekiel Chui
6/1/2023 Government Delhi Willow Kusko
6/1/2023 Channel Partners Delhi Bernardo Figeroa
8/1/2023 Enterprise Bangalore Ammie Corrio
10/1/2023 Enterprise Kolkata Francine Vocelka
4/1/2023 Channel Partners Delhi Ernie Stenseth
6/1/2023 Midmarket Mumbai Albina Glick
6/1/2023 Midmarket Delhi Alishia Sergi
9/1/2023 Government Mumbai Solange Shinko
9/1/2023 Small Business Mumbai Jose Stockham
12/1/2023 Government Kolkata Rozella Ostrosky
2/1/2023 Government Mumbai Valentine Gillian
4/1/2023 Channel Partners Bangalore Kati Rulapaugh
4/1/2023 Enterprise Delhi Youlanda Schemmer
6/1/2023 Government Mumbai Dyan Oldroyd
7/1/2023 Government Delhi Roxane Campain
8/1/2023 Channel Partners Bangalore Lavera Perin
10/1/2023 Government Bangalore Erick Ferencz
12/1/2023 Midmarket Bangalore Fatima Saylors
1/1/2023 Government Mumbai Jina Briddick
 2/1/2023 Midmarket Mumbai Kanisha Waycott
5/1/2023 Government Mumbai Emerson Bowley
11/1/2023 Government Mumbai Blair Malet
3/1/2023 Government Kolkata Brock Bolognia
2/1/2023 Channel Partners Bangalore Lorrie Nestle
3/1/2023 Government Chennai Sabra Uyetake
7/1/2023 Government Bangalore Marjory Mastella
9/1/2023 Channel Partners Kolkata Karl Klonowski
9/1/2023 Enterprise Bangalore Tonette Wenner
9/1/2023 Channel Partners Mumbai Amber Monarrez
10/1/2023 Channel Partners Delhi Shenika Seewald
10/1/2023 Small Business Chennai Delmy Ahle
10/1/2023 Government Chennai Deeanna Juhas
12/1/2023 Government Mumbai Blondell Pugh
3/1/2023 Midmarket Chennai Jamal Vanausdal
4/1/2023 Small Business Bangalore Cecily Hollack
7/1/2023 Government Mumbai Carmelina Lindall
8/1/2023 Government Kolkata Maurine Yglesias
9/1/2023 Small Business Bangalore Tawna Buvens
10/1/2023 Enterprise Bangalore Penney Weight
2/1/2023 Midmarket Bangalore Elly Morocco
4/1/2023 Government Bangalore Ilene Eroman
6/1/2023 Enterprise Bangalore Vallie Mondella
6/1/2023 Enterprise Mumbai Kallie Blackwood
7/1/2023 Enterprise Chennai Johnetta Abdallah
9/1/2023 Midmarket Delhi Bobbye Rhym
10/1/2023 Channel Partners Delhi Micaela Rhymes
11/1/2023 Small Business Bangalore Tamar Hoogland
12/1/2023 Government Mumbai Moon Parlato
5/1/2023 Government Chennai Laurel Reitler
8/1/2023 Enterprise Kolkata Delisa Crupi
10/1/2023 Enterprise Bangalore Viva Toelkes
3/1/2023 Government Delhi Elza Lipke
4/1/2023 Government Kolkata Devorah Chickering
6/1/2023 Enterprise Bangalore Timothy Mulqueen
6/1/2023 Enterprise Mumbai Arlette Honeywell
9/1/2023 Small Business Delhi Dominque Dickerson
10/1/2023 Small Business Chennai Lettie Isenhower
10/1/2023 Government Chennai Myra Munns
9/1/2023 Channel Partners Bangalore Stephaine Barfield
11/1/2023 Midmarket Mumbai Lai Gato
4/1/2023 Enterprise Kolkata Stephen Emigh
10/1/2023 Channel Partners Kolkata Tyra Shields
10/1/2023 Small Business Delhi Tammara Wardrip
11/1/2023 Government Mumbai Cory Gibes
12/1/2023 Government Kolkata Danica Bruschke
6/1/2023 Channel Partners Bangalore Wilda Giguere
10/1/2023 Government Bangalore Elvera Benimadho
Company_Name Phone1 Product Sub-Category Quantit
Benton, John B Jr 504-621-8927Pens & Art Supplies 870
Chanay, Jeffrey A Esq 810-292-9388Chairs & Chairmats 25
Chemel, James L Cpa 856-636-8749Office Furnishings 680
Feltz Printing Service 907-385-4412Office Furnishings 258
Printing Dimensions 513-570-1893Pens & Art Supplies 800
Chapman, Ross E Esq 419-503-2484Pens & Art Supplies 780
Morlong Associates 773-573-6914Rubber Bands 690
Commercial Press 408-752-3500Envelopes 750
Truhlar And Truhlar Attys 605-414-2147Envelopes 450
King, Christopher A Esq 410-655-8723Rubber Bands 950
Dorl, James J Esq 215-874-1229Telephones and Communication 150
Rangoni Of Florence 631-335-3414Office Furnishings 260
Feiner Bros 310-498-5651Office Machines 870
Buckley Miller & Wright 440-780-8425Office Furnishings 25
Rousseaux, Michael Esq 956-537-6195Rubber Bands 680
Century Communications 602-277-4385Office Machines 258
Bolton, Wilbur Esq 931-313-9635Paper 800
T M Byxbee Company Pc 414-661-9598Pens & Art Supplies 780
Farmers Insurance Group 313-288-7937Office Furnishings 690
Post Box Services Plus 815-828-2147Pens & Art Supplies 750
Sport En Art 610-545-3615Office Machines 450
C 4 Network Inc 408-540-1785Telephones and Communication 950
Ingalls, Donald R Esq 972-303-9197Telephones and Communication 150
Franklin, Peter L Esq 518-966-7987Binders and Binder Accessories 260
Wtlz Power 107 Fm 732-658-3154Pens & Art Supplies 870
Ledecky, David Esq 715-662-6764Office Machines 25
Professional Image Inc 913-388-2079Telephones and Communication 680
Sider, Donald C Esq 410-669-1642Office Machines 150
U Pull It 212-582-4976Paper 800
Clark, Richard Cpa 936-336-3951Binders and Binder Accessories 780
Moskowitz, Barry S 614-801-9788Pens & Art Supplies 690
Cascade Realty Advisors Inc 505-977-3911Paper 750
Knwz Newsradio 201-709-6245Paper 450
Giampetro, Anthony D 732-924-7882Labels 950
Milford Enterprises Inc 212-860-1579Telephones and Communication 150
Mosocco, Ronald A 504-979-9175Storage & Organization 260
Tri State Refueler Co 212-675-8570Chairs & Chairmats 870
Parkway Company 805-832-6163Chairs & Chairmats 25
Fbs Business Finance 210-812-9597Storage & Organization 150
Eder Assocs Consltng Engrs Pc 785-463-7829Chairs & Chairmats 150
Tri M Tool Inc 541-548-8197Chairs & Chairmats 800
International Eyelets Inc 913-413-4604Tables 780
Rapid Trading Intl 907-231-4722Office Furnishings 690
Abc Enterprises Inc 305-606-7291Binders and Binder Accessories 60
Cindy Turner Associates 907-741-1044Storage & Organization 150
Stanton, James D Esq 952-768-2416Labels 950
Grace Pastries Inc 617-399-5124Tables 90
Schroer, Gene E Esq 323-453-2780Pens & Art Supplies 260
Knights Inn 608-336-7444Paper 870
Bollinger Mach Shp & Shipyard 215-907-9111Telephones and Communication 25
Orinda News 212-402-9216Paper 150
Ballard Spahr Andrews 931-875-6644Paper 150
Lowy Limousine Service 803-925-5213Scissors, Rulers and Trimmers 800
Vicon Corporation 610-814-5533Chairs & Chairmats 180
Rossi, Michael M 908-877-6135Computer Peripherals 690
Northwest Publishing 516-968-6051Chairs & Chairmats 60
Branford Wire & Mfg Co 215-934-8655Telephones and Communication 150
East Coast Marketing 818-423-4007Computer Peripherals 950
Wye Technologies Inc 401-458-2547Bookcases 90
Healy, George W Iv 215-211-9589Computer Peripherals 260
Alpenlite Inc 401-960-8259Binders and Binder Accessories 870
Hubbard, Bruce Esq 732-234-1546Bookcases 25
Arthur A Oliver & Son Inc 512-486-3817Binders and Binder Accessories 150
George Jessop Carter Jewelers 303-724-7371Pens & Art Supplies 150
Schultz, Thomas C Md 414-748-1374Labels 800
H H H Enterprises Inc 212-674-9610Paper 180
Hawaiian King Hotel 907-797-9628Computer Peripherals 690
Killion Industries 814-393-5571Pens & Art Supplies 60
Robinson, William J Esq 410-914-9018Labels 150
Private Properties 208-862-5339Paper 950
Rowley Schlimgen Inc 415-315-2761Computer Peripherals 90
Forging Specialties 919-225-9345Labels 260
Smits, Patricia Garity 650-528-5783Telephones and Communication 120
H Lee Leonard Attorney At Law 925-647-3298Scissors, Rulers and Trimmers 25
A K Construction Co 740-343-8575Office Furnishings 150
Ambelang, Jessica M Md 585-866-8313Envelopes 150
Q A Service 410-520-4832Paper 800
Wood & Whitacre Contractors 973-354-2040Scissors, Rulers and Trimmers 180
Mark Iv Press Ltd 773-446-5569Paper 690
Museum Of Science & Industry 973-927-3447Scissors, Rulers and Trimmers 60
Garrison Ind 505-975-8559Paper 150
Saronix Nymph Products 718-332-6527Tables 200
Smc Inc 904-775-4480Office Furnishings 90
E A I Electronic Assocs Inc 510-993-3758Chairs & Chairmats 260
Conte, Christopher A Esq 216-657-7668Computer Peripherals 120
Anker Law Office 817-914-7518Envelopes 25
Beutelschies & Company 310-774-7643Pens & Art Supplies 150
Fligg, Kenneth I Jr 847-728-7286Office Furnishings 150
Sharp, J Daniel Esq 330-537-5358Telephones and Communication 410
Assink, Anne H Esq 215-255-1641Computer Peripherals 180
Jewel My Shop Inc 650-803-1936Telephones and Communication 690
Chinese Translation Resources 626-572-1096Appliances 60
Stevens, Charles T 254-782-8569Bookcases 150
Mclaughlin, Luther W Cpa 907-870-5536Paper 200
Tree Musketeers 408-703-8505Office Machines 90
Paper 210
Telephones and Communication 60
Office Furnishings 150
Bookcases 200
Office Machines 90
Labels 260
Telephones and Communication 120
Storage & Organization 25
Paper 150
Telephones and Communication 150
Binders and Binder Accessories 410
Telephones and Communication 180
Bookcases 210
Appliances 60
Rubber Bands 150
Paper 200
Binders and Binder Accessories 90
Copiers and Fax 260
Paper 120
Envelopes 25
Computer Peripherals 150
Paper 150
Envelopes 410
Binders and Binder Accessories 180
Binders and Binder Accessories 210
Copiers and Fax 60
Computer Peripherals 150
Paper 200
Office Machines 90
Chairs & Chairmats 260
Appliances 120
Paper 25
Office Furnishings 150
Paper 150
Paper 410
Telephones and Communication 180
Bookcases 210
Envelopes 60
Telephones and Communication 150
Appliances 200
Chairs & Chairmats 90
Computer Peripherals 260
Tables 120
Labels 25
Telephones and Communication 150
Office Machines 150
Appliances 410
Office Machines 180
Appliances 210
Office Furnishings 60
Office Furnishings 150
Binders and Binder Accessories 200
Office Furnishings 90
Office Furnishings 260
Binders and Binder Accessories 120
Pens & Art Supplies 25
Binders and Binder Accessories 150
Computer Peripherals 150
Binders and Binder Accessories 410
Binders and Binder Accessories 180
Chairs & Chairmats 210
Storage & Organization 60
Binders and Binder Accessories 150
Pens & Art Supplies 200
Computer Peripherals 90
Labels 260
Binders and Binder Accessories 120
Copiers and Fax 25
Computer Peripherals 150
Paper 150
Pens & Art Supplies 410
Chairs & Chairmats 180
Scissors, Rulers and Trimmers 210
Chairs & Chairmats 60
Binders and Binder Accessories 150
Computer Peripherals 200
Envelopes 90
Computer Peripherals 260
Binders and Binder Accessories 120
Computer Peripherals 25
Computer Peripherals 150
Telephones and Communication 150
Chairs & Chairmats 410
Office Furnishings 180
Office Machines 210
Telephones and Communication 60
Chairs & Chairmats 150
Binders and Binder Accessories 200
Office Machines 90
Binders and Binder Accessories 260
Office Furnishings 120
Computer Peripherals 25
Binders and Binder Accessories 150
Office Furnishings 150
Binders and Binder Accessories 410
Chairs & Chairmats 180
Paper 210
Appliances 60
Bookcases 150
Tables 200
Binders and Binder Accessories 90
Storage & Organization 260
Rubber Bands 120
Office Machines 25
Scissors, Rulers and Trimmers 150
Envelopes 150
Computer Peripherals 410
Paper 180
Office Machines 210
Chairs & Chairmats 60
Computer Peripherals 150
Telephones and Communication 200
Office Furnishings 90
Binders and Binder Accessories 260
Office Machines 120
Binders and Binder Accessories 25
Chairs & Chairmats 150
Copiers and Fax 150
Chairs & Chairmats 410
Copiers and Fax 180
Office Machines 210
Storage & Organization 60
Computer Peripherals 150
Telephones and Communication 200
Labels 90
Office Furnishings 260
Computer Peripherals 120
Binders and Binder Accessories 25
Telephones and Communication 150
Storage & Organization 150
Storage & Organization 410
Binders and Binder Accessories 180
Binders and Binder Accessories 210
Telephones and Communication 60
Storage & Organization 150
Storage & Organization 200
Telephones and Communication 90
Binders and Binder Accessories 260
Storage & Organization 120
Telephones and Communication 25
Pens & Art Supplies 150
Storage & Organization 150
Computer Peripherals 410
Pens & Art Supplies 180
Rubber Bands 210
Office Furnishings 60
Telephones and Communication 150
Office Furnishings 200
Labels 90
Labels 260
Telephones and Communication 120
Office Machines 25
Office Furnishings 150
Labels 150
Paper 410
Telephones and Communication 180
Binders and Binder Accessories 210
Rubber Bands 60
Paper 150
Computer Peripherals 200
Binders and Binder Accessories 90
Envelopes 260
Appliances 120
Labels 25
Office Furnishings 150
Storage & Organization 150
Appliances 410
Office Furnishings 180
Rubber Bands 210
Labels 60
Paper 150
Telephones and Communication 200
Pens & Art Supplies 90
Storage & Organization 260
Binders and Binder Accessories 120
Computer Peripherals 25
Binders and Binder Accessories 150
Computer Peripherals 150
Telephones and Communication 410
Pens & Art Supplies 180
Telephones and Communication 210
Computer Peripherals 60
Tables 150
Appliances 200
Pens & Art Supplies 90
Tables 260
Chairs & Chairmats 120
Envelopes 25
Rubber Bands 150
Binders and Binder Accessories 150
Office Machines 410
Telephones and Communication 180
Envelopes 210
Envelopes 60
Pens & Art Supplies 150
Chairs & Chairmats 200
Storage & Organization 90
Storage & Organization 260
Paper 120
Appliances 25
Binders and Binder Accessories 150
Office Furnishings 150
Chairs & Chairmats 410
Telephones and Communication 180
Binders and Binder Accessories 210
Telephones and Communication 60
Bookcases 150
Office Furnishings 200
Tables 90
Binders and Binder Accessories 260
Computer Peripherals 120
Appliances 25
Computer Peripherals 150
Paper 150
Paper 410
Office Furnishings 180
Computer Peripherals 210
Storage & Organization 60
Telephones and Communication 150
Binders and Binder Accessories 200
Storage & Organization 90
Storage & Organization 260
Office Machines 120
Office Furnishings 25
Paper 150
Office Furnishings 150
Storage & Organization 410
Binders and Binder Accessories 180
Paper 210
Tables 60
Labels 150
Pens & Art Supplies 200
Telephones and Communication 90
Telephones and Communication 260
Binders and Binder Accessories 120
Paper 25
Chairs & Chairmats 150
Paper 150
Pens & Art Supplies 410
Telephones and Communication 180
Computer Peripherals 210
Binders and Binder Accessories 60
Labels 150
Computer Peripherals 200
Paper 90
Copiers and Fax 260
Storage & Organization 120
Tables 25
Paper 150
Appliances 150
Tables 410
Labels 180
Paper 210
Appliances 60
Computer Peripherals 150
Chairs & Chairmats 200
Paper 90
Office Furnishings 260
Computer Peripherals 120
Envelopes 25
Office Furnishings 150
Binders and Binder Accessories 150
Chairs & Chairmats 410
Office Furnishings 180
Pens & Art Supplies 210
Paper 60
Rubber Bands 150
Tables 200
Binders and Binder Accessories 90
Copiers and Fax 260
Office Machines 120
Binders and Binder Accessories 25
Scissors, Rulers and Trimmers 150
Binders and Binder Accessories 150
Storage & Organization 410
Computer Peripherals 180
Scissors, Rulers and Trimmers 210
Telephones and Communication 60
Binders and Binder Accessories 150
Computer Peripherals 200
Storage & Organization 90
Office Machines 260
Paper 120
Storage & Organization 25
Tables 150
Storage & Organization 150
Office Furnishings 410
Pens & Art Supplies 180
Computer Peripherals 210
Office Machines 60
Office Machines 150
Pens & Art Supplies 200
Office Furnishings 90
Paper 260
Office Furnishings 120
Rubber Bands 25
Appliances 150
Scissors, Rulers and Trimmers 150
Appliances 410
Computer Peripherals 180
Labels 210
Telephones and Communication 60
Storage & Organization 150
Telephones and Communication 200
Paper 90
Computer Peripherals 260
Storage & Organization 120
Labels 25
Binders and Binder Accessories 150
Chairs & Chairmats 150
Paper 410
Office Furnishings 180
Envelopes 210
Office Furnishings 60
Office Furnishings 150
Paper 200
Office Furnishings 90
Paper 260
Office Furnishings 120
Storage & Organization 25
Telephones and Communication 150
Storage & Organization 150
Scissors, Rulers and Trimmers 410
Paper 180
Envelopes 210
Storage & Organization 60
Binders and Binder Accessories 150
Paper 200
Appliances 90
Paper 260
Envelopes 120
Telephones and Communication 25
Binders and Binder Accessories 150
Storage & Organization 150
Office Furnishings 410
Pens & Art Supplies 180
Office Machines 210
Chairs & Chairmats 60
Computer Peripherals 150
Storage & Organization 200
Computer Peripherals 90
Paper 260
Storage & Organization 120
Storage & Organization 25
Telephones and Communication 150
Storage & Organization 150
Paper 410
Telephones and Communication 180
Appliances 210
Binders and Binder Accessories 60
Paper 150
Appliances 200
Binders and Binder Accessories 90
Telephones and Communication 260
Paper 120
Office Furnishings 25
Pens & Art Supplies 150
Telephones and Communication 150
Paper 410
Tables 180
Telephones and Communication 210
Labels 60
Office Furnishings 150
Tables 200
Telephones and Communication 90
Tables 260
Labels 120
Office Furnishings 25
Computer Peripherals 150
Office Machines 150
Telephones and Communication 410
Telephones and Communication 180
Office Furnishings 210
Office Furnishings 60
Binders and Binder Accessories 150
Computer Peripherals 200
Appliances 90
Binders and Binder Accessories 260
Paper 120
Paper 25
Paper 150
Office Furnishings 150
Office Machines 410
Paper 180
Paper 210
Office Furnishings 60
Pens & Art Supplies 150
Telephones and Communication 200
Bookcases 90
Scissors, Rulers and Trimmers 260
Computer Peripherals 120
Computer Peripherals 25
Pens & Art Supplies 150
Office Machines 150
Pens & Art Supplies 410
Office Machines 180
Paper 210
Pens & Art Supplies 60
Office Furnishings 150
Office Machines 200
Paper 90
Telephones and Communication 260
Storage & Organization 120
Paper 25
Pens & Art Supplies 150
Bookcases 150
Telephones and Communication 410
Paper 180
Binders and Binder Accessories 210
Computer Peripherals 60
Office Furnishings 150
Binders and Binder Accessories 200
Binders and Binder Accessories 90
Storage & Organization 260
Telephones and Communication 120
Paper 25
Unit Price Net Amount
180.00 156600.00
32060.00 801500.00
610.00 414800.00
5040.00 1300320.00
210.00 168000.00
210.00 163800.00
230.00 158700.00
280.00 210000.00
2300.00 1035000.00
190.00 180500.00
7420.00 1113000.00
1690.00 439400.00
830.00 722100.00
1690.00 42250.00
320.00 217600.00
830.00 214140.00
3550.00 2840000.00
110.00 85800.00
260.00 179400.00
2240.00 1680000.00
1150.00 517500.00
8060.00 7657000.00
13180.00 1977000.00
270.00 70200.00
190.00 165300.00
6400.00 160000.00
7420.00 5045600.00
224140.00 ###
380.00 304000.00
240.00 187200.00
110.00 75900.00
380.00 285000.00
1860.00 837000.00
240.00 228000.00
11260.00 1689000.00
9920.00 2579200.00
18670.00 ###
6460.00 161500.00
9920.00 1488000.00
7870.00 1180500.00
7870.00 6296000.00
18960.00 ###
520.00 358800.00
57410.00 3444600.00
10340.00 1551000.00
310.00 294500.00
18960.00 1706400.00
 1270.00 330200.00
330.00 287100.00
11260.00 281500.00
530.00 79500.00
320.00 48000.00
830.00 664000.00
10300.00 1854000.00
1150.00 793500.00
10300.00 618000.00
7420.00 1113000.00
1280.00 1216000.00
19260.00 1733400.00
1280.00 332800.00
180.00 156600.00
19260.00 481500.00
180.00 27000.00
270.00 40500.00
310.00 248000.00
260.00 46800.00
140.00 96600.00
270.00 16200.00
310.00 46500.00
260.00 247000.00
140.00 12600.00
400.00 104000.00
13180.00 1581600.00
550.00 13750.00
110.00 16500.00
1010.00 151500.00
1210.00 968000.00
700.00 126000.00
1460.00 1007400.00
700.00 42000.00
450.00 67500.00
9860.00 1972000.00
2940.00 264600.00
11580.00 3010800.00
2110.00 253200.00
380.00 9500.00
180.00 27000.00
5090.00 763500.00
4220.00 1730200.00
2560.00 460800.00
6140.00 4236600.00
700.00 42000.00
6460.00 969000.00
320.00 64000.00
25600.00 2304000.00
 410.00 86100.00
4220.00 253200.00
540.00 81000.00
19260.00 3852000.00
163210.00 ###
 180.00 46800.00
3580.00 429600.00
4140.00 103500.00
1280.00 192000.00
8060.00 1209000.00
470.00 192700.00
11260.00 2026800.00
10300.00 2163000.00
260.00 15600.00
300.00 45000.00
270.00 54000.00
550.00 49500.00
44800.00 ###
370.00 44400.00
490.00 12250.00
1980.00 297000.00
320.00 48000.00
490.00 200900.00
410.00 73800.00
550.00 115500.00
44800.00 2688000.00
1980.00 297000.00
320.00 64000.00
17340.00 1560600.00
10300.00 2678000.00
23250.00 2790000.00
1210.00 30250.00
490.00 73500.00
580.00 87000.00
960.00 393600.00
11260.00 2026800.00
6460.00 1356600.00
630.00 37800.00
12860.00 1929000.00
290.00 58000.00
22460.00 2021400.00
2620.00 681200.00
22360.00 2683200.00
170.00 4250.00
2300.00 345000.00
434110.00 ###
750.00 307500.00
25660.00 4618800.00
700.00 147000.00
680.00 40800.00
510.00 76500.00
1830.00 366000.00
680.00 61200.00
 510.00 132600.00
3350.00 402000.00
2340.00 58500.00
380.00 57000.00
3200.00 480000.00
1830.00 750300.00
380.00 68400.00
22780.00 4783800.00
970.00 58200.00
3350.00 502500.00
2340.00 468000.00
3200.00 288000.00
200.00 52000.00
310.00 37200.00
224000.00 5600000.00
1910.00 286500.00
530.00 79500.00
370.00 151700.00
8380.00 1508400.00
530.00 111300.00
8380.00 502800.00
450.00 67500.00
320.00 64000.00
360.00 32400.00
320.00 83200.00
7740.00 928800.00
9760.00 244000.00
6400.00 960000.00
13180.00 1977000.00
8210.00 3366100.00
470.00 84600.00
19260.00 4044600.00
13180.00 790800.00
10300.00 1545000.00
24830.00 4966000.00
12860.00 1157400.00
1430.00 371800.00
450.00 54000.00
16450.00 411250.00
1430.00 214500.00
450.00 67500.00
250.00 102500.00
7740.00 1393200.00
1980.00 415800.00
3000.00 180000.00
9020.00 1353000.00
13610.00 2722000.00
130.00 11700.00
 5180.00 1346800.00
250.00 30000.00
7420.00 185500.00
160.00 24000.00
240.00 36000.00
4730.00 1939300.00
340.00 61200.00
900.00 189000.00
8210.00 492600.00
380.00 57000.00
8060.00 1612000.00
2190.00 197100.00
2620.00 681200.00
28300.00 3396000.00
2620.00 65500.00
15260.00 2289000.00
12800.00 1920000.00
15260.00 6256600.00
12800.00 2304000.00
9660.00 2028600.00
11280.00 676800.00
2530.00 379500.00
4220.00 844000.00
180.00 16200.00
3980.00 1034800.00
530.00 63600.00
340.00 8500.00
3580.00 537000.00
5180.00 777000.00
17890.00 7334900.00
310.00 55800.00
340.00 71400.00
3580.00 214800.00
5180.00 777000.00
17890.00 3578000.00
3580.00 322200.00
1430.00 371800.00
380.00 45600.00
3580.00 89500.00
250.00 37500.00
380.00 57000.00
1340.00 549400.00
250.00 45000.00
170.00 35700.00
780.00 46800.00
7100.00 1065000.00
1130.00 226000.00
260.00 23400.00
 320.00 83200.00
8060.00 967200.00
7680.00 192000.00
920.00 138000.00
180.00 27000.00
410.00 168100.00
5500.00 990000.00
830.00 174300.00
370.00 22200.00
380.00 57000.00
4730.00 946000.00
290.00 26100.00
630.00 163800.00
2820.00 338400.00
180.00 4500.00
140.00 21000.00
720.00 108000.00
4540.00 1861400.00
110.00 19800.00
170.00 35700.00
170.00 10200.00
520.00 78000.00
7100.00 1420000.00
180.00 16200.00
790.00 205400.00
550.00 66000.00
1970.00 49250.00
550.00 82500.00
1970.00 295500.00
4220.00 1730200.00
220.00 39600.00
4220.00 886200.00
1050.00 63000.00
26710.00 4006500.00
3000.00 600000.00
310.00 27900.00
7970.00 2072200.00
22460.00 2695200.00
560.00 14000.00
130.00 19500.00
510.00 76500.00
130330.00 ###
8060.00 1450800.00
630.00 132300.00
700.00 42000.00
210.00 31500.00
19260.00 3852000.00
1340.00 120600.00
 5180.00 1346800.00
410.00 49200.00
11390.00 284750.00
1020.00 153000.00
3000.00 450000.00
13960.00 5723600.00
5500.00 990000.00
830.00 174300.00
4220.00 253200.00
8380.00 1257000.00
6740.00 1348000.00
2030.00 182700.00
26940.00 7004400.00
1980.00 237600.00
1300.00 32500.00
630.00 94500.00
570.00 85500.00
570.00 233700.00
620.00 111600.00
6400.00 1344000.00
12360.00 741600.00
1340.00 201000.00
740.00 148000.00
1000.00 90000.00
14400.00 3744000.00
7680.00 921600.00
540.00 13500.00
410.00 61500.00
400.00 60000.00
970.00 397700.00
140.00 25200.00
410.00 86100.00
9350.00 561000.00
240.00 36000.00
370.00 74000.00
13180.00 1186200.00
5500.00 1430000.00
1340.00 160800.00
3550.00 88750.00
7870.00 1180500.00
730.00 109500.00
1980.00 811800.00
4220.00 759600.00
3260.00 684600.00
33660.00 2019600.00
310.00 46500.00
310.00 62000.00
640.00 57600.00
 38400.00 9984000.00
1130.00 135600.00
22290.00 557250.00
790.00 118500.00
700.00 105000.00
7970.00 3267700.00
180.00 32400.00
1460.00 306600.00
3900.00 234000.00
1910.00 286500.00
14510.00 2902000.00
730.00 65700.00
780.00 202800.00
1340.00 160800.00
740.00 18500.00
1220.00 183000.00
350.00 52500.00
32060.00 ###
630.00 113400.00
210.00 44100.00
580.00 34800.00
140.00 21000.00
11470.00 2294000.00
130.00 11700.00
44800.00 ###
434110.00 ###
970.00 24250.00
360.00 54000.00
140.00 21000.00
620.00 254200.00
2620.00 471600.00
820.00 172200.00
2940.00 176400.00
960.00 144000.00
2590.00 518000.00
790.00 71100.00
13660.00 3551600.00
3580.00 429600.00
1030.00 25750.00
13400.00 2010000.00
2790.00 418500.00
520.00 213200.00
1660.00 298800.00
380.00 79800.00
6460.00 387600.00
7420.00 1113000.00
270.00 54000.00
8770.00 789300.00
 3550.00 923000.00
6880.00 825600.00
210.00 5250.00
3000.00 450000.00
830.00 124500.00
3110.00 1275100.00
410.00 73800.00
800.00 168000.00
4220.00 253200.00
6490.00 973500.00
6140.00 1228000.00
230.00 20700.00
2270.00 590200.00
9140.00 1096800.00
260.00 6500.00
14330.00 2149500.00
18240.00 2736000.00
3550.00 1455500.00
880.00 158400.00
1980.00 415800.00
3160.00 189600.00
400.00 60000.00
320.00 64000.00
400.00 36000.00
320.00 83200.00
130.00 15600.00
3130.00 78250.00
7420.00 1113000.00
6110.00 916500.00
440.00 180400.00
1980.00 356400.00
1000.00 210000.00
860.00 51600.00
250.00 37500.00
410.00 82000.00
950.00 85500.00
270.00 70200.00
360.00 43200.00
13180.00 329500.00
910.00 136500.00
6110.00 916500.00
490.00 200900.00
750.00 135000.00
1540.00 323400.00
19260.00 1155600.00
1050.00 157500.00
800.00 160000.00
3200.00 288000.00
 430.00 111800.00
1130.00 135600.00
800.00 20000.00
2300.00 345000.00
960.00 144000.00
3550.00 1455500.00
4220.00 759600.00
3900.00 819000.00
81340.00 4880400.00
1980.00 297000.00
3900.00 780000.00
81340.00 7320600.00
13180.00 3426800.00
1980.00 237600.00
1980.00 49500.00
110.00 16500.00
11260.00 1689000.00
2270.00 930700.00
22360.00 4024800.00
3580.00 751800.00
260.00 15600.00
3880.00 582000.00
7970.00 1594000.00
2300.00 207000.00
7970.00 2072200.00
260.00 31200.00
3880.00 97000.00
540.00 81000.00
1020.00 153000.00
6140.00 2517400.00
7420.00 1335600.00
1280.00 268800.00
110.00 6600.00
370.00 55500.00
3260.00 652000.00
3900.00 351000.00
830.00 215800.00
370.00 44400.00
350.00 8750.00
640.00 96000.00
1280.00 192000.00
900.00 369000.00
960.00 172800.00
3550.00 745500.00
330.00 19800.00
210.00 31500.00
13180.00 2636000.00
56380.00 5074200.00
 240.00 62400.00
520.00 62400.00
4960.00 124000.00
180.00 27000.00
5820.00 873000.00
670.00 274700.00
1150.00 207000.00
640.00 134400.00
670.00 40200.00
1190.00 178500.00
1150.00 230000.00
640.00 57600.00
11260.00 2927600.00
3390.00 406800.00
590.00 14750.00
380.00 57000.00
6460.00 969000.00
5500.00 2255000.00
380.00 68400.00
450.00 94500.00
1340.00 80400.00
680.00 102000.00
2500.00 500000.00
230.00 20700.00
990.00 257400.00
9980.00 1197600.00
380.00 9500.00
Emp ID Name Jan Collection Feb Collection Mar Collection Total Collection
AIT-51 Abu 44000 528000 80000
AIT-52 Hamnah 10000 120000 30000
AIT-53 Lucky 20000 240000 18000
AIT-54 Milind 80000 960000 28000
AIT-55 Yakub 30000 360000 40000
AIT-56 Dolly 18000 216000 75000
AIT-57 Mahesh 28000 336000 4032000
AIT-58 Paresh 40000 480000 5760000
AIT-59 Aarav 75000 900000 10800000
AIT-60 Julie 59000 708000 8496000
AIT-61 Alisha 25000 300000 10000
AIT-62 Bhupesh 13000 156000 20000
AIT-63 Rajinder 9000 108000 80000
AIT-64 Parul 59000 708000 54000
510000 6120000 29523000 0

Download the workbook Assignment-15 from student login portal and do the following-
1) Find the total collection of Jan, Feb and Mar.
2) Find out the total amount through Quick Analysis of each month.
3) Insert Chart through Quick Analysis.
4) Insert Sparklines in column G of each month's sales.
5) Insert Data Bar in each month's sales by using Quick Analysis tool.
6) In cell F18 calculate the top 3 total amounts by using array formula.
7) Copy the above table and paste it in NotePad, and save it.
8) Open another workbook and import data from your NotePad file.
 Employee Progress Card
Emp_CodeEmp_Name Apr May Jun Jul Aug Sep Oct
AIT-001 PQR1 82 54 61 55 45 55 61
AIT-002 PQR2 23 54 50 30 45 54 30
AIT-003 PQR3 43 43 59 89 4 45 26
AIT-004 PQR4 5 43 72 58 4 56 55
AIT-005 PQR5 345 54 80 61 3 57 77
AIT-006 PQR6 43 4 80 47 43 35 47
AIT-007 PQR7 534 44 49 50 5 34 73
AIT-008 PQR8 5 34 39 66 43 54 51
AIT-009 PQR9 34 345 39 90 5 87 27
AIT-010 PQR10 34 23 39 51 45 53 42
AIT-011 PQR11 5 345 43 33 43 39 57
AIT-012 PQR12 35 34 63 30 5 35 59
AIT-013 PQR13 34 5 62 35 345 62 58
AIT-014 PQR14 534 345 68 68 43 82 38
AIT-015 PQR15 5 43 55 52 5 88 25
AIT-016 PQR16 3 5 70 36 345 85 24
AIT-017 PQR17 3 345 77 28 43 72 55
AIT-018 PQR18 43 43 34 32 5 68 51
AIT-019 PQR19 5 543 31 48 345 91 80
AIT-020 PQR20 345 54 85 43 43 41 68
AIT-021 PQR21 4 64 34 88 543 58 64
AIT-022 PQR22 54 57 80 91 51 56 91
AIT-023 PQR23 79 55 65 55 34 78 61
AIT-024 PQR24 41 69 70 50 543 36 43
AIT-025 PQR25 25 35 38 32 4 49 43
AIT-026 PQR26 26 36 88 70 3 28 58
AIT-027 PQR27 42 57 61 38 67 48 73
AIT-028 PQR28 70 58 33 31 24 80 85
AIT-029 PQR29 87 31 52 54 27 25 63
AIT-030 PQR30 46 48 91 51 53 72 58
AIT-031 PQR31 41 88 77 45 73 77 74
AIT-032 PQR32 78 78 57 57 46 87 77
AIT-033 PQR33 70 66 71 74 61 50 89
AIT-034 PQR34 67 29 58 51 28 39 28
AIT-035 PQR35 75 81 70 28 35 59 31
AIT-036 PQR36 60 33 91 79 41 67 84
AIT-037 PQR37 33 25 55 71 37 40 81
AIT-038 PQR38 43 28 77 39 28 28 57
AIT-039 PQR39 71 50 73 65 64 40 62
AIT-040 PQR40 44 85 74 60 47 63 39
AIT-041 PQR41 77 53 29 59 65 59 58
AIT-042 PQR42 28 78 26 57 77 91 78
AIT-043 PQR43 74 29 81 55 89 56 30
AIT-044 PQR44 54 90 55 78 44 43 44
AIT-045 PQR45 67 67 49 55 75 66 30
AIT-046 PQR46 27 77 52 62 31 63 62
AIT-047 PQR47 91 60 28 76 46 89 38
AIT-048 PQR48 47 77 75 79 60 37 83
AIT-049 PQR49 81 32 44 34 78 67 72
AIT-050 PQR50 77 66 29 46 68 59 54
AIT-051 PQR51 69 39 48 67 87 87 84
AIT-052 PQR52 55 51 52 32 54 79 29
AIT-053 PQR53 51 66 69 32 60 34 69
AIT-054 PQR54 46 91 81 33 86 30 60
AIT-055 PQR55 30 46 88 80 62 49 87
AIT-056 PQR56 44 52 60 70 55 35 44
AIT-057 PQR57 45 76 72 52 31 52 46
AIT-058 PQR58 57 33 88 87 69 34 45
AIT-059 PQR59 73 52 25 67 38 56 25
AIT-060 PQR60 84 44 38 77 68 80 51
AIT-061 PQR61 28 35 24 57 33 30 83
AIT-062 PQR62 57 24 50 44 25 75 55
AIT-063 PQR63 69 52 31 28 89 74 83
AIT-064 PQR64 79 32 37 79 50 67 41
AIT-065 PQR65 39 69 68 65 51 86 53
AIT-066 PQR66 74 86 91 81 59 68 63
AIT-067 PQR67 33 60 72 56 38 90 89
AIT-068 PQR68 49 66 56 60 52 33 49
AIT-069 PQR69 30 66 81 44 66 90 80
AIT-070 PQR70 39 40 34 73 26 71 84
AIT-071 PQR71 87 57 39 84 62 70 56
AIT-072 PQR72 30 55 24 60 82 69 28
AIT-073 PQR73 57 44 44 73 68 51 26
AIT-074 PQR74 47 83 66 24 72 33 43
AIT-075 PQR75 50 46 25 61 45 72 52
AIT-076 PQR76 27 34 61 60 73 25 76
AIT-077 PQR77 87 24 80 87 29 56 35
AIT-078 PQR78 76 26 29 85 64 74 30
AIT-079 PQR79 89 43 69 32 87 53 62
AIT-080 PQR80 89 69 40 69 65 83 64
AIT-081 PQR81 89 62 66 77 72 48 76
AIT-082 PQR82 38 31 90 76 52 82 85
AIT-083 PQR83 36 88 26 33 57 51 91
AIT-084 PQR84 30 50 28 81 76 53 71
AIT-085 PQR85 51 64 28 36 74 39 35
AIT-086 PQR86 52 46 75 66 72 64 81
AIT-087 PQR87 54 62 72 54 65 32 50
AIT-088 PQR88 66 26 42 38 29 45 81
AIT-089 PQR89 24 42 70 31 57 82 65
AIT-090 PQR90 73 26 82 45 46 36 69
AIT-091 PQR91 37 75 56 79 41 35 71
AIT-092 PQR92 44 53 56 27 27 32 74
AIT-093 PQR93 33 24 29 27 42 56 30
AIT-094 PQR94 42 28 43 65 26 72 54
AIT-095 PQR95 86 64 44 87 73 27 80
AIT-096 PQR96 89 25 80 64 26 86 83
AIT-097 PQR97 57 80 47 79 43 60 86
AIT-098 PQR98 25 52 55 57 89 72 58
AIT-099 PQR99 32 87 49 30 35 24 65
AIT-100 PQR100 28 74 49 34 24 28 73
AIT-101 PQR101 59 74 24 56 57 44 89
AIT-102 PQR102 44 60 78 28 48 78 81
AIT-103 PQR103 24 79 50 42 60 67 38
AIT-104 PQR104 42 37 86 37 55 68 42
AIT-105 PQR105 48 47 25 63 66 44 61
AIT-106 PQR106 90 66 73 84 47 81 90
AIT-107 PQR107 73 91 46 68 78 35 51
AIT-108 PQR108 60 80 31 25 83 71 62
AIT-109 PQR109 67 63 55 69 42 79 71
AIT-110 PQR110 52 27 64 34 91 26 46
AIT-111 PQR111 57 76 59 41 38 63 31
AIT-112 PQR112 44 50 78 38 44 75 65
AIT-113 PQR113 46 36 50 60 50 88 54
AIT-114 PQR114 72 88 67 51 33 40 82
AIT-115 PQR115 64 63 55 54 83 66 46
AIT-116 PQR116 53 80 53 52 25 83 74
AIT-117 PQR117 53 61 26 46 56 79 29
AIT-118 PQR118 52 41 35 62 48 54 34
AIT-119 PQR119 85 48 57 38 44 32 76
AIT-120 PQR120 57 32 38 43 30 68 56
AIT-121 PQR121 80 85 73 62 44 37 55
AIT-122 PQR122 59 49 36 33 32 85 49
AIT-123 PQR123 75 54 61 41 74 78 32
AIT-124 PQR124 68 35 65 39 49 91 49
AIT-125 PQR125 55 43 37 87 90 59 51
AIT-126 PQR126 30 71 78 38 89 64 78
AIT-127 PQR127 25 83 82 72 78 24 78
AIT-128 PQR128 54 80 84 76 43 43 32
AIT-129 PQR129 56 37 86 80 75 59 58

Download the workbook Assignment 16 from student login portal and do the following-
1) Check the Page view- Normal, Page Layout and Page break Preview
2) Check the point of page setup- orientation, margin, paper size
3) Now fix the header row so that they remain visible always at the top while scrolling down the scree
4) Turn on track changes in employee progress card database and change the points in E57 as 99 and
5) Set header in the workbook by your name and current date, and footer by page number.
6) Set page size- A3, vertically justify (alignment) the page contents: Field heading under row 1 and 2
7) Go to cell H10 and split the screen into 4 parts. Now unsplit the same.
8) Protect the worksheet from A1:A131, also protect the workbook so that adding, deleting, renaming
9) Unprotect the workbook and worksheet.
10) Now set a password so that it requires everytime opening the workbook. Save and close the workb
e Progress Card
Nov Dec Jan Feb Mar Q1 Q2 Q3 Q4
54 36 39 30 42 197 155 151 111
46 75 74 48 36 127 129 151 158
56 61 85 30 90 145 138 143 205
72 39 54 81 31 120 118 166 166
65 64 59 71 25 479 121 206 155
49 64 27 80 76 127 125 160 183
71 37 24 85 85 627 89 181 194
79 81 51 28 58 78 163 211 137
43 24 65 28 76 418 182 94 169
49 34 32 50 74 96 149 125 156
82 40 34 37 81 393 115 179 152
39 27 50 24 72 132 70 125 146
45 85 53 51 71 101 442 188 175
68 67 84 70 64 947 193 173 218
26 64 89 43 88 103 145 115 220
70 31 60 66 79 78 466 125 205
86 30 78 67 25 425 143 171 170
73 69 43 75 62 120 105 193 180
38 36 70 77 66 579 484 154 213
90 84 46 38 28 484 127 242 112
49 55 55 67 72 102 689 168 194
45 45 49 91 60 191 198 181 200
40 86 26 82 70 199 167 187 178
79 59 58 74 63 180 629 181 195
70 57 60 45 72 98 85 170 177
44 42 91 74 28 150 101 144 193
31 87 32 77 68 160 153 191 177
44 74 84 40 80 161 135 203 204
36 39 38 90 67 170 106 138 195
72 52 53 50 76 185 176 182 179
57 77 88 91 55 206 195 208 234
71 88 40 82 43 213 190 236 165
55 57 41 46 42 207 185 201 129
91 35 41 77 86 154 118 154 204
42 34 73 73 29 226 122 107 175
29 89 59 33 83 184 187 202 175
77 63 26 65 29 113 148 221 120
73 63 74 46 86 148 95 193 206
55 43 86 40 68 194 169 160 194
77 32 27 69 37 203 170 148 133
42 28 35 34 86 159 183 128 155
37 83 76 43 71 132 225 198 190
73 37 43 35 43 184 200 140 121
42 58 91 25 66 199 165 144 182
41 33 36 85 60 183 196 104 181
69 89 35 52 89 156 156 220 176
84 80 60 43 37 179 211 202 140
33 33 49 43 33 199 176 149 125
42 35 51 64 28 157 179 149 143
34 42 58 87 75 172 173 130 220
67 41 59 32 35 156 241 192 126
46 88 26 49 81 158 165 163 156
44 88 79 69 87 186 126 201 235
51 67 48 91 54 218 149 178 193
84 39 25 41 31 164 191 210 97
82 34 52 25 79 156 160 160 156
77 61 79 76 57 193 135 184 212
55 75 40 68 29 178 190 175 137
57 53 67 48 36 150 161 135 151
53 58 69 85 27 166 225 162 181
28 28 54 56 83 87 120 139 193
70 52 91 72 45 131 144 177 208
45 37 40 65 43 152 191 165 148
61 34 55 37 40 148 196 136 132
89 85 54 35 90 176 202 227 179
90 59 89 80 63 251 208 212 232
56 83 56 73 74 165 184 228 203
57 91 26 73 62 171 145 197 161
72 53 85 43 83 177 200 205 211
60 25 85 80 47 113 170 169 212
38 81 36 40 52 183 216 175 128
50 89 66 35 57 109 211 167 158
42 32 53 88 68 145 192 100 209
51 29 27 87 77 196 129 123 191
74 78 61 84 71 121 178 204 216
81 35 54 74 26 122 158 192 154
54 65 53 81 37 191 172 154 171
58 91 66 88 61 131 223 179 215
35 69 51 72 72 201 172 166 195
24 85 38 61 32 198 217 173 131
53 75 68 28 74 217 197 204 170
54 72 25 59 42 159 210 211 126
53 43 31 64 91 150 141 187 186
69 80 87 70 82 108 210 220 239
65 77 60 34 46 143 149 177 140
65 42 77 25 38 173 202 188 140
65 81 74 68 54 188 151 196 196
30 86 28 35 60 134 112 197 123
60 53 45 72 27 136 170 178 144
46 41 70 39 53 181 127 156 162
71 77 82 72 29 168 155 219 183
91 91 90 35 40 153 86 256 165
52 68 50 48 71 86 125 150 169
 57 38 39 64 63 113 163 149 166
75 60 24 79 73 194 187 215 176
34 45 44 27 74 194 176 162 145
44 74 43 45 33 184 182 204 121
72 32 73 61 90 132 218 162 224
26 65 64 61 67 168 89 156 192
61 48 85 24 67 151 86 182 176
73 88 32 83 76 157 157 250 191
88 40 66 36 49 182 154 209 151
61 32 32 85 53 153 169 131 170
89 64 61 37 42 165 160 195 140
80 24 42 68 80 120 173 165 190
88 74 90 67 70 229 212 252 227
54 43 64 89 86 210 181 148 239
35 25 79 84 91 171 179 122 254
44 44 31 56 76 185 190 159 163
87 41 73 75 53 143 151 174 201
58 70 79 44 81 192 142 159 204
75 85 48 32 24 172 157 225 104
44 38 83 66 83 132 198 136 232
82 55 49 81 53 227 124 219 183
86 83 89 90 58 182 203 215 237
67 50 73 24 42 186 160 191 139
31 65 25 50 36 140 181 125 111
56 89 75 83 82 128 164 179 240
39 85 58 77 65 190 114 200 200
43 72 49 50 49 127 141 171 148
59 58 25 68 51 238 143 172 144
45 45 31 84 63 144 150 139 178
76 78 28 69 68 190 193 186 165
42 61 28 49 65 168 179 152 142
83 57 48 77 29 135 236 191 154
82 35 70 41 29 179 191 195 140
88 84 76 27 28 190 174 250 131
86 59 54 91 79 218 162 177 224
57 45 84 88 36 179 214 160 208

following-

scrolling down the screen.

e points in E57 as 99 and for L35 as 55. Now accept the changes.
page number.
ading under row 1 and 2 should be print on all pages; all contents of worksheet should fit horizontally within 2 p

ding, deleting, renaming, moving, hiding and unhiding sheets is not possible.

Save and close the workbook.

fit horizontally within 2 pages.