Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    Business Analytics Lab Manual

    Uploaded by

    510821205029 IT

    Copyright:

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

    Business Analytics Lab Manual

    Uploaded by

    510821205029 IT
    2 views3 pages

    Original Title

    BUSINESS ANALYTICS LAB MANUAL

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    2 views3 pages

    Business Analytics Lab Manual

    Uploaded by

    510821205029 IT

    Copyright:

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

    BUSINESS ANALYTICS LAB MANUAL

    EXP 1: Explore the features of Ms-Excel


    Basics of MS Excel : Features of MS Excel , Worksheets and Workbooks: Definition of Worksheets and
    Workbooks, Opening, Labeling and Naming Worksheets and Workbooks , Adding, Deleting and Saving
    Worksheets and Workbooks, Format Worksheet Tabs, Reposition Worksheets, Inserting, Deleting, and
    Renaming Worksheets, Copy Worksheet.

    Basics of MS Excel : Features of MS Excel , Worksheets and Workbooks: Definition of Worksheets and
    Workbooks, Opening, Labeling and Naming Worksheets and Workbooks , Adding, Deleting and Saving
    Worksheets and Workbooks, Format Worksheet Tabs, Reposition Worksheets, Inserting, Deleting, and
    Renaming Worksheets, Copy Worksheets.

    SAVING, OPENING AND CLOSING WORKBOOK


    • To create a new blank workbook, click the new icon on the Standard toolbar or press
    Ctrl + N.
    SavingaWorkbook

    • To save your document click Save under the File menu or press Ctrl + S. Select a location
    tosave the workbook in and an appropriate name and click Save.
    OpeninganExistingWorkbook

    If you have a workbook that you have already been working on, you can open it from Excel. You
    can do so in three ways;

    Click File > Open


    • Click the Open toolbar icon
    • Press Ctrl + O
    C l o s i n g E x c e l a n d t h e w o r k b o o k : There are 3 ways to close a workbook:
    • Click File > Close
    • Click the lower X in the top right corner of the window
    • Or Press Ctrl + W
    These methods will close the workbook and leave Excel open.
    There are also 3 ways to exit Excel:
    • Click File > Exit
    • Click the upper X in the top right corner of the window
    • Or press Alt + F4
    These methods will close Excel and all op

    Entering And Editng Data :

    To enter data into Excel, click on the cell, type in your data and press Enter.
    After pressing Enter the cell below the current one then becomes the active cell. Other
    alternatives are:
    Tab key: Enters the data and the cell to the right of the current cell becomes the active
    cell
    Arrow keys: Enters the data and the cell dependent on the direction of the arrow key
    pressed becomes the active cell
    Mouse click: Enters the data and the cell clicked becomes the active cell
    Esc key: Cancels the entry

    Adding, Deleting, Labeling Worksheet:


    To insert a new worksheet in front of an existing worksheet, select the existing worksheet
    and then, click Home > click on Insert option in cells group > select Insert Sheet option

    Deleting a worksheet
    ➢ Select the worksheet that you wish to delete. Click the “Delete” button in the “Cells”
    button group on the “Home” tab of the Ribbon - Then choose the “Delete Sheet” choice in
    the
    button’s drop-down menu.
    INSERTION AND DELETION OF ROWS

    Inserting rows on a worksheet

    • Select the row, or a cell in the row below where you want the inserted row to appear. For example, if
    you wanted to insert a row between rows 7 and 8, select row 8.

    • Click Insert > Rows Inserting columns on a worksheet

    • Select the column, or a cell in the column to the right of where you want the inserted column to
    appear. For example, if you wanted to insert a column between columns C and D, select column D.

    • Click Insert > Columns Inserting cells on a worksheet

    • Select the cell, or the range of cells where you want to insert the new cells. Select the same number of
    cells as you would like to insert

    • Click Insert > Cells

    • In the dialogue box that appears select the direction in which to shift the surrounding cells Deleting
    rows, columns, and cells

    • Select the rows or columns to be deleted.

    • Click Edit > Delete

    EXP 2: (i) Get the input from user and perform numerical
    operations (MAX, MIN, AVG, SUM, SQRT, ROUND)
    ii) Perform data import/export operations for different file formats.

    You might also like