MS Excel Assignment

1.
Change data into columnwise format

2. Change expiry date format to Year, month, day(eg, 2022-Jan-02); insured value to thousand seperation
3. Use "Rs" initial as currency for the insured value
4. Erase all random color fill from the data
5. Borders for the data and fill color for the heading for your data
6. Revise Policy No. as policy no followed by province name(eg, bagmati100242)
7. insert +977 code for the cell no
Policy No. 100242 100314 100359 100315 100385 100388 100358 100264 100265 100357
Expiry 1/2/2022 1/2/2022 1/2/2022 1/3/2022 1/3/2022 1/4/2022 1/5/2022 1/7/2022 1/7/2022 1/8/2022
Province Bagmati Bagmati Province 2 Bagmati Bagmati Province 1 Province 2 Bagmati Bagmati Bagmati
InsuredValue 1617630 8678500 2052660 17580000 1925000 12934500 928300 2219900 14100000 4762808
Earthquake N Y N Y N Y N N Y Y
Flood N Y N Y N Y N N Y Y
Cell No. 9874610913 9875246765 9874765408 9874749901 9875432058 9874455742 9875581510 9875324487 9874960573 9874346647
100399 100329 100429 100441 100442 100372 100281 100280 100424 100425 100426
1/8/2022 1/9/2022 1/9/2022 1/10/2022 1/10/2022 1/12/2022 1/13/2022 1/15/2022 1/16/2022 1/16/2022 Sudurpashc
1/16/2022
Bagmati Bagmati Province 2 Lumbini Province 2 Bagmati Province 2 Bagmati Bagmati Bagmati him
13925190 6350000 4036000 472800 11710880 1370300 1432835 82000 192000 4950000 2432875
Y Y Y Y Y Y N Y N Y N
Y Y Y Y Y Y N Y N Y N
9875694877 9875918895 9874914232 9874642246 9875684430 9874744860 9874857298 9874601102 9874270528 9875225026 9874749808
100252 100279 100292 100398 100382 100461 100453 100263 100381 100277 100312
1/17/2022 1/18/2022 1/18/2022 1/18/2022 1/19/2022 1/20/2022 1/22/2022 1/22/2022 Sudurpashc
1/23/2022 1/25/2022 1/25/2022
Karnali Bagmati Bagmati Bagmati Lumbini Province 2 Bagmati Lumbini him Lumbini Province 1
1529600 7677000 13750000 2529400 2328650 4380200 1177700 2815000 7203500 3189300 3145700
N Y Y N N Y N Y Y Y N
N Y Y N N Y N Y Y Y N
9875949916 9874747888 9874910689 9874805093 9875867155 9874714112 9874211970 9874582365 9875212247 9875511772 9874608624
100275 100327 100326 100379 100341 100310 100289 100290 100291 100340 100415
1/25/2022 1/25/2022 1/26/2022 1/26/2022 1/28/2022 1/28/2022 1/29/2022 1/29/2022 1/29/2022 1/30/2022 1/31/2022
Province 2 Province 2 Karnali Bagmati Bagmati Province 2 Bagmati Bagmati Bagmati Bagmati Bagmati
53410614 1451100 1787900 18777355 1123000 8800000 2145420 18933000 21400000 3754000 9650000
Y N N Y Y Y N Y Y Y Y
9874741270 9875772859 9874147363 9875316808 9874834060 9874576363 9874780522 9875799377 9874311784 9876071185 9875734294
100421 100304 100420 100414 100481 100352 100496 100413 100309 100498 100509
1/31/2022 2/1/2022 2/2/2022 2/2/2022 2/2/2022 2/3/2022 2/4/2022 2/5/2022 2/5/2022 2/6/2022 2/7/2022
Bagmati Lumbini Bagmati Province 2 Province 2 Lumbini Province 1 Bagmati Province 2 Lumbini Karnali
9503000 1688300 7577000 17856705 1990915 1245000 1895000 8397700 5000368 36356000 1849000
Y N Y Y N Y N Y N Y N
Y Y Y Y N Y N Y N Y N
9875481524 9875738434 9874992668 9874657711 9874732387 9875714519 9874940509 9874991233 9874552712 9875744436 9874307407
100499 100371 100412 100377 100459 100452 100370 100325 100419 100512 100513
2/7/2022 2/8/2022 2/8/2022 2/9/2022 2/9/2022 2/9/2022 2/9/2022 2/13/2022 2/13/2022 2/13/2022 2/13/2022
Lumbini Karnali Lumbini Bagmati Bagmati Lumbini Province 2 Bagmati Bagmati Bagmati Bagmati
16932600 218490 3052600 11400000 2550750 5918400 8126500 140000 725000 10098900 2937200
Y N Y Y N Y Y N N Y N
Y N N Y N N Y N N Y N
9875136833 9876104658 9875629755 9875209243 9875244800 9875376765 9874266299 9874631899 9875045053 9874750833 9874802563
100514 100471 100396 100436 100492 100494 100493 100411 100351 100469 100511
2/13/2022 2/15/2022 2/16/2022 2/17/2022 2/18/2022 2/18/2022 2/19/2022 2/20/2022 Sudurpashch
2/20/2022 2/21/2022 2/22/2022
Lumbini Bagmati Bagmati Bagmati Bagmati Province 2 Lumbini Province 2 im Bagmati Bagmati
3644800 13882500 2050000 3805200 1417800 5613900 2471100 9062700 2985950 7350000 12750000
Y Y N N N N N N N Y Y
Y Y N N N N N N N Y Y
9874468250 9874907269 9874490153 9874260648 9875172448 9874892969 9874252252 9875578386 9875931377 9874581555 9874168653
100536 100537 100418 100394 100410 100408 100369 100409 100546 100523 100434
2/22/2022 2/22/2022 2/22/2022 2/23/2022 2/24/2022 2/24/2022 2/25/2022 2/25/2022 2/27/2022 3/1/2022 3/1/2022
Bagmati Bagmati Lumbini Bagmati Bagmati Province 2 Bagmati Bagmati Bagmati Bagmati Lumbini
7585000 9493313 1300900 10302000 2029500 4833900 2233200 2001250 1498850 1311220 405556
Y Y N Y Y N N Y N N Y
Y Y N Y Y N N Y N N N
9874817691 9875094535 9875391488 9874798641 9874269311 9874190496 9874668975 9874462225 9874472733 9874372755 9875528727
100566 100433 100522 100457 100521 100532 100533 100583 100467 100554 100404
3/2/2022 3/2/2022 3/5/2022 3/6/2022 3/6/2022 3/7/2022 3/7/2022 3/8/2022 3/8/2022 3/9/2022 3/9/2022
Karnali Bagmati Bagmati Bagmati Lumbini Lumbini Province 2 Bagmati Lumbini Lumbini Province 2
5377000 1769785 1599860 10780450 3839200 296000 2707630 7611000 2249500 9115500 1152600
Y Y N Y N N N Y N Y N
Y Y N Y N N N Y N Y N
9874699299 9874934541 9875865812 9874720512 9875162336 9874604659 9875274739 9874218082 9874841341 9875003308 9875678671
100446 100490 100465 100456 100545 100489 100543 100564 100430 100477 100478
3/11/2022 3/12/2022 3/12/2022 3/14/2022 3/14/2022 3/14/2022 3/15/2022 3/15/2022 3/17/2022 Sudurpashch
3/17/2022 Sudurpashch
3/17/2022
Bagmati Bagmati Lumbini Bagmati Bagmati Lumbini Bagmati Province 2 Lumbini im im
1600000 220000 2575965 1800000 14450000 16998000 2835800 2280000 3960000 5272975 6354220
Y N Y Y Y Y N Y Y Y Y
9874799896 9875394018 9874172058 9875662515 9874974112 9875047643 9875495906 9874504289 9875495462 9875489163 9875558523
100444 100582 100487 100519 100462 100486 100463 100595 100617 100581 100504
3/21/2022 3/22/2022 3/23/2022 3/25/2022 3/26/2022 3/26/2022 3/27/2022 3/27/2022 Sudurpashch
3/27/2022 3/30/2022 3/31/2022
Bagmati Lumbini Bagmati Bagmati Bagmati Bagmati Bagmati Bagmati im Bagmati Bagmati
8892200 4651680 5990067 4102500 3400000 9973900 15480000 2446600 8861500 5150000 1649105
Y Y N N Y Y Y N N Y N
Y Y N N Y Y Y N N Y N
9874131213 9875471057 9875996061 9874200419 9874957089 9874724679 9875813858 9875608324 9876045613 9874302285 9874198461
100616 100503 100475 100614 100529 100551 100625 100501 100516 100542 100540
3/31/2022 3/31/2022 3/31/2022 4/3/2022 4/5/2022 4/6/2022 4/7/2022 4/7/2022 4/7/2022 Sudurpashc
4/7/2022 4/9/2022
Bagmati Lumbini Province 2 Bagmati Lumbini Lumbini Bagmati Province 2 Province 2 him Bagmati
2329500 1761960 1451662 721500 2455000 3363463 49837500 1568100 2063960 1806500 2244800
N N N Y Y Y Y N N N N
N N N Y Y N Y N N Y N
9874695573 9875259524 9875306012 9875887422 9874610987 9874555812 9874191532 9875492508 9874391679 9874999358 9875187046
100663 100642 100539 100680 100549 100560 100629 100631 100630 100637 100659
4/10/2022 4/11/2022 4/11/2022 4/15/2022 Sudurpashc
4/15/2022 4/16/2022 4/16/2022 4/16/2022 4/17/2022 4/17/2022 4/17/2022
Lumbini Bagmati Lumbini Province 2 him Bagmati Bagmati Lumbini Bagmati Bagmati Lumbini
10346950 1697200 8150000 6020060 3334353 1381370 2442400 4193603 7394300 2402500 1693000
N N N N Y N N Y Y Y Y
Y N Y N Y N N N Y Y N
9875936556 9874184149 9875717350 9874862133 9875201824 9875656833 9874694729 9874405036 9874243254 9874310510 9874165865
100572 100527 100638 100679 100678 100570 100621 100578 100623 100611 100622
4/17/2022 4/18/2022 4/18/2022 4/18/2022 4/21/2022 4/22/2022 4/25/2022 4/25/2022 4/25/2022 4/25/2022 4/25/2022
Province 2 Lumbini Lumbini Lumbini Province 2 Province 2 Gandaki Karnali Bagmati Lumbini Province 2
3725520 9148076 3950000 14183900 35245000 294700 394220 4488000 2006700 1595500 723900
N Y Y Y Y N N N N Y Y
N Y Y Y Y N N N N Y Y
9875303695 9874962151 9875934538 9875883694 9875691861 9876067876 9874908759 9876099750 9875481859 9875763141 9875498108
100604 100610 100591 100557 100636 100628 100650 100651 100569 100609 100649
4/26/2022 4/27/2022 4/29/2022 4/30/2022 4/30/2022 5/1/2022 5/2/2022 5/2/2022 5/3/2022 5/3/2022 5/4/2022
Province 2 Bagmati Bagmati Bagmati Province 1 Bagmati Bagmati Lumbini Bagmati Lumbini Bagmati
979572 5086300 4353100 2056700 4886675 1973200 4156000 1045000 800000 4483000 3074775
N Y N Y N N Y Y N Y N
N Y N Y N N Y N N Y N
9875278765 9875333464 9874929662 9874145451 9875546668 9875209289 9875244242 9874917502 9875224652 9875353286 9875361259
100677 100704 100713 100674 100584 100675 100589 100590 100648 100683
5/6/2022 5/6/2022 5/6/2022 5/7/2022 5/7/2022 5/8/2022 5/8/2022 5/8/2022 5/9/2022 5/9/2022
Bagmati Lumbini Province 2 Bagmati Province 2 Bagmati Province 2 Province 2 Bagmati Lumbini
13370000 14474600 2103390 9250000 7750100 2468300 2867650 2798650 270000 1374100
Y Y N Y N Y N N N Y
Y Y N Y N Y N N N Y
9874564218 9875450026 9875741870 9875401733 9875356842 9875506983 9875929249 9874940656 9875017156 9874300537
100647 100602 100672 100655 100671 100600 100646 100618 100681 100619
5/10/2022 5/11/2022 Sudurpashchi
5/11/2022 5/12/2022 5/12/2022 5/12/2022 5/13/2022 5/14/2022 5/14/2022 5/15/2022
Province 2 Bagmati m Bagmati Bagmati Province 2 Bagmati Bagmati Bagmati Bagmati
4077100 1651300 2785000 1974300 3660780 3086048 2550000 2730000 963100 1419500
Y N N Y N Y Y Y Y N
Y N N Y N Y Y Y Y N
9875877849 9874683469 9875840356 9875175780 9874236947 9875999778 9874428091 9875116591 9875800945 9875520274
100670 100627 100689 100726 100703 100702 100635 100737 100736 100644
5/16/2022 5/16/2022 5/16/2022 5/16/2022 5/17/2022 Sudurpashchi
5/17/2022 5/18/2022 5/18/2022 Sudurpashchi
5/18/2022 5/19/2022
Karnali Bagmati Bagmati Bagmati Lumbini m Gandaki Lumbini m Bagmati
661900 2758482 19451600 1292345 10198700 9702682 714000 16200000 2099525 2570600
N Y Y N Y N N Y N Y
N Y Y N Y N N Y N Y
9874808008 9874511340 9876086081 9875311538 9876064779 9874286381 9876075908 9874951871 9876070216 9874472624
100643 100698 100652 100705 100718 100744 100653 100709 100749 100752
5/20/2022 5/20/2022 5/21/2022 5/21/2022 5/21/2022 5/21/2022 5/21/2022 5/22/2022 5/22/2022 5/22/2022
Bagmati Bagmati Karnali Bagmati Bagmati Bagmati Lumbini Gandaki Bagmati Bagmati
1280000 205000 1760800 3943000 3107790 9448200 2812559 10617800 847300 363200
Y N N N N Y N Y Y N
Y N N N Y Y N Y Y Y
9874592017 9874638617 9875761050 9874894612 9874938678 9875523793 9874233207 9875052645 9875352542 9875890768
100751 100696 100742 100666 100667 100740 100757 100756 100750 100754
5/22/2022 5/23/2022 5/23/2022 5/24/2022 5/25/2022 5/25/2022 5/25/2022 5/27/2022 Sudurpashchi
5/27/2022 5/29/2022
Lumbini Province 1 Province 2 Bagmati Bagmati Province 2 Province 2 Bagmati m Bagmati
400000 2922600 500500 1927450 2660299 3980100 2987000 16950000 16429900 36909180
N Y Y N N N Y Y Y Y
Y Y Y N N N Y Y Y Y
9875315205 9875355005 9874254880 9874927573 9875935026 9875926940 9875766506 9875722031 9874480499 9875215751
100764 100724 100686 100761 100777 100695 100727 100774 100759 100723 100720
5/29/2022 5/30/2022 6/1/2022 Sudurpashc
6/2/2022 6/3/2022 6/3/2022 6/3/2022 6/4/2022 6/5/2022 6/5/2022 6/5/2022
Bagmati Bagmati Bagmati him Karnali Bagmati Province 2 Bagmati Bagmati Lumbini Province 1
9600000 22050000 3850000 13514081 8272853 2000000 1658765 6750000 17050000 373500 7828000
Y Y N Y N Y N Y Y N N
N Y Y Y N Y N Y Y N Y
9875393881 9874173416 9874713926 9875910586 9875501826 9874992649 9876119049 9876023197 9875079581 9875494164 9874914001
100722 100731 100755 100746 100745 100747 100780 100783 100781 100760 100775
6/6/2022 6/6/2022 6/6/2022 6/7/2022 6/7/2022 6/7/2022 6/8/2022 6/9/2022 6/9/2022 6/9/2022 6/10/2022
Bagmati Bagmati Province 2 Bagmati Province 2 Province 2 Lumbini Gandaki Bagmati Province 2 Bagmati
1958400 17746832 6040300 847300 2224219 782428 299400 1991600 1714835 1397100 3136600
N Y Y Y N N Y N N Y N
N Y N Y N N N N N Y N
9876022429 9874302928 9874452000 9875008390 9874487081 9874873226 9876097528 9874226445 9876074111 9875206989 9875510241
100769 100768 100773 100789 100790 100792 100793 100797 100800 100801 100803
6/10/2022 6/10/2022 6/11/2022 8/26/2022 8/26/2022 Sudurpashch
8/26/2022 8/27/2022 8/29/2022 8/30/2022 8/31/2022 8/31/2022
Lumbini Province 2 Bagmati Bagmati Lumbini im Bagmati Bagmati Bagmati Province 2 Province 2
5460000 3701573 1780000 230000 1463800 3579800 1275600 5781710 1379400 6385452 4671000
Y N Y Y Y N N N N Y Y
Y N Y Y N N Y N N N Y
9875296190 9874480187 9875163399 9875283444 9875828124 9875688612 9875173201 9876015759 9876067272 9874287167 9875022238
100805 100810 100813 100808 100811 100814 100817 100818 100821 100819 100822
9/1/2022 9/2/2022 9/2/2022 9/2/2022 9/2/2022 9/2/2022 9/3/2022 9/3/2022 9/5/2022 Sudurpashch
9/5/2022 9/6/2022
Bagmati Bagmati Bagmati Province 2 Province 2 Province 2 Lumbini Province 1 Province 2 im Bagmati
199000 1875000 1986100 2100000 2201500 105000 3700000 29128000 1778600 10700000 3866420
N Y N N N N Y Y N Y N
N Y N N N N Y Y N Y N
9875333295 9875262386 9874397310 9874468498 9875517421 9875372468 9875356049 9875613480 9874396101 9874331101 9875876171
100823 100824 100826 100825 100832 100831 100834 100836 100837 100838 100839
9/6/2022 9/7/2022 9/7/2022 9/7/2022 9/10/2022 9/10/2022 9/11/2022 9/11/2022 9/11/2022 9/11/2022 9/13/2022
Bagmati Bagmati Bagmati Province 2 Bagmati Lumbini Bagmati Province 2 Province 2 Province 2 Lumbini
1037500 2480800 3178400 578400 18275350 1604800 710400 2205950 8166050 3222081 371600
N N Y N Y Y N N N N Y
N N Y N Y Y N N Y N N
9875500700 9875882602 9874631965 9875458859 9874605722 9874813718 9875832006 9875527732 9875168805 9876002943 9875850960
100845 100846 100844 100850 100854 100856 100859 100861 100857 100863 100864
9/15/2022 9/15/2022 9/15/2022 9/16/2022 Sudurpashch
9/21/2022 9/22/2022 9/23/2022 9/23/2022 9/23/2022 9/24/2022 9/24/2022
Bagmati Bagmati Province 2 Province 1 im Lumbini Bagmati Bagmati Province 1 Bagmati Bagmati
24000000 7700000 1365000 4578800 2477200 3432600 11147050 2007000 172100 9404500 5056900
Y Y Y N N Y Y Y N Y Y
Y Y Y N N Y Y Y N Y Y
9875441632 9874728221 9874152336 9875128126 9874718959 9874528306 9874494560 9875326453 9875133910 9874468104 9874806418
100869 100868 100870 100872 100873 100874 100875 100876 100878 100882 100883
9/26/2022 9/26/2022 9/27/2022 9/28/2022 Sudurpashch
9/29/2022 9/30/2022 10/1/2022 10/1/2022 10/1/2022 10/3/2022 10/4/2022
Bagmati Province 2 Bagmati Bagmati im Bagmati Bagmati Bagmati Bagmati Province 1 Bagmati
953100 4577032 2562500 6908000 1588100 311200 14850000 1557500 4267000 1702350 280600
N N N Y N N Y N Y N N
N N N Y N N Y Y Y N N
9875219118 9875754700 9875638287 9875676284 9874852033 9875354245 9875739151 9875124589 9875333015 9875853478 9875648050
100886 100885 100889 100887 100894 100895 100898 100900 100901 100903 100908
10/4/2022 10/4/2022 10/5/2022 10/5/2022 10/7/2022 10/7/2022 10/10/2022 10/11/2022 10/11/2022 10/12/2022 10/14/2022
Bagmati Province 2 Bagmati Province 2 Bagmati Bagmati Bagmati Bagmati Bagmati Province 2 Bagmati
6748000 2025100 3235700 2067500 2356100 7932500 1851125 8345500 2400000 1675000 13900000
9876067094 9874165588 9874853921 9874768395 9875808498 9875533056 9875745957 9874595221 9875954560 9874207865 9875411366
100909 100910 100912 100215 100914 100916 100920 100919 100923 100928 100929
10/14/2022 10/14/2022 10/15/2022 10/17/2022 10/17/2022 10/18/2022 10/20/2022 10/20/2022 10/21/2022 10/22/2022 10/22/2022
Bagmati Bagmati Karnali Bagmati Province 2 Bagmati Lumbini Province 2 Bagmati Bagmati Bagmati
13575000 5950500 1569440 2131900 631410 1856637 4726686 2321900 1830900 1267625 3409000
Y Y N N N Y Y N N N N
Y Y N N N Y N N N N N
9875147436 9874359731 9876088822 9875400353 9875334681 9874518695 9874817997 9875409001 9875820556 9875640424 9875711069
100927 100214 100932 100933 100934 100936 100939 100250 100940 100941 100942
10/22/2022
Sudurpashc 10/23/2022 10/23/2022 10/23/2022 10/24/2022 10/26/2022 10/27/2022 10/27/2022 10/28/2022 10/28/2022 10/28/2022
him Bagmati Lumbini Province 2 Province 2 Province 1 Lumbini Province 2 Bagmati Bagmati Bagmati
1325200 33250000 320100 275000 1519100 2182250 1840000 4328620 21250000 2534633 2494300
N Y N N N N N N Y N Y
N Y N N N N N N Y N Y
9876087748 9874521592 9874169690 9875203849 9875527487 9875661617 9875387881 9875884711 9874687301 9875485042 9875188241
100943 100945 100947 100227 100226 100948 100950 100953 100952 100249 100955
10/28/2022 10/29/2022 10/29/2022 10/29/2022 10/30/2022 10/30/2022 10/31/2022 11/1/2022 11/1/2022 11/1/2022 11/3/2022
Bagmati Bagmati Bagmati Province 2 Bagmati Lumbini Bagmati Bagmati Province 1 Province 2 Lumbini
2562500 503000 10259600 685000 3798400 2269865 2363700 4127900 16833800 1960200 2753500
Y N Y Y Y Y N N Y N Y
Y Y Y Y Y Y N N Y N Y
9874499733 9875427144 9874328057 9874953691 9875955388 9875170028 9875092007 9875496257 9874694410 9874659577 9874760404
100287 100956 100959 100261 100961 100966 100962 100972 100969 100977 100978
11/4/2022 11/4/2022 11/5/2022 11/6/2022 11/6/2022 11/7/2022 11/7/2022 11/9/2022 11/9/2022 11/10/2022 11/10/2022
Bagmati Lumbini Lumbini Bagmati Province 1 Karnali Bagmati Bagmati Province 2 Bagmati Bagmati
10518041 1554500 1115870 15625000 787500 320000 15750000 2398000 2611400 4981500 535000
Y N Y Y N N Y N N N N
Y N N Y N N Y N N N N
9875585974 9874952051 9875063301 9874914863 9875041590 9875956875 9875286501 9874230340 9874669075 9875781543 9875938464
100981 100974 100982 100983 100240 100985 100239 100237 100986 100238 100988
11/10/2022 11/10/2022 11/11/2022 11/11/2022 11/11/2022 11/12/2022 11/12/2022 11/13/2022 11/13/2022 11/13/2022 11/13/2022
Bagmati Lumbini Bagmati Bagmati Lumbini Bagmati Lumbini Karnali Bagmati Lumbini Lumbini
10397500 2329942 10808800 1962400 2003000 3067800 2423500 1202090 2815900 3062000 1975000
Y Y Y N Y N Y N N Y Y
Y N Y N Y N Y N N Y Y
9874862594 9875598411 9874382220 9874911275 9875212917 9875512113 9874718005 9875192703 9876083753 9875055940 9874498100
100302 100260 100274 100209 100991 100992 100993 100994 100259 100998 100273
11/14/2022 11/14/2022 11/15/2022 11/16/2022 11/16/2022 11/16/2022 11/16/2022 11/17/2022 11/18/2022 11/19/2022 11/19/2022
Bagmati Province 2 Bagmati Bagmati Bagmati Lumbini Lumbini Province 2 Gandaki Gandaki Bagmati
847300 2070000 2029750 2636313 2080000 205000 1936200 1403100 315000 3255300 2000000
Y N N N Y Y N N N N Y
Y N N N Y Y N N N N Y
9876119946 9876095850 9875692173 9875948497 9874404579 9874216981 9875212330 9875436963 9875037454 9874963956 9874515281
100996 100999 101000 100257 100258 101005 101003 100208 101008 101009 101011
11/19/2022 11/19/2022 11/19/2022 11/20/2022 11/21/2022 11/21/2022 11/21/2022 11/22/2022 11/22/2022 11/22/2022 11/23/2022
Bagmati Bagmati Bagmati Bagmati Bagmati Bagmati Lumbini Bagmati Bagmati Province 2 Gandaki
9900000 4477175 2395000 5550000 1922800 10811785 3028850 30000 15700000 5503255 601000
Y Y N Y Y N Y Y Y N N
Y N Y Y Y N N Y Y N N
9874577432 9874366506 9874811235 9875958701 9874827913 9876073564 9874700447 9874741098 9874867097 9874208012 9874231545
100307 101012 100271 100301 101016 101019 101023 101024 100336 100206 100286
11/23/2022 11/24/2022 11/25/2022 11/25/2022 11/25/2022 11/26/2022 11/27/2022 11/27/2022 Sudurpashch
11/27/2022 11/28/2022 11/28/2022
Province 2 Lumbini Bagmati Bagmati Province 2 Province 2 Bagmati Lumbini im Bagmati Bagmati
5015000 1563500 10979275 6198000 504000 2211300 660473 4978985 6000902 5213100 2336132
N Y N Y N Y N Y Y Y N
N Y N Y N Y N N Y Y N
9874579797 9874998701 9875602936 9875644140 9874152918 9875153094 9874607290 9875916967 9874644715 9875815597 9875358669
100334 101029 100324 100335 101025 101031 100222 101034 100205 100221 100246
11/28/2022 11/28/2022 11/28/2022 11/28/2022 11/28/2022 11/29/2022 11/30/2022 11/30/2022 11/30/2022 12/1/2022 12/1/2022
Bagmati Bagmati Lumbini Province 2 Province 2 Bagmati Bagmati Bagmati Province 2 Bagmati Lumbini
1500000 8115500 6253000 2984500 2502600 2162291 3295800 9710700 4064995 2350000 1807440
Y Y Y N Y N N Y N Y Y
Y Y Y N Y N N Y N Y Y
9875619975 9875841797 9875767751 9875349351 9876058638 9874239286 9875242666 9876110872 9875943455 9875919627 9875957699
100298 101035 100333 101037 101036 101039 101042 101044 101043 100219 100220
12/1/2022 12/1/2022 12/2/2022 12/2/2022 Sudurpashch
12/2/2022 12/3/2022 12/3/2022 12/4/2022 12/4/2022 12/5/2022 12/5/2022
Province 2 Province 2 Bagmati Bagmati im Bagmati Province 2 Bagmati Province 2 Bagmati Bagmati
3175400 3741300 2806200 2325718 6169400 245000 4201800 12220000 2820265 1144300 4530000
Y Y N N Y N N Y N Y Y
Y Y N N Y N N Y N Y Y
9875649009 9874543604 9875170032 9875963253 9875027512 9874751595 9875897603 9875214442 9875890721 9875421401 9875609834
100300 101046 101054 100366 101052 100234 100269 100317 100319 101061 100318
12/5/2022 12/5/2022 12/7/2022 12/7/2022 12/7/2022 12/8/2022 12/9/2022 12/9/2022 12/9/2022 12/9/2022 12/9/2022
Bagmati Lumbini Bagmati Lumbini Lumbini Bagmati Bagmati Bagmati Bagmati Bagmati Province 2
2000300 3990000 1510000 5850000 6250000 3871000 513300 2943800 8923000 6450000 3952500
N Y N Y Y Y N N Y Y Y
N Y N Y Y Y N N Y Y Y
9874262123 9875177193 9876007227 9874991338 9874368058 9874407143 9875918333 9876066689 9875534723 9875860119 9876039536
101058 100365 101066 101067 101068 100374 100244 101070 101071 101069 101073
12/9/2022 12/10/2022 12/11/2022 12/11/2022 12/11/2022 12/11/2022 12/12/2022 12/12/2022 12/12/2022 Sudurpashch
12/12/2022 12/13/2022
Province 2 Bagmati Bagmati Bagmati Bagmati Province 2 Bagmati Bagmati Province 2 im Bagmati
2900000 4479400 2013357 4017155 11650000 2030600 9250000 3553009 1063100 2198800 2854500
Y N N N Y N Y N Y N Y
Y N N N Y N Y N Y N Y
9875552505 9875739671 9874717417 9875944109 9875828216 9874441544 9874764528 9874507036 9874156446 9876018624 9875420290
101074 100364 101075 101076 100218 101083 101088 101089 101090 101091 101092
12/13/2022 12/14/2022 12/14/2022 12/14/2022 12/17/2022 12/18/2022 12/19/2022 12/19/2022 12/19/2022 12/19/2022 12/19/2022
Lumbini Bagmati Bagmati Bagmati Bagmati Bagmati Bagmati Bagmati Bagmati Bagmati Province 2
3356200 1882600 2393232 14678200 5017360 2625000 285700 275000 10396250 27208210 1740000
Y N N Y N Y N Y Y Y N
Y N N Y N Y N N Y Y N
9875267774 9874692489 9874160955 9875923184 9875479387 9876080095 9874549498 9874532594 9874324629 9874919279 9875231271
101093 100347 101094 100346 100391 101096 100204 100344 100203 100231 101100
12/19/2022 12/20/2022 12/20/2022 12/21/2022 12/21/2022 12/21/2022 12/21/2022 12/21/2022 12/22/2022 12/22/2022 12/22/2022
Province 2 Bagmati Lumbini Bagmati Bagmati Bagmati Province 2 Province 2 Bagmati Bagmati Bagmati
2464755 535000 2837500 1780000 10746600 645000 1400000 1711268 3724339 12493000 2159000
N N Y Y Y N N N N Y N
N N Y Y Y N N N N Y N
9875095680 9874935808 9876112014 9875243114 9876004046 9874842689 9874862163 9876021359 9875981450 9875356366 9875876819
101098 100217 101102 100202 100305 101104 100230 100201 100361 101107 101109
12/22/2022 12/23/2022 12/23/2022 12/23/2022 12/24/2022 12/24/2022 12/25/2022 12/25/2022 12/25/2022 12/25/2022 12/25/2022
Province 2 Bagmati Bagmati Lumbini Bagmati Bagmati Karnali Bagmati Bagmati Bagmati Bagmati
539040 100000 1121600 3750000 9000000 292200 608500 11575700 1125600 9377600 3920500
N N N Y Y Y N Y N Y N
N N N Y Y Y N Y N Y N
9875988758 9875817877 9874526925 9875459977 9874202188 9875351271 9874720909 9874450244 9876016518 9874274050 9874515363
100295 100360 101111 100282 101113 101114 100400 100200 100330 101115 101116
12/25/2022 12/25/2022 12/26/2022 12/26/2022 12/27/2022 12/27/2022 Sudurpashch
12/27/2022 12/28/2022 12/28/2022 12/28/2022 12/29/2022
Lumbini Province 2 Bagmati Province 2 Bagmati Province 1 im Bagmati Bagmati Province 2 Bagmati
5114500 4822450 6235057 4132600 2500000 3883300 1960000 1425000 1545100 1665100 8245000
Y Y N N N N N N Y N Y
Y Y N N N N N N Y N Y
9874741317 9875548488 9875008613 9875429614 9874838348 9874671256 9875271239 9876113093 9874382185 9874791200 9874867839
100389 101117 101120 100216 101122 101123 101125 101126 101121
12/30/2022 12/30/2022 12/30/2022 12/30/2022 12/31/2022 12/31/2022 12/31/2022 12/31/2022 Sudurpashch
12/31/2022
Bagmati Bagmati Bagmati Lumbini Karnali Bagmati Bagmati Province 2 im
1480000 9050000 1480755 2432600 1739100 2250000 16482200 1776800 4101750
Y Y N Y N Y Y N Y
Y Y N Y N Y Y N Y
9875136768 9874179867 9874261956 9874491607 9874486091 9875518308 9875282687 9875730755 9875151850
1. Fill serial number(S.N) from 1
2. Remove unneccessary color format
3. Separate First name, Last name and ID No.
4. Convert Date format in yyyy-mm-dd
5. Make mail address using firstname initial,full lastname,id(for example; a.dahal1170@abc.org.np)
6. Provide Allowance of 10% to those whose basic salary is less than 30000 and sum total salary of each
7. Convert the data into excel table
S.N Name,ID No. Cell No. Appointment Date Department Basic Salary Allowances Total Salary
asmit dahal,1170 9831868500 7/13/2063 Admin 39782
himanshu rana,1162 9812524016 1/13/2061 IT 29201
mohini pakhrin,1119 9819728661 10/13/2063 HR 30637
nikki manandhar,1136 9818869281 8/13/2062 HR 20896
pragyan shakya,1188 9826612017 4/13/2063 Admin 41854
prapti shrestha,1146 9822987131 8/13/2063 Officer 38014
rebika pakhrin,1152 9814926591 1/13/2064 IT 41035
sajana dhakal,1213 9829373173 7/13/2063 IT 42982
sangarsha chaulagain,1186 9814352435 6/13/2063 Admin 35127
sarthak khatiwada,1126 9817042915 1/13/2063 Admin 33279
shruti gautam,1174 9814882464 3/13/2063 HR 45108
sishan siwakoti,1196 9813001918 2/13/2063 Office Helper 23716
sparsha lamichhane,1121 9829296197 11/13/2063 HR 47611
sujal sapkota,1201 9830540826 11/13/2063 Admin 30255
swarnim bhusal,1139 9815403311 10/13/2063 Officer 46799
yugal bhomjan,1114 9825027932 8/13/2062 HR 45708
raghav tamang,1157 9826542894 5/13/2061 IT 43167
aasutosh pokhrel,1191 9826026872 12/24/2063 IT 36816
anubhav dhungana,1202 9826675474 7/13/2064 Admin 20994
dikshyant budathoki,1116 9818627037 3/13/2063 Admin 39667
divyanshu paudel,1134 9816639318 11/13/2063 Admin 23148
kajal kumari,1119 9830147652 2/13/2064 Admin 20726
kriti devkota,1230 9822909015 9/13/2064 Admin 28147
lelin shiwakoti,1212 9817083951 2/13/2063 IT 23242
mandip bartaula,1177 9815735596 8/13/2063 Admin 41503
nikita khulal,1134 9813137341 7/13/2063 Admin 44335
parartha karki,1215 9820815869 1/13/2061 Admin 37381
prawash lama,1125 9817450359 5/13/2062 Office Helper 26478
prince bartaula,1142 9818333203 4/13/2063 HR 49949
rayan budathoki,1143 9812777482 2/13/2064 Officer 46063
rhythm paudel,1232 9831189354 7/13/2063 IT 34760
rijan parajuli,1228 9821473433 2/13/2063 IT 38848
rojina bista,1113 9824378963 8/13/2062 Admin 24790
shubham khadka,1114 9814830063 2/13/2062 Office Helper 27451
sital sunar,1219 9815815742 3/13/2064 Officer 24757
sriju joshi,1156 9831394024 2/13/2064 Office Helper 28106
suyesh shrestha,1185 9831986251 8/13/2019 Admin 30796
abhiyan parajuli,1157 9824029017 5/13/2063 HR 23372
anirudra upreti,1218 9815449724 6/13/2063 Admin 37308
raghav regmi,1178 9820667469 10/13/2062 IT 39905
rohit chapagain,1117 9816163645 3/13/2061 HR 34433
sabina tamang,1125 9831060526 3/13/2062 Admin 27300
sambandha shrestha,1182 9815434916 5/13/2063 Admin 24722
sambriddhi pudasaini,1211 9814415798 8/13/2063 Officer 32123
shishir budathoki,1134 9820781720 1/13/2063 Admin 37190
urja kayastha,1229 9819862875 10/13/2062 HR 24135
aagaman koirala,1203 9820958973 8/25/2063 HR 41141
garima thokar,1146 9815325182 3/13/2063 IT 25371
ishan sharma,1136 9822307818 11/13/2063 Office Helper 41551
jasbin lama,1176 9814397448 10/13/2063 HR 47063
mijash mishra,1211 9812862189 2/13/2064 Officer 27584
nischalta timilsina,1149 9816024107 5/13/2063 Office Helper 32032
prajjwal lamichhane,1137 9829464516 1/13/2064 Office Helper 27141
prasamsha adhikari,1168 9830814561 7/13/2062 Officer 22876
prasuma acharya,1174 9814022997 8/13/2063 Admin 45926
rohan deula,1181 9825889652 9/13/2061 HR 33387
ronish shrestha,1215 9813298649 11/13/2062 Admin 29062
sarthak sthapit,1172 9830890040 1/13/2064 IT 34713
shreya adhikari,1175 9816495839 12/13/2061 Admin 47574
siran kafle,1154 9827235042 4/13/2064 Officer 21197
spica bhattarai,1216 9812679817 7/13/2063 IT 21050
aashika dangal,1227 9819629208 2/11/2063 Officer 32950
ajay subedi,1179 9828980756 8/13/2062 Officer 32259
asmi ghimire,1121 9817710582 7/13/2063 Admin 25148
kriti neupane,1136 9827492425 4/13/2063 Officer 24160
nikita bhattarai,1119 9813036174 4/13/2062 Admin 39331
nitisha bajracharya,1211 9831127694 2/13/2064 Office Helper 22965
prakriti timilsina,1176 9831517267 4/13/2061 Office Helper 36364
shreya khadka,1190 9829225969 6/13/2063 Officer 27347
siddhant pokhrel,1160 9821695740 5/13/2062 Office Helper 31589
siksha basnet,1111 9820676682 6/13/2063 Admin 32262
stuti karmacharya,1164 9819708437 4/13/2062 Officer 27135
sujan aryal,1138 9817593658 10/13/2062 Officer 32910
1. Number of stock should be indicated by pcs (i.e, 20 pcs)
2. Items that are blank for the date need to fill by "No stock"
3. Frame the data with border, Make header bold and colorful
4. Convert Date format to month,day,year(as apr/mon/2019)
5. Sum datewise and itemwise
Stock summary
Date TV Mobiles Refrigerators Washing Machines Air conditioners
1/04/2019 9 106 59 44 34
2/04/2019 20 68 35 53 50
3/04/2019 7 34 52 5 38
4/04/2019 144 17 60 37
5/04/2019 24 122 18 29 22
6/04/2019 16 66 21 32 30
7/04/2019 48 159 48 51 26
8/04/2019 40 159 37 56 17
9/04/2019 42 162 51 46 20
10/04/2019 27 57 65 30
11/04/2019 19 36 18 3
12/04/2019 49 193 28 45
13/04/2019 9 173 10 17 58
14/04/2019 57 99 17 28 21
15/04/2019 21 91 29 7 3
16/04/2019 24 11 13 59 62
17/04/2019 47 103 52 7 3
18/04/2019 9 15 5 39
19/04/2019 29 182 18 41
20/04/2019 49 121 37 31 5
21/04/2019 48 119 24 50 19
22/04/2019 23 65 59 45 52
23/04/2019 42 182 36 51 33
24/04/2019 12 4 21 50 57
25/04/2019 16 49 22 22
26/04/2019 31 26 34 49 36
27/04/2019 48 73 28 42 60
28/04/2019 14 99 6 54 27
29/04/2019 53 42 7 43 46
30/04/2019 38 179 29 34 64
1/05/2019 58 76 55 50 63
2/05/2019 47 118 39 64 45
3/05/2019 14 95 22 6 60
4/05/2019 53 147 18 39
5/05/2019 23 117 34 21 53
6/05/2019 36 135 24 34 28
7/05/2019 17 158 35 39 60
8/05/2019 21 22 21 42 66
9/05/2019 6 104 6 30 56
10/05/2019 30 193 39 18 35
11/05/2019 26 111 47 2 37
12/05/2019 32 158 26 69
13/05/2019 11 158 8 47 70
14/05/2019 51 91 27 30 69
15/05/2019 53 66 58 13 29
16/05/2019 58 6 60 20 25
17/05/2019 60 42 10 17
18/05/2019 51 176 44 20 16
19/05/2019 34 78 55 4 57
20/05/2019 47 135 18 63
21/05/2019 16 176 15 33 58
22/05/2019 16 97 37 65 41
23/05/2019 12 113 23 14 26
24/05/2019 69 31 47 9
25/05/2019 27 57 53 32
26/05/2019 20 113 46 36 34
27/05/2019 16 59 41 53 63
28/05/2019 51 47 55 28 63
29/05/2019 47 45 50 42 61
30/05/2019 24 196 39 44 45
31/05/2019 57 76 46 35 42
1/06/2019 10 191 50 49 7
2/06/2019 56 75 7 54
3/06/2019 11 182 43 50 62
4/06/2019 51 137 7 28 51
5/06/2019 60 139 36 23 2
6/06/2019 7 150 9 49 32
7/06/2019 68 9 57 3
8/06/2019 29 176 8 30 47
9/06/2019 47 64 16 57 34
10/06/2019 33 85 50 17 12
11/06/2019 43 21 58 17 68
12/06/2019 14 50 31 29 35
13/06/2019 39 193 7 27 38
14/06/2019 43 149 45 24
15/06/2019 13 183 21 14 55
16/06/2019 22 166 55 21 37
17/06/2019 29 148 43 56 4
18/06/2019 7 34 29 3
19/06/2019 182 52 25
20/06/2019 60 7 44 46 46
21/06/2019 21 45 10 30
22/06/2019 16 30 28 68 23
23/06/2019 34 81 24 29 10
24/06/2019 53 159 38 21
25/06/2019 41 78 11 19 10
26/06/2019 31 200 56 54
27/06/2019 21 188 43 31 33
28/06/2019 33 174 12 39 13
29/06/2019 58 33 18 65 20
Total
Laptops Speakers Total
84 187
186 155
92 36
52 184
22 137
169 34
83 253
102 194
24 292
167 144
193 225
20 293
180 195
192 83
188 210
140 218
83 70
33 143
49 231
73 264
199 243
6 220
87
181 253
119 234
113 2
157
78 20
131 47
135 191
134 191
47 156
174 50
74 170
190 4
32 295
175 146
115 27
112 19
18 158
27 71
126 55
92 22
135 193
8 218
56
155 91
66 17
176 176
194 135
60 6
24
170 133
97 243
9 241
22 161
15 110
52 15
172 226
52 51
103 42
111 111
65 74
78 272
174 70
121 234
77 60
200 96
61 287
18 28
78 119
107 246
14 76
28 67
131 252
17 31
64 140
126 221
52 233
110 249
141 17
114
117 291
118 175
84 203
72 262
83 129
38 253
90 242
58 251
Use 1000 separator and decimal place zero and place Nrs as currency for values
Sum the income and expenditure
Calculate Profit/(Loss) for each month
Calculate percentage of profit on income
Indicate loss by red font
Baishak Jeshta Asar Shrawan Bhadra Asoj

