Scribd Logo
Upload

Welcome to Scribd!

  • 13 views

    Ex-1 - Ba SARA's PDF

    Uploaded by

    gamershankar656

    Copyright:

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

    Ex-1 - Ba SARA's PDF

    Uploaded by

    gamershankar656
    13 views4 pages

    Original Title

    ex-1_ba SARA's.pdf (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Ex-1 - Ba SARA's PDF

    Uploaded by

    gamershankar656

    Copyright:

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

    EX NO: 1 EXPLORE THE FEATURES OF MS-EXCEL

    DATE:

    AIM:
    To explore the features of MS-EXCEL Application.

    WHAT IS EXCEL? EXCEL DEFINITION


    Microsoft's Excel spreadsheet programme is a part of the Office family of business software
    programmes. Users of Microsoft Excel can format, arrange, and compute data in a spreadsheet.
    By organising data using tools like Excel, Data Analysts or other users can make information easier to
    examine when data is added or altered. The Microsoft Office and Office 365 suites include Excel, which works
    with the other Office programmes. The spreadsheet application canbe used on Windows, macOS, Android, and
    iOS devices.

    PARTS OF MS-EXCEL WINDOW:

    Quick Access Toolbar – Collection of buttons that provide one click access to commonly
    usedcommands such as Save, Undo or Redo. You can also customize this according to your preference.
    Title Bar – A bar the display the name of active workbook
    Ribbon – The main set of commands and controls organized task in Tabs and groups, you canalso
    customize the ribbon according to your preference.
    Column Headings – The letters that appear along the top of the worksheet to identify thedifferent
    columns in the worksheet.
    Worksheet Window – A window that displays an Excel worksheet, basically this is where youwork all
    the tasks.
    Cell – The cell selected in the active worksheet

    Formula Bar – A bar that displays the value or formula entered in the active cell

    FEATURES OF MS-EXCEL
    Microsoft excel is an integrated electronic spread sheet program developed by Microsoftcorporation. It
    includes the following features.
    Autocalc: This feature is very useful to sum a group of numbers is selected them. Their sumwill
    automatically
    appear in the status area.
    Auto complete: Excel now intelligence to anticipate what you are going to type! Based uponentries

    you’ve already
    made, AutoComplete will try to figure out what you intended to type,once you’ve entered few letters.
    Autocorrect: Excel can support automatically correct mistakes.
    Better Drag-and-Drop: Do you want to move a group of cells? Excel’s drag and drop featurelets
    you reposition selected portion of your spreadsheet by simply dragging them with your mouse.
    Cell tips and Scroll Tips: To help you get around better with mouse, Excel now includes scrolltips.
    When you click
    and drag a scroll bar, a small window tells you what row or column you are
    heading for.
    Number Formatting: It’s easy to format numbers with excel’s new number formatting feature.Select
    your numbers
    and choose cells command from format menu.
    Templates and Template wizard: Excel’s template facility has been greatly enhanced. You canchoose

    from a variety
    of elegantly designed templates for your home or business. You can evenhave a template wizard link
    your
    worksheets to a database.
    Shared Lists: you can now have worksheets that are shared simultaneously over a network.

    Conditional Formatting:Conditional formatting helps users to quickly focus on importantaspects of a

    spreadsheet
    or to highlight errors and to identify important patterns in data.
    Sorting and Filtering: Excel spreadsheets help us make sense of large amounts of data. To make it

    easier to find
    what
    withinyou need, you can reorder the data or pick out just the data you need,based on parameters you set
    Excel.
    Sorting and filtering your data will save you time andmake your spreadsheet more effective.
    Excel Charts: Excel charts help you communicate insights & information with ease. By choosing your
    charts wisely
    and formatting them cleanly, you can convey a lot.
    several cells at the same time, or on more than one worksheet at the same time. Thedata that you

    enter can be
    numbers, text, dates, or times. You can format the data in a variety ofways. And, there are several settings
    that you
    can adjust to make data entry easier for you.
    Enter text or a number in a cell
    1. On the worksheet, click a cell.
    2. Type the numbers or text that you want to enter, and then press Enter or Tab.To enter data on a new line
    within a cell, enter a line break by pressing Alt+Enter Editing text or a number in a cell
    3. Double click the cell containing the data you want to edit.

    4. Make any changes to the cell contents.

    5. Press enter key. The change will accept. To cancel your changes, press Ese key.

    Wrap text in a cell


    a. Click the cell in which you want to wrap the text.
    b. On the Home tab, in the Alignment group, click Wrap Text.

    Enter And Edit Formula In Excel


    A formula performs calculations or other actions on the data in your worksheet. A formulaalways
    starts with an equal sign (=), which can be followed by numbers, math operators (like a + or -sign
    for addition or subtraction), and built-in Excel functions, which can really expand the power ofa
    Formula.
    For Example, in the above worksheet, the formula = B5+C5+D+ adds the contents 10+20+30and
    produce the results. One can enter and edit formula in two ways.

    1. Directly into cell by double clicking where the formula wants.


    2. At formula bar after selection of required cell.Number Formatting in excel

    It is very common to enter various types of numbers for various applications. In Excel, you canuse
    number formats to change the appearance of numbers, including dates and times, without changing
    the number
    behind the appearance. The number format does not affect the actual cellvalue, it changes the

    appearance only.
    1. Select the cell or cells which contain numbers.
    2. On the home tab, under Number group click on down arrow mark.
    3. Right click your mouse; from the short hand menu select format cell option
    4. It launches Formula cells window. Click on Number tab.
    5. It lists all categories of number formatting like general, number, currency,accounting, date, time,

    and percentage.

    6. Select the suitable format and its sub options, click ok button.
    7. The numbers in the selected cells will display as per new format.

    Auto fill and custom fill


    Autofill is one of the feature present in the ms excel. When you’re typing a day, month, year and number
    the automatic series will be appeared by dragging it. This feature is called Autofill. For Example if your
    typed “Jan” and then dragged then it displays months form” Janto dec” like.

    RESULT:
    The features of MS-EXCEL explored successfully and displayed desired output in neat format.

    You might also like