Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    Ang Saligan

    Uploaded by

    Jhon Kenneth Emolaga
    Microsoft Excel is a spreadsheet program that can be used to analyze statistical data. It contains various components like workbook tabs to store related data, a formula bar to create and view formulas, and a toolbar with common tools. Excel allows users to perform computations using basic formulas like addition, subtraction, multiplication, and division on cell ranges. It also provides tools to sort data and add borders to cells for layout design.

    Copyright:

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

    Ang Saligan

    Uploaded by

    Jhon Kenneth Emolaga
    33 views51 pages
    Microsoft Excel is a spreadsheet program that can be used to analyze statistical data. It contains various components like workbook tabs to store related data, a formula bar to create and view formulas, and a toolbar with common tools. Excel allows users to perform computations using basic formulas like addition, subtraction, multiplication, and division on cell ranges. It also provides tools to sort data and add borders to cells for layout design.

    Original Description:

    Filkom

    Original Title

    Ang saligan

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Microsoft Excel is a spreadsheet program that can be used to analyze statistical data. It contains various components like workbook tabs to store related data, a formula bar to create and view formulas, and a toolbar with common tools. Excel allows users to perform computations using basic formulas like addition, subtraction, multiplication, and division on cell ranges. It also provides tools to sort data and add borders to cells for layout design.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    33 views51 pages

    Ang Saligan

    Uploaded by

    Jhon Kenneth Emolaga
    Microsoft Excel is a spreadsheet program that can be used to analyze statistical data. It contains various components like workbook tabs to store related data, a formula bar to create and view formulas, and a toolbar with common tools. Excel allows users to perform computations using basic formulas like addition, subtraction, multiplication, and division on cell ranges. It also provides tools to sort data and add borders to cells for layout design.

    Copyright:

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

    FEATURES, TOOLS, FORMULAS AND TECHNIQUES IN

    MICROSOFT EXCEL
    MICROSOFT EXCEL
    IS AN EXAMPLE OF
    A SPREADSHEET
    PROGRAM WHERE
    IT CAN BE USED
    TO ANALYZE
    STATISTICAL DATA
    MICROSOFT EXCEL
    WORKBOOK COMPONENTS
    MS EXCEL - WORKBOOK COMPONENTS
    MS EXCEL - WORKBOOK COMPONENTS
    FILE MENU TAB
    WHERE YOU CAN
    OPEN
    SPREADSHEETS,
    SAVE AS .XLSX
    AND PRINT
    MS EXCEL - WORKBOOK COMPONENTS
    HOME MENU TAB
    WHERE
    YOU CAN
    USE BASIC
    SPREADSHEET
    TOOLS
    LIKE TEXT,
    ALIGNMENT, ETC
    MS EXCEL - WORKBOOK COMPONENTS
    WORKBOOK NAME
    THE FILE NAME
    OR
    SPREADSHEET
    FILE NAME
    MS EXCEL - WORKBOOK COMPONENTS
    WORKBOOK
    CONTROL BOX
    YOU CAN USE
    THIS TO SET
    YOUR WORKBOOK
    WINDOW, FULL OR
    PART.
    MS EXCEL - WORKBOOK COMPONENTS
    WORKBOOK
    TABS
    USED TO STORE
    MORE DATA
    WITH THE SAME OR RELATED
    CONTENT. AVOIDS MULTIPLE
    FILES.
    MS EXCEL - WORKBOOK COMPONENTS
    FORMULA BAR
    USED TO SHOW AND EDIT
    FORMULAS USED IN
    COMPUTATIONS
    MS EXCEL - WORKBOOK COMPONENTS
    QUICK ACCESS
    TOOLBAR
    SERIES OF TOOLS
    YOU CAN CLICK
    FOR EASIER WORK. COMMON
    TOOLS ARE SAVE, UNDO AND
    REDO BUTTONS.
    MICROSOFT EXCEL:
    WORKBOOK TABS
    MS EXCEL - WORKBOOK COMPONENTS

    INSERT TAB
    SERIES OF GRAPHIC TOOLS
    YOU CAN USE TO VISUALLY
    SUPPORT YOUR DATA
    MS EXCEL - WORKBOOK COMPONENTS

    PAGE LAYOUT TAB


    TOOLS DESIGNED TO
    ARRANGE DATA BEFORE
    PRINTOUT (ON PAPER)
    MS EXCEL - WORKBOOK COMPONENTS
    FORMULAS TAB
    MS EXCEL HAS A LIBRARY OF
    FORMULA FUNCTIONS THAT
    YOU CAN USE ON YOUR
    COMPUTATION.
    MS EXCEL - WORKBOOK COMPONENTS
    DATA TAB
    MS EXCEL CAN CHECK THE
    VALIDITY OF THE DATA (EITHER
    ALPHABETICAL OR NUMERICAL)
    PLACED ON THE CELLS
    MS EXCEL - WORKBOOK COMPONENTS
    REVIEW TAB
    MS EXCEL CAN REVIEW THE
    DATA PLACED ON THE
    WORKBOOK, CAN SET THE
    PRIVACY OF YOUR DATA.
    MS EXCEL - WORKBOOK COMPONENTS
    VIEW TAB
    MS EXCEL CAN VIEW THE DATA
    OR WORKSHEET ON YOUR
    SCREEN PREFERENCE. MAYBE
    IN WINDOW OR FULL SCREEN.
    MICROSOFT
    EXCEL:
    BASIC FORMULAS FOR
    COMPUTATIONS
    EXCEL CURSORS
    General pointer for
    selecting cells
    singly or in groups
    Used where you can
    change the dimensions
    of a Row or column.
    Pointer used at bottom right of
    selection to extend and fill data.
    Selected cells are shown by means
    of a heavy border as shown.
    Can move the content of the cell
    into a new cell location
    The I-beam which indicates the
    cursor position when editing
    a cell entry.
    To select cells on the worksheet.
    Selects whole row/column
    when positioned
    on the number/letter heading label.
    MICROSOFT EXCEL:
    BASIC FORMULAS
    FORMULAS AND
    COMPUTATIONS WILL WORK
    WHEN STARTS WITH
    =FORMULA(LETTERNUMBER)
    EX: =SUM(A1:A:10) (ADDITION)
    MICROSOFT EXCEL:
    BASIC FORMULAS
    FORMULA FOR AVERAGE

    EX: =AVERAGE(A1:A10)
    MICROSOFT EXCEL:
    BASIC FORMULAS
    ADDITION “ + ”
    (ADD SIGN)

    EX. =(A1+A2)
    MICROSOFT EXCEL:
    BASIC FORMULAS
    SUBTRACTION “ - “
    (MINUS SIGN)

    EX. =(A1-A2)
    MICROSOFT EXCEL:
    BASIC FORMULAS
    MULTIPLICATION “ * “
    (ASTERISX SIGN)

    EX. =(A1*A2)
    MICROSOFT EXCEL:
    BASIC FORMULAS
    DIVISION “ / ”
    (SLASH SIGN)

    EX. =(A1/A2)
    MICROSOFT EXCEL:
    BASIC TOOLS
    SORT DATA BY USING
    MICROSOFT EXCEL:
    BASIC TOOLS
    LAYOUT DESIGN
    BY USING
    BORDERS

    You might also like