INCOME
Revenue From Operations(Net) 60770692 60550741 45756022 76345218 69787703 64395130
Other Income 360000 360000 360000 360000 360000 360000
Total Income
EXPENDITURE
Personnel Expenses 26649376 30253113 32624421 35239704 38063306 31476543
Administrative Expenses 20042679 18202687 20011657 22001524 24190377 17624326
Finance Cost 1327659 1667722 2120200 2024627 1947765 1893355
Depreciation and Amortisements 1218502 1370815 1542167 1734938 1951805 2195781
Total Expenses
Profit/(Loss)
Percentage of profit on total income

Kartik
47090870
360000
44403157
29246626
1877244
2470254
Seprate first name, mid name and last name
Calculate total sales of each sales person
Calculate monthly total sales
Calculate average sales of each sales person
Calculate monthly average sales
Sales
Sales Persons Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Isha Sharma Upreti 51012 74811 68650 66886 45695 53422 47997 45007 48135 61437 59513 39771
Dikshyant Budathoki 51669 68105 44522 63605 72407 54673 45242 67885 45687 59715 37582 46198
Divyanshu Paudel 47116 58287 39889 47150 35683 48612 36374 57278 69203 45515 37691 47034
Kajal Kumari 65345 60043 55345 42497 59595 48457 43117 67776 71325 35496 57704 68514
Kriti Kumari Devkota 49476 63725 57590 50269 68019 54750 61097 42184 38091 45476 68734 36939
Mandip Bartaula 37879 40551 58132 45525 36123 43298 61902 64096 48977 45321 44552 35248
Nikita Khulal 36518 36745 51596 74818 47016 63844 72706 73267 59767 59118 44649 47380
Parartha Singh Karki 40680 54354 73142 56645 63493 45534 37150 38340 42135 35295 47144 52893
Prawash Lama 39822 55828 55521 69196 46293 38932 66905 43909 43454 58516 60418 39356
Prince Bartaula 69188 52625 71327 73095 63812 70473 45633 69787 70009 41139 68855 56729
Rayan Budathoki 64537 45639 50607 74271 41872 68948 50922 74908 67595 65326 49679 71980
Rhythm Paudel 65448 38123 66748 68840 54739 62266 58621 39979 72672 49673 47152 66067
Rijan Parajuli 44914 58303 36093 35015 71862 46720 67776 56650 68180 61125 56251 56792
Rojina Bista 57614 44253 74792 64074 37956 68943 40116 69935 65760 70425 37163 64188
Shubham Khadka 62405 60678 52646 38022 53595 46719 48938 45476 45821 54855 56218 38299
Sital Sunar 66753 61704 42362 67929 49632 66001 58646 39399 60396 69839 43672 70618
Sriju Joshi 37182 67235 49111 58605 43343 55808 67486 63332 38070 65989 65684 74009
TOTAL
Average
Total Average Sales
Criteria
if employee basic scale is greater than 15000, allowance 10% will be provided
if employee basic scale is less than 20000 and allowance is greater than 0, benefit of 5% will be provided
if employee basic scale is greater than 21000 or allowance is greater than 1900 or benefit is greater than 900, extra benefit of 2 % will be provided
IT Department will be provided a special allowance of 1000 rupees
Calculate Total Salary
S.N Name of Employee Cell No. Appointment Date Department Basic Scale Allowance Benefit Extra Benefit
Nikki Manandhar 9831868500 7/13/2063 Admin 17300
Pragyan Shakya 9812524016 1/13/2061 IT 17090
Prapti Shrestha 9819728661 10/13/2063 HR 19656
Rebika Pakhrin 9818869281 8/13/2062 HR 21167
Sajana Dhakal 9826612017 4/13/2063 Admin 17727
Sangarsha Chaulagain 9822987131 8/13/2063 Officer 19487
Sarthak Khatiwada 9814926591 1/13/2064 IT 19085
Shruti Gautam 9829373173 7/13/2063 IT 15139
Sishan Siwakoti 9814352435 6/13/2063 Admin 22772
Sparsha Lamichhane 9817042915 1/13/2063 Admin 23633
Sujal Sapkota 9814882464 3/13/2063 HR 16605
Swarnim Bhusal 9813001918 2/13/2063 Office Helper 19574
Yugal Bhomjan 9829296197 11/13/2063 HR 16713
Raghav Tamang 9830540826 11/13/2063 Admin 18228
Aasutosh Pokhrel 9815403311 10/13/2063 Officer 14900
Anubhav Dhungana 9825027932 8/13/2062 HR 16481
Dikshyant Budathoki 9826542894 5/13/2061 IT 21084
Divyanshu Paudel 9826026872 12/24/2063 IT 12456
Kajal Kumari 9826675474 7/13/2064 Admin 18769
Kriti Devkota 9818627037 3/13/2063 Admin 19107
Lelin Shiwakoti 9816639318 11/13/2063 Admin 23776
Mandip Bartaula 9830147652 2/13/2064 Admin 19789
Nikita Khulal 9822909015 9/13/2064 Admin 17563
Parartha Karki 9817083951 2/13/2063 IT 17142
Prawash Lama 9815735596 8/13/2063 Admin 20696
Prince Bartaula 9813137341 7/13/2063 Admin 17544
Rayan Budathoki 9820815869 1/13/2061 Admin 18184
Rhythm Paudel 9817450359 5/13/2062 Office Helper 24712
Rijan Parajuli 9818333203 4/13/2063 HR 23775
Rojina Bista 9812777482 2/13/2064 Officer 17640
Shubham Khadka 9831189354 7/13/2063 IT 16419
Sital Sunar 9821473433 2/13/2063 IT 19845
Sriju Joshi 9824378963 8/13/2062 Admin 16249
Suyesh Shrestha 9814830063 2/13/2062 Office Helper 18065
Abhiyan Parajuli 9815815742 3/13/2064 Officer 24155
Anirudra Upreti 9831394024 2/13/2064 Office Helper 24413
Raghav Regmi 9831986251 8/13/2019 Admin 15228
Rohit Chapagain 9824029017 5/13/2063 HR 24798
Sabina Tamang 9815449724 6/13/2063 Admin 20777
Sambandha Shrestha 9820667469 10/13/2062 IT 18477
Sambriddhi Pudasaini 9816163645 3/13/2061 HR 22260
Shishir Budathoki 9831060526 3/13/2062 Admin 23406
Urja Kayastha 9815434916 5/13/2063 Admin 16829
Aagaman Koirala 9814415798 8/13/2063 Officer 21490
Garima Thokar 9820781720 1/13/2063 Admin 18998
Ishan Sharma 9819862875 10/13/2062 HR 18113
Jasbin Lama 9820958973 8/25/2063 HR 20383
Mijash Mishra 9815325182 3/13/2063 IT 22170
Nischalta Timilsina 9822307818 11/13/2063 Office Helper 22511
Prajjwal Lamichhane 9814397448 10/13/2063 HR 19434
Prasamsha Adhikari 9812862189 2/13/2064 Officer 15187
Prasuma Acharya 9816024107 5/13/2063 Office Helper 24285
Rohan Deula 9829464516 1/13/2064 Office Helper 18795
Ronish Shrestha 9830814561 7/13/2062 Officer 18666
Sarthak Sthapit 9814022997 8/13/2063 Admin 24690
Shreya Adhikari 9825889652 9/13/2061 HR 20425
Siran Kafle 9813298649 11/13/2062 Admin 22612
Spica Bhattarai 9830890040 1/13/2064 IT 18619
Aashika Dangal 9816495839 12/13/2061 Admin 21660
Ajay Subedi 9827235042 4/13/2064 Officer 22715
Asmi Ghimire 9812679817 7/13/2063 IT 16668
Kriti Neupane 9819629208 2/11/2063 Officer 23145
Nikita Bhattarai 9828980756 8/13/2062 Officer 16283
Nitisha Bajracharya 9817710582 7/13/2063 Admin 18411
Prakriti Timilsina 9827492425 4/13/2063 Officer 17794
Shreya Khadka 9813036174 4/13/2062 Admin 19162
Siddhant Pokhrel 9831127694 2/13/2064 Office Helper 17077
Siksha Basnet 9831517267 4/13/2061 Office Helper 20137
Stuti Karmacharya 9829225969 6/13/2063 Officer 16804
Sujan Aryal 9821695740 5/13/2062 Office Helper 15879
benefit of 2 % will be provided
Special Allowance Total Salary

