Scribd Logo
Upload

Welcome to Scribd!

  • 1 views

    Excel Fundamentals Manual 拆分31

    Uploaded by

    Katrina Chow
    Maths

    Copyright:

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

    Excel Fundamentals Manual 拆分31

    Uploaded by

    Katrina Chow
    1 views1 page
    Maths

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Maths

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    1 views1 page

    Excel Fundamentals Manual 拆分31

    Uploaded by

    Katrina Chow
    Maths

    Copyright:

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

    Microsoft Excel

    USING THE SUM FUNCTION TO ADD


    One of the most used functions is the SUM type the function, and then use the pointing
    function. This function allows you to add the technique to fill in the arguments. Excel then paints
    values in a range of cells. The function is written marquees around the cells involved helping you to
    as: =SUM(range or ranges to add). You can track your progress.

    1
    Try This Yourself:
    Before starting this exercise
    Open
    File

    you MUST open the file E710


    Formulas_4.xlsx...

    Click on B9 then type =sum(


    
    to start the formula
    Click on B6 to point to this cell
    
    as the start, hold down the
    key and click on B8
    2
    Notice the relative addressing
    details, 3R x 1C, that appear in
    the tool tip…

    
    Type ) and press
    complete the function
    to

    Click on B9, then move the


    
    mouse pointer to the fill handle
    on the lower right corner of the
    cell and drag across to E9 to
    fill the selected range with the 7
    equivalent functions
    Click on the Copy command
     on the Clipboard group on
    the Home tab

    
    Click on B14, hold down
    and then click on cells B19
    and B24
    Release and press
    
    to paste equivalent functions
    into the worksheet

    For Your Reference… Handy to Know…


    To type a sum function for a contiguous range:  You can also use the Sum command in the
    1. Type =sum( Editing group on the Home tab of the
    Ribbon to have Excel automatically enter a
    2. Select the range of cells
    sum function based on a range of cells.
    3. Type )
     You can also type the name of a function in
    4. Press upper or lowercase – it is not case sensitive.

    [email protected] Page 27 St. George’s Information Services

    You might also like