Scribd Logo
Upload

Welcome to Scribd!

  • 28 views

    Functions SUM Product Difference Quotient: SUM Count MIN MAX Average

    Uploaded by

    Jay Ann Dome
    The document contains data on functions X, Y, and Z for 15 entries. It lists the sums, products, differences, and quotients of the functions but leaves the values blank. It also lists counts, minimums, maximums, and averages to be calculated for the functions.

    Copyright:

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

    Functions SUM Product Difference Quotient: SUM Count MIN MAX Average

    Uploaded by

    Jay Ann Dome
    28 views4 pages
    The document contains data on functions X, Y, and Z for 15 entries. It lists the sums, products, differences, and quotients of the functions but leaves the values blank. It also lists counts, minimums, maximums, and averages to be calculated for the functions.

    Original Title

    EXCELFunctions

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains data on functions X, Y, and Z for 15 entries. It lists the sums, products, differences, and quotients of the functions but leaves the values blank. It also lists counts, minimums, maximums, and averages to be calculated for the functions.

    Copyright:

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

    Functions SUM Product Difference Quotient: SUM Count MIN MAX Average

    Uploaded by

    Jay Ann Dome
    The document contains data on functions X, Y, and Z for 15 entries. It lists the sums, products, differences, and quotients of the functions but leaves the values blank. It also lists counts, minimums, maximums, and averages to be calculated for the functions.

    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 4

    Functions X Y Z SUM PRODUCT DIFFERENCE QUOTIENT

    6 4 6 =Prod-sum =Prod/sum, 2 decimal


    9 7 5
    12 6 4 NOTE: Use formula for SUM and PRODUCT
    15 5 3
    18 4 2
    12 3 4
    10 2 6
    8 10 8
    6 8 9
    4 7 10
    2 6 11
    -1 5 12

    SUM ? ? ? ? ?
    COUNT ? ? ? ? ?
    MIN ? ? ? ? ?
    MAX ? ? ? ? ?
    AVERAGE ? ? ? ? ?

    PREAPRED by : YOUR NAME


    QUOTIENT
    =Prod/sum, 2 decimal places only
    Desc
    S# Product Qty Price AMOUNT
    P-0001 Mango 10 50 AMT = QTY x PRICE
    P-0002 Oranges 12 20
    P-0003 Grapes 3 200
    P-0004 Pineapple 6 70.5
    P-0005 Coconut 5 35
    P-0006 Banana 5 64.95
    P-0007 Watermelon 6 60.75
    P-0008 Dalandan 12 40
    P-0009 Pomelo 5 72
    P-0010 Lanzones 2 120
    SUM Use SUMMATION -SUM
    AVERAGE
    LOWEST
    HIGHEST
    COUNT
    Stud No PRE MID SFNL FINAL AVERAGE
    21-001 85 86 84 83
    21-002 85 84 84 82
    21-003 86 85 87 85
    21-004 80 82 80 79
    21-005 77 76 74 72
    21-006 90 88 90 87
    21-007 87 89 88 86
    21-008 88 90 86 85
    21-009 89 91 87 84
    21-010 90 92 88 86
    21-011 91 93 89 85
    21-012 92 94 90 88
    21-013 74 75 76 70
    21-014 78 80 82 82
    21-015 88 86 84 85
    MIN
    MAX
    AVERAGE

    You might also like