Calculate Sub Total for each province for each month
Sales Person Province Baishak Jestha Asar Shrawan Bhadra

PRABESH DULAL Bagmati 44895 28825 44586 26525 48757
NUJHAT JAHAN Province 2 62747 34855 49055 43854 60312
SANDHYA KUMARI BHUJGandaki 62921 59513 37390 56793 45382
SHIVA BHUJEL Gandaki 48153 40757 45334 52293 46829
DHIRAJ KUMAR SAH Province 2 41892 43782 56765 50201 33772
NABIN CHAUDHARY Bagmati 41892 34953 41683 62009 48631
PAWAN KUMAR BARNAProvince 2 27952 46515 56286 64541 32836
SAHIL SINGH Gandaki 61123 61131 56775 57155 56677
RAJI SHRESTHA Gandaki 30563 48308 36866 41644 51869
UNNATI PUDASAINI Bagmati 47742 42159 50859 64918 61397
NABIN DEULA Province 2 62408 32084 39393 59871 33696
KEDAR NATH CHAUDHAGandaki 32383 35536 42600 64438 41431
DINESH KHAREL Gandaki 57844 28407 25921 25289 39092
APARNA ADHIKARI Province 2 29020 55787 28702 30381 46512
PRAJINA BHLON Bagmati 52284 44200 47729 39154 30812
BISHWASH PAUDEL Province 2 57739 59542 34685 49428 32757
PRASANNA THAPA Province 2 31674 31359 52110 31582 57774
GAURAB SAPKOTA Bagmati 47023 47596 63995 51970 61539
KUSHAN PHUYAL Gandaki 64718 59643 53989 43677 46455
SANDIP DAHAL Bagmati 31125 44599 53896 39894 47972
SUJAN RAI Bagmati 59941 31654 30886 38197 51455
SHIWANI DAGAURA Gandaki 36844 57681 50935 61145 26734
DEEPA KUMARI GOLE Province 2 64315 41189 35984 62132 57294
SUJIT KUMAR BARNAWABagmati 40222 26560 36313 47191 42506
NIKESH NEPAL Province 2 56350 34251 60632 58051 55604
DIPIKA BARTAULA Gandaki 41461 61400 57399 42004 39590
DIPESH SHRESTHA Gandaki 44949 46722 50799 57701 46986
KRIJAN MAINALI Bagmati 55485 45810 35578 52678 61240
SHYAM PRASAD Province 2 39371 47642 37288 50936 54681
NANDANI KUMARI Gandaki 48528 36481 56248 42866 48195
NISCHAL BAJRACHARYAGandaki 54977 34214 53309 63802 40495
PRASHANT LAMICHHANProvince 2 58650 26969 32213 25942 53952
ISHAN SHRESTHA Bagmati 62902 61068 30456 42046 44526
AJIT KUMAR MAHATO Province 2 59297 62516 45308 44778 33535
MELISHA ACHARYA Province 2 34396 55024 53045 53465 55579
NIRMAL SAPKOTA Bagmati 29053 35370 26405 64847 28427
KRITIKA RIJAL Gandaki 45749 56976 36830 46371 39879
SUMINA K.C Bagmati 27022 57454 33785 31671 42768
ASMITA ADHIKARI Bagmati 54990 54469 46874 53968 26702
NIRAJAN PRASAD YADAGandaki 51808 28447 30252 38829 62559
Criteria
Calculate total marks obtained by each students
Student must secure more than 40 marks in each subject to have a pass status
Student who have pass status and secure total marks more than or equal to 450, 400 and less than 400 will get a comment "Excellent",
Name Nepali English Science Math Social Computer Total Marks

