Scribd Logo
Upload

Welcome to Scribd!

  • 6 views

    Adv Excel

    Uploaded by

    aptech.office11

    Copyright:

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

    Adv Excel

    Uploaded by

    aptech.office11
    6 views9 pages

    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
    6 views9 pages

    Adv Excel

    Uploaded by

    aptech.office11

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 9

    No Name Course Marks Grade Status

    1 Chris Software engineering 50 B PASS


    2 Manju OOP 80 A PASS
    3 John Multimedia 34 D FAIL
    4 Susan HTML 50 C PASS
    5 John NETWORKING 45 D FAIL Dsum 152
    6 Mithu OOP 89 A PASS Daverage 76
    7 Daisy Net programming 65 B PASS
    8 Minhas Data Science 78 A PASS
    9 Jeenah Software engineering 74 B PASS
    10 Tina Java 98 A PASS Dsum 152
    11 Sima PHP 89 A PASS Daverage 76
    12 Neeta Net programming 34 D FAIL
    13 Eric RDBMS 55 B PASS
    14 RAM java 90 a PASS
    15 Meena PHP 75 b PASS
    16 Eric UML 87 a PASS
    17 Jack Net programming 96 A PASS
    18 Ricky Networking 76 B PASS
    19 Billy RDBMS 56 c PASS
    20 Jack OOP 89 a PASS
    21 John Html 76 A PASS
    22 Maria Multimedia 80 A PASS
    23 John Networking 76 b PASS
    24 Frank OOP 34 D FAIL
    25 Eric hml 75 C PASS
    CRITERIA
    Name Marks
    John >55

    110
    No Name Course Marks
    1 Chris Software engineering 50 78 85
    2 Manju OOP 80 30
    3 John Multimedia 120 34 174
    4 Susan HTML 50 23
    5 John NETWORKING 45 87
    6 Mithu OOP 500 100
    7 Daisy Net programming 65 250
    8 Minhas Data Science 200 20
    9 Jeenah Software engineering 74 500
    10 Tina Java 98 90
    11 Sima PHP 300 89
    12 Neeta Net programming 34 90
    values
    20 40 values comm ex Final
    35 45 90 5 4 10
    85 50 85 4 2 14.16667
    148 100 45 21 6 1.666667
    23 200 24 6 4 2.4
    120 250 75 0 0.

    148 200
    product units price total product units price
    Tv 5 48000 240000 Tv 6 56000
    I-Pad 15 35000 525000 I-Pad 15 35000
    Apple Laptop 5 98000 490000 Apple Lapt 5 98000
    Monitor 25 5000 125000 Monitor 25 5000

    total 1380000 total 1476000


    Product units price
    Laptop 4 45000
    Headphones 7 67000
    Keyboard 12 56000
    Monitor 8 36000
    Tv 10 20000

    total 1809000
    2012 Regional Mobile Sales 2012 Regional Mobile Sales
    Region No. of orders Total Sales Region No. of ordeTotal Sales
    East 228 $ 49,017.00 East 228 $ 49,017.00
    East 226 $ 71,300.00 East 226 $ 71,300.00
    East 270 $ 76,800.00 East 270 $ 76,800.00
    North 240 $ 50,476.00 North 240 $ 50,476.00
    North 225 $ 40,000.00 North 225 $ 40,000.00
    South 260 $ 56,300.00 South 260 $ 56,300.00
    West 250 $ 55,789.00 West 250 $ 55,789.00
    197117
    90476
    East >50000 148100
    148100
    Real estates home sales report May- June 2011
    Address Sales Date Selling Price
    345, St Paul Street 5/1/2011 $ 651,000.00
    980, Hutchison Lane 5/2/2011 $ 345,000.00
    234, Rock Wall Streets 6/3/2011 $ 238,000.00
    567, Elfins Drive 6/25/2011 $ 897,000.00
    132 Crossword Street 7/30/2011 $ 234,000.00

    Total cells 21
    Occupied cells 19
    Numeric Values 10
    Blank cells 2
    countif sales>500000 2
    2012 Regional Mobile Sales
    Region No. of ordeTotal Sales
    East 228 $ 49,017.00
    East 226 $ 71,300.00
    East 270 $ 76,800.00
    North 240 $ 50,476.00
    North 225 $ 40,000.00
    South 260 $ 56,300.00
    West 250 $ 55,789.00

    countifs
    East >50000 2

    You might also like