Header Ads Widget

Ticker

6/recent/ticker-posts

Editing and formatting Worksheets in Excel 2016 (Note1)

What is Ms Excel    = A Spreadsheet Software
Application Name    = excel
Extension Name    = .xlsx
Default File Name    = Book1
Complete File is called    = Book
Every Pages  is called   = Worksheet

why is it used ?
Excel spreadsheet software is used to store and organize data for various format. 

Advantages or work of Spreadsheet Software:

    * It is easier to maintain data on electronic format.
    * Error in calculation are greatly minimized.
    * An automatic recalculation facility is available if rule changes.

How to open Ms-Excel ?

    Start => type "Excel" => Enter

Comoponants of a Worksheet :

    * Cell
    * Row
    * Column
    * Cell Pointer
    * Row Header
    * Column Header

Editing a worksheet

Changing the existing data or adding new data or deleting data is called editing. 

Entering Data Excel

1) Simply move the cell pointer to the cell and type your text or by double click the cell or enter text in formula bar.

2) Edit the content and press ENTER key.

Changing Data :

    Move the cell pointer to the cell

        * Click on formula bar and change the data
        * Double click on the cell and change
        * Press F2 and change the data

Removing Data :

    Move the cell pointer to the cell
    Press Delete key.

Saving a workbook : [Ctrl+S]


    File => Save => Specify the file name => Save

Closing a workbook : [Ctrl+W]

    File => Close

    Or    Click on the "x" mark on the top right corner "down one"

Opening a workbook : [Ctrl+O]

    File => Open => Choose the file => Open

Navigating between worksheet :

    Click on the sheet tab on the down of worksheet. top of status bar.