Anubhav Dhungana 93 51 89 95 59 63
Dikshyant Budathoki 44 56 69 59 58 44
Divyanshu Paudel 46 59 66 98 72 38
Kajal Kumari 67 56 71 94 78 44
Kriti Devkota 93 61 89 48 64 45
Lelin Shiwakoti 74 50 70 42 93 67
Mandip Bartaula 91 38 84 87 74 63
Nikita Khulal 63 55 86 80 49 82
Parartha Karki 78 62 59 51 73 81
Prawash Lama 42 66 84 67 47 61
Prince Bartaula 93 61 70 93 44 71
Rayan Budathoki 71 80 55 58 88 70
Rhythm Paudel 71 88 46 99 83 59
Rijan Parajuli 81 45 61 54 79 97
Rojina Bista 53 55 48 91 58 89
Shubham Khadka 80 72 74 84 66 62
Sital Sunar 87 78 54 85 77 93
Sriju Joshi 45 95 83 82 64 79
Suyesh Shrestha 82 90 68 76 74 55
Abhiyan Parajuli 42 38 44 63 48 58
Anirudra Upreti 74 69 40 67 59 85
Raghav Regmi 44 96 43 96 91 48
Rohit Chapagain 45 94 96 47 86 85
Sabina Tamang 56 68 64 76 53 97
Sambandha Shrestha 47 83 43 50 44 88
Sambriddhi Pudasaini 87 97 67 38 70 93
Shishir Budathoki 41 73 67 67 72 55
Urja Kayastha 91 40 69 94 40 75
Aagaman Koirala 45 68 51 38 59 74
Garima Thokar 68 41 93 82 89 62
Ishan Sharma 62 64 99 57 79 55
Jasbin Lama 94 70 58 38 50 64
Mijash Mishra 57 93 42 74 75 88
Nischalta Timilsina 92 46 60 49 38 54
Prajjwal Lamichhane 69 40 85 79 78 46
Prasamsha Adhikari 67 95 89 60 72 45
Prasuma Acharya 81 73 96 95 84 43
Rohan Deula 81 94 43 74 91 60
Ronish Shrestha 83 40 74 75 93 71
Sarthak Sthapit 75 72 75 84 71 52
Shreya Adhikari 69 66 49 62 68 59
Siran Kafle 72 67 59 61 83 90
Spica Bhattarai 51 39 84 46 71 91
Aashika Dangal 55 42 69 62 38 63
Ajay Subedi 93 93 60 51 42 87
get a comment "Excellent", "Very good" and "Good". But who fails they will get a comment "Work Hard"
Status(Pass/Fail) Comment
Count Number of Absent Days of each staffs
Name Absent Date

