Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Part 121 To 127 Practice Sheets

    Uploaded by

    ashutoshbharti0707

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Part 121 To 127 Practice Sheets

    Uploaded by

    ashutoshbharti0707
    3 views11 pages

    Original Title

    PART 121 TO 127 PRACTICE SHEETS (2)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    3 views11 pages

    Part 121 To 127 Practice Sheets

    Uploaded by

    ashutoshbharti0707

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 11

    Salesman Sales SUM

    Shaktimaan 45 SELECT FUNCTION MAX


    Ironman 65 SUM MIN
    Superman 32 AVG
    586
    Thor 65 COUNT
    Batman 98
    Spiderman 65 1
    Antman 32
    Hitman 65
    Ratman 54
    Netman 65
    Salesman Product Zone Sales Product ID Product ID Salesman Zone
    Shaktimaan Zandubalm South City 99 1231 1231 Shaktimaan South City
    Ironman Tigerbalm North City 65 1232 1232 Ironman North City
    Superman Toothpaste West City 32 1233 1233 Superman West City
    Thor Toothbrush South City 65 1234 1234 Thor South City
    Batman Iodex North City 98 1235 1235 Batman North City
    Spiderman Tigerbalm West City 65 1236 1236 Spiderman West City
    Antman Toothbrush South City 32 1237 1237 Antman South City
    Hitman Zandubalm North City 65 1238 1238 Hitman North City
    Ratman Zandubalm West City 54 1239 1239 Ratman West City
    Netman Tigerbalm South City 65 1240 1240 Netman South City
    Product Sales
    Zandubalm 99
    Tigerbalm 65
    Toothpaste 32
    Toothbrush 65
    Iodex 98
    Tigerbalm 65
    Toothbrush 32
    Zandubalm 65
    Zandubalm 54
    Tigerbalm 65
    Salesman Product Zone Sales Product ID CHOOSE FORMULA
    Shaktimaan Iodex South City 45 1231 Product ID 1231
    Ironman Tigerbalm North City 65 1232 Salesman Shaktimaan
    Superman Toothpaste West City 32 1233 Product Iodex
    Thor Toothbrush South City 65 1234 Zone South City
    Batman Iodex North City 98 1235 Sales 45
    Spiderman Tigerbalm West City 65 1236
    Antman Toothbrush South City 32 1237
    Hitman Zandubalm North City 65 1238
    Ratman Zandubalm West City 54 1239
    Netman Tigerbalm South City 65 1240
    Salesman Product Zone Sales Product ID INDEX AND MATCH
    Shaktimaan Iodex South City 45 1231 Product ID 1236
    Ironman Tigerbalm North City 65 1232 1 Salesman Spiderman
    Superman Toothpaste West City 32 1233 2 Product Tigerbalm
    Thor Toothbrush South City 65 1234 3 Zone West City
    Batman Iodex North City 98 1235 4 Sales 65
    Spiderman Tigerbalm West City 65 1236
    Antman Toothbrush South City 32 1237 Spiderman
    Hitman Zandubalm North City 65 1238
    Ratman Zandubalm West City 54 1239
    Netman Tigerbalm South City 65 1240
    7
    Spiderman
    Product Branch Product ID Price Product
    1100012311,11234901,11 Delhi 1100-234 4479 1100012311
    1100012312 Mumbai 1100-235 4210 1100012312
    1100012313,1123121,23 Bangluru 1100-236 3660 1100012313
    1100012314 Bhopal 1100-324 3992 1100012314
    1100012315 Delhi 1100-453 4331 1100012315
    1100012316,234,3 Mumbai 1100-568 4191 1100012316
    1100012317,0 Bangluru 1100-230 3796 1100012317
    1520, 1100012318 Bhopal 1100-987 4148 1100012318
    1100012319 Bhopal 1100-345 4544 1100012319
    1100012320,345,90 Mumbai 1100-090 4344 1100012320
    85,1100012321,89 Ghaziabad 1100-212 3696 1100012321
    1100012322,90,76777 Ghaziabad 1100-467 4260 1100012322
    Branch Product IDPrice
    Delhi 1100-234 4479
    Mumbai 1100-235 4210
    Bangluru 1100-236 3660
    Bhopal 1100-324 3992
    Delhi 1100-453 4331
    Mumbai 1100-568 4191
    Bangluru 1100-230 3796
    Bhopal 1100-987 4148
    Bhopal 1100-345 4544
    Mumbai 1100-090 4344
    Ghaziabad 1100-212 3696
    Ghaziabad 1100-467 4260
    Support Name Course Paid Fees Name Course Paid Fees
    Ajay SharmaTally Ajay Sharma Tally 1500 Vikas Singh Excel 3500
    Vikas SinghExcel Vikas Singh Excel 3500
    Raj JadhavTally Raj Jadhav Tally 3500
    Anil KumarExcel Anil Kumar Excel 1500
    Vikas SinghTally Vikas Singh Tally 2500
    Raj JadhavExcel Raj Jadhav Excel 6500
    Anil KumarTally Anil Kumar Tally 4500
    FirstName LastName TotalSalary Name
    Ravi Singh 21138 Q.1 Ravi Verma
    Ravi Verma 18717
    Ravi Tiwari 14935
    Ravi Pandey 12272 Name
    Shankar Singhaniya 17170 Q.2 RajeshKumar

    Shankar Pandey 15754


    Shankar Kumar 25766 FirstName
    Shankar Singh 25843 Q.3 Ravi
    Rajesh Singhaniya 24866

    Rajesh Pandey 23181

    Rajesh Kumar 19497


    Rajesh Singh 10493
    Vikas Shukla 10493
    Ravi Jadhav 10493
    Total Salary
    18717

    Total Salary
    19497

    LastName Total Salary


    Pandey 12272

    You might also like