Prawash Lama 2/14/2020
Prince Bartaula 2/18/2020
Rayan Budathoki 2/22/2020
Rhythm Paudel 2/26/2020
Rijan Parajuli 3/1/2020
Rojina Bista 3/5/2020
Shubham Khadka 3/9/2020
Sital Sunar 3/13/2020
Sriju Joshi 3/17/2020
Suyesh Shrestha 3/21/2020
Abhiyan Parajuli 3/25/2020
Anirudra Upreti 3/29/2020
Raghav Regmi 4/2/2020
Rohit Chapagain 4/6/2020
Sabina Tamang 4/10/2020
Sambandha Shrestha 4/14/2020
Sambriddhi Pudasaini 4/18/2020
Shishir Budathoki 4/22/2020
Urja Kayastha 4/26/2020
Aagaman Koirala 4/30/2020
Garima Thokar 5/4/2020
Employees Name should be in Proper Case
Criteria of Salary:
Basic Salary of office assistant,junior officer, senior officer and executive officer will be 30000,35000,50000 and 75000 respectively
Allowance will be provided on department wise; 5%, 7%, 8% and 10%(of basic salary) for HR, Account, Admin and IT respectively
Special Benefit will be provided only to IT department but designation wise benefit percentage will be different. 3%, 5%, 6% and 8% (of basic salary) for assistant, ju
Calculate Gross Salary
Calculate Taxable income and tax accordingly
Employee Name Department Designation Basic Salary Allowances Special Benefit

REBINA LOPCHAN Account Office Assistant
CHANDRAKANTA SINGH KHANAL IT Junior Officer
MAHAMMAD SHAHAJAD ANSARI Account Senior Officer
SAMPADA RUPAKHETI IT Senior Officer
SOMIYA KARKI IT Office Assistant
SHRISTI DHAKAL Account Junior Officer
RABIN SUNARI MAGAR HR Senior Officer
ABHAYA THAPA MAGAR Account Senior Officer
KRISHAL RAWAL IT Executive Officer
DIPESH NEPAL HR Senior Officer
SUBODH TIMALSINA HR Junior Officer
DIPESH PURI Account Executive Officer
CHAKIT PAUDEL Admin Executive Officer
PRABESH DULAL HR Executive Officer
NUJHAT JAHAN IT Executive Officer
SANDHYA KUMARI BHUJEL Admin Junior Officer
SHIVA BHUJEL Admin Executive Officer
DHIRAJ KUMAR SAH IT Executive Officer
NABIN CHAUDHARY Account Executive Officer
PAWAN KUMAR BARNAWAL HR Junior Officer
SAHIL SINGH Account Junior Officer
RAJI SHRESTHA Admin Junior Officer
UNNATI PUDASAINI Admin Office Assistant
NABIN DEULA Account Junior Officer
KEDAR NATH CHAUDHARY IT Office Assistant
DINESH KHAREL HR Senior Officer
APARNA ADHIKARI Admin Executive Officer
PRAJINA BHLON Account Office Assistant
BISHWASH PAUDEL Admin Junior Officer
PRASANNA THAPA HR Executive Officer
GAURAB SAPKOTA Admin Junior Officer
KUSHAN PHUYAL Admin Junior Officer
SANDIP DAHAL Account Executive Officer
SUJAN RAI Admin Senior Officer
SHIWANI DAGAURA IT Junior Officer
DEEPA KUMARI GOLE IT Junior Officer
SUJIT KUMAR BARNAWAL Account Senior Officer
NIKESH NEPAL Account Office Assistant
DIPIKA BARTAULA HR Junior Officer
DIPESH SHRESTHA Admin Senior Officer
KRIJAN MAINALI HR Junior Officer
SHYAM PRASAD Account Senior Officer
NANDANI KUMARI Account Office Assistant
NISCHAL BAJRACHARYA HR Office Assistant
PRASHANT LAMICHHANE Account Executive Officer
ISHAN SHRESTHA IT Junior Officer
AJIT KUMAR MAHATO Admin Senior Officer
MELISHA ACHARYA HR Junior Officer
NIRMAL SAPKOTA Admin Executive Officer
KRITIKA RIJAL Admin Junior Officer
SUMINA K.C Admin Senior Officer
ASMITA ADHIKARI IT Senior Officer
NIRAJAN PRASAD YADAV Account Office Assistant
NEHA RAY HR Senior Officer
ISHARA ADHIKARI IT Senior Officer
SWASTIK DHUNGEL HR Senior Officer
SANJAN KUMAR DAS BANIYA Admin Executive Officer
AAISHA SHRESTHA Account Senior Officer
BINAY YADAV Account Executive Officer
ADARSHA BOMJAN IT Junior Officer
SHRAWAN TIWARI Admin Senior Officer
BIROCHAN MAINALI HR Executive Officer
BIJAY PRASAIN HR Executive Officer
ANISH DEVKOTA IT Senior Officer
SADIKSHYA DARAI Account Office Assistant
SWASTIKA BHATTARAI Admin Junior Officer
SHUBHAM DULAL IT Executive Officer
RAJAN PRASAD DAS HR Office Assistant
SAKSHYAM GURUNG IT Junior Officer
RIJAN LAMA Account Executive Officer
PRAJWAL TIMSINA Account Executive Officer
BISHWASH PRASAD UPADHYA PAUDEL Admin Executive Officer
KIRAN KUMARI KUSHWAHA HR Senior Officer
KRIPA SHRESTHA IT Junior Officer
NIRAJ PAUDEL HR Office Assistant
NAVIN KUMAR CHAUDHARY IT Junior Officer
SHRADDHEYA SUBEDI Admin Office Assistant
ALISHA RUWALI Admin Executive Officer
KRISHNANDAN SAH HR Office Assistant
AASHUTOSHIKA HUMAGAIN Account Senior Officer
of basic salary) for assistant, junior, senior and executive officer respectively
Gross Salary
Contruct the following data into Pivot Table and analyse on different prospectives(such as, revenue generated by each cou
Date Sales Rep Name Country Product Revenue(in million)

9/28/2021 Arjun India IT services 194
9/28/2021 Joe China Electrical Appliance 124
9/28/2021 Joe Nepal IT services 711
9/28/2021 Martha India Computer Applianc 895
9/29/2021 Martha UK Electrical Appliance 581
9/29/2021 Arjun India Electrical Appliance 938
9/30/2021 Joe Nepal Electrical Appliance 305
9/30/2021 Bob China Computer Applianc 902
10/1/2021 Arjun China Computer Applianc 282
10/2/2021 Bob India Computer Applianc 435
10/2/2021 Bob UK Computer Applianc 869
10/3/2021 Martha UK Computer Applianc 334
10/4/2021 Joe Nepal Computer Applianc 537
10/4/2021 Arjun Nepal IT services 630
10/5/2021 Joe India IT services 894
10/6/2021 Jane Canada Electrical Appliance 996
10/6/2021 Bob Canada Computer Applianc 998
10/6/2021 Joe UK Computer Applianc 295
10/7/2021 Martha India IT services 663
10/7/2021 Arjun China IT services 435
10/7/2021 Martha China Electrical Appliance 637
10/7/2021 Martha Nepal IT services 877
10/7/2021 Martha UK IT services 369
10/8/2021 Joe Canada IT services 314
10/8/2021 Joe India Computer Applianc 404
10/8/2021 Jane Canada IT services 720
10/9/2021 Bob Nepal Computer Applianc 188
10/10/2021 Bob Nepal Electrical Appliance 565
10/11/2021 Bob China Electrical Appliance 830
10/14/2021 Jane China Computer Applianc 542
10/14/2021 Martha Nepal Electrical Appliance 603
10/14/2021 Joe UK Electrical Appliance 630
10/14/2021 Martha China Computer Applianc 476
10/14/2021 Bob China IT services 424
10/15/2021 Arjun Canada Computer Applianc 795
10/15/2021 Arjun Canada IT services 529
10/19/2021 Bob India Electrical Appliance 229
10/20/2021 Arjun UK Computer Applianc 257
10/21/2021 Jane India Electrical Appliance 834
10/21/2021 Jane India Computer Applianc 672
10/21/2021 Jane Canada Computer Applianc 832
10/22/2021 Joe China Computer Applianc 527
10/23/2021 Arjun UK IT services 524
10/23/2021 Arjun Nepal Electrical Appliance 155
10/25/2021 Arjun India Computer Applianc 138
10/28/2021 Martha China IT services 894
10/28/2021 Martha Canada Computer Applianc 738
10/30/2021 Jane Nepal IT services 399
10/31/2021 Joe India Electrical Appliance 824
11/1/2021 Martha Nepal Computer Applianc 534
11/5/2021 Martha Canada IT services 413
11/5/2021 Bob Canada IT services 742
11/6/2021 Joe Canada Computer Applianc 395
11/9/2021 Bob Canada Electrical Appliance 203
11/10/2021 Jane UK IT services 287
11/11/2021 Jane UK Computer Applianc 781
11/15/2021 Jane Nepal Electrical Appliance 177
11/16/2021 Arjun Nepal Computer Applianc 142
11/19/2021 Bob UK IT services 622
11/24/2021 Jane China Electrical Appliance 371
11/26/2021 Jane China IT services 156
11/29/2021 Martha Canada Electrical Appliance 452
11/30/2021 Bob Nepal IT services 211
12/1/2021 Jane India IT services 512
12/1/2021 Arjun China Electrical Appliance 914
12/1/2021 Bob UK Electrical Appliance 147
12/7/2021 Arjun UK Electrical Appliance 992
12/9/2021 Arjun Canada Electrical Appliance 941
12/10/2021 Jane UK Electrical Appliance 765
12/10/2021 Joe Canada Electrical Appliance 651
12/12/2021 Bob India IT services 434
12/16/2021 Joe UK IT services 735
12/21/2021 Jane Nepal Computer Applianc 107
1/28/2022 Martha India Electrical Appliance 795
2/23/2022 Joe China IT services 448
ue generated by each country, product, sales rep and so on)
Margin
34%
31%
20%
46%
26%
20%
20%
20%
48%
49%
25%
43%
38%
45%
20%
30%
50%
29%
44%
33%
32%
27%
45%
48%
37%
45%
32%
24%
44%
28%
23%
20%
35%
21%
27%
26%
33%
32%
45%
46%
36%
36%
25%
45%
46%
31%
30%
40%
30%
31%
38%
49%
32%
46%
25%
24%
32%
45%
33%
47%
20%
30%
30%
21%
49%
33%
25%
21%
47%
31%
26%
21%
48%
42%
31%
23%
45%
35%
20%
31%
21%
42%
25%
32%
42%
47%
47%
42%
34%
32%
22%
26%
40%
28%
32%
45%
33%
39%
34%
35%
50%
41%
35%
49%
36%
21%
22%
20%
22%
46%
38%
28%
47%
21%
22%
27%
23%
26%
26%
40%
29%
38%
50%
49%
40%
49%
31%
40%
24%
47%
35%
23%
20%
34%
30%
21%
42%
33%
38%
27%
40%
34%
20%
26%
49%
20%
45%
38%
21%
29%
20%
30%
36%
47%
25%
26%
37%
25%
44%
49%
32%
26%
37%
24%
45%
23%
20%
47%
36%
40%
22%
46%
34%
31%
23%
28%
32%
49%
31%
34%
21%
30%
26%
32%
25%
37%
22%
29%
35%
25%
36%
26%
49%
36%
39%
31%
26%
33%
29%
30%
42%
40%
35%
47%
43%
33%
32%
43%
23%
33%
22%
35%
38%
29%
44%
48%
29%
47%
35%
20%
47%
28%
46%
38%
39%
37%
34%
44%
39%
36%
45%
41%
27%
31%
31%
47%
27%
23%
45%
46%
37%
22%
20%
35%
34%
32%
49%
48%
37%
44%
48%
33%
35%
40%
20%
35%
30%
46%
25%
39%
29%
20%
36%
33%
25%
46%
20%
37%
26%
40%
46%
27%
28%
41%
35%
23%
30%
34%
49%
30%
43%
30%
49%
49%
38%
24%
23%
26%
50%
29%
30%
27%
38%
42%
27%
44%
41%
21%
30%
28%
41%
24%
43%
27%
39%
25%
21%
23%
50%
41%
40%
34%
45%
39%
40%
27%
32%
26%
38%
41%
48%
32%
47%
25%
45%
28%
45%
34%
45%
20%
35%
45%
37%
23%
27%
39%
46%
42%
48%
40%
47%
22%
38%
44%
44%
46%
25%
41%
37%
50%
47%
25%
21%
28%
30%
28%
33%
28%
40%
39%
33%
42%
31%
34%
28%
50%
45%
26%
20%
24%
37%
33%
37%
30%
36%
34%
29%
42%
30%
26%
36%
30%
39%
47%
39%
27%
39%
42%
37%
33%
43%
48%
28%
24%
20%
38%
47%
31%
45%
44%
50%
46%
21%
26%
43%
42%
36%
38%
42%
38%
20%
26%
45%
28%
20%
21%
24%
49%
29%
40%
42%
25%
41%
35%
37%
34%
46%
43%
31%
41%
28%
49%
32%
36%
44%
21%
45%
21%
37%
41%
26%
35%
25%
30%
48%
36%
21%
38%
30%
30%
27%
32%
23%
44%
29%
50%
47%
34%
38%
41%
20%
31%
21%
25%
47%
50%
27%
20%
43%
31%
42%
31%
48%
21%
21%
25%
38%
39%
42%
45%
48%
40%
48%
50%
25%
50%
44%
49%
50%
25%
46%
38%
22%
50%
37%
48%
42%
30%
33%
30%
33%
34%
22%
38%
40%
36%
37%
44%
20%
20%
48%
37%
46%
22%
47%
43%
36%
49%
45%
25%
27%
44%
28%
42%
25%
35%
45%
25%
50%
41%
31%
30%
20%
48%
44%
38%
34%
50%
40%
43%
38%
46%
25%
40%
25%
28%
49%
27%
41%
35%
30%
23%
47%
50%
24%
23%
38%
43%
46%
49%
46%
45%
50%
41%
26%
25%
48%
31%
26%
23%
31%
34%
29%
48%
37%
48%
47%
33%
47%
22%
45%
23%
49%
36%
50%
29%
25%
34%
28%
42%
24%
50%
47%
21%
39%
47%
27%
22%
33%
23%
27%
33%
41%
22%
32%
25%
35%
37%
22%
45%
23%
30%
34%
22%
31%
30%
43%
47%
36%
32%
20%
34%
50%
23%
29%
24%
30%
24%
35%
29%
33%
30%
33%
49%
45%
34%
38%
26%
49%
41%
38%
27%
31%
32%
22%
22%
24%
32%
32%
37%
43%
36%
48%
38%
20%
24%
22%
42%
22%
22%
30%
42%
33%
30%
27%
34%
30%
33%
49%
35%
20%
40%
37%
23%
38%
37%
23%
39%
50%
36%
35%
24%
23%
21%
34%
37%
42%
26%
44%
29%
44%
29%
42%
37%
40%
35%
32%
44%
47%
47%
30%
38%
47%
34%
44%
40%
47%
24%
45%
40%
26%
46%
37%
40%
36%
26%
28%
28%
45%
33%
46%
25%
24%
50%
22%
41%
32%
28%
31%
27%
28%
42%
29%
24%
28%
28%
40%
39%
43%
46%
50%
32%
20%
31%
41%
24%
37%
46%
34%
28%
46%
25%
21%
23%
47%
37%
30%
39%
30%
26%
29%
48%
28%
20%
40%
26%
34%
35%
21%
23%
48%
24%
36%
47%
26%
35%
39%
33%
47%
33%
31%
36%
39%
42%
27%
20%
39%
46%
28%
20%
31%
42%
35%
46%
38%
50%
29%
22%
50%
47%
49%
33%
24%
22%
38%
31%
28%
22%
46%
29%
45%
37%
22%
33%
25%
31%
48%
29%
22%
39%
48%
50%
46%
38%
41%
47%
46%
46%
30%
34%
44%
39%
29%
25%
20%
25%
20%
24%
39%
28%
22%
50%
49%
43%
46%
32%
46%
28%
41%
30%
38%
50%
50%
45%
30%
25%
21%
46%
38%
45%
20%
33%
40%
48%
40%
28%
50%
32%
46%
32%
43%
48%
45%
34%
22%
41%
48%
23%
37%
21%
21%
25%
26%
39%
38%
26%
40%
47%
36%
34%
41%
44%
31%
45%
44%
43%
20%
25%
24%
38%
39%
41%
47%
43%
46%
35%
47%
35%
46%
49%
26%
20%
34%
42%
32%
50%
38%
20%
20%
40%
27%
49%
27%
33%
45%
25%
28%
44%
38%
41%
38%
23%
30%
43%
35%
48%
36%
47%
36%
47%
48%
30%
37%
26%
23%
37%
33%
20%
50%
35%
30%
21%
35%
36%
45%
22%
21%
43%
26%
48%
40%
22%
31%
26%
29%
41%
41%
20%
23%
22%
48%
30%
50%
26%
36%
49%
28%
32%
49%
29%
32%
36%
32%
39%
30%
37%
50%
31%
33%
32%
29%
42%
25%
25%
42%
26%
28%
21%
31%

MS Excel Assignment

Uploaded by

Copyright:

Available Formats

MS Excel Assignment

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

MS Excel Assignment

Uploaded by

Copyright:

Available Formats

1.

Change data into columnwise format

Baishak Jeshta Asar Shrawan Bhadra Asoj

Percentage of profit on total income

Special Allowance Total Salary

Sales Person Province Baishak Jestha Asar Shrawan Bhadra

Name Nepali English Science Math Social Computer Total Marks

Name Absent Date

Employee Name Department Designation Basic Salary Allowances Special Benefit

Date Sales Rep Name Country Product Revenue(in million)

You might also like