Smart MS Excel

         We live in the Computer Age .Most of our day to day activities are being influenced by the use of computers .While in areas like science and technology improvements con not be achieved with out computers , It has become necessary for each and every one of us to have a basic Knowledge of computers What is a computer in simple words , a computer is an electronic device which processes information based upon the instructions provided ,and generates the desired output .Like any other system, a computer system also requires an input which is processed to get the desired output. In the case of computers , two kinds of inputs are required .One the basic or raw data, and two , a set of instructions containing the methodology to process this data .This set of instructions is called program or software in computers peak. Some people erroneously believe that computers can only work on arithmetic operations, or a good background in mathematics is a pre requisite f...

  Page set -up within worksheet Formatting and Printing worksheet :- As with other Windows programs, Excel also provides you with the feature of WYSIWYG (What You see is what get).Therefore it is always better to start with the page layout which you want as a printer copy also .for this :- 1. Open the File menu by clicking on the File . 2. Click on the Page Set -up. The following dialogue box is displayed . The Page option allows you to set the paper size , orientation of the data ,scaling of the area etc. Excel inserts automatic page -breaks also . The Margins tab, when clicked , displays the displays the dialogue box. You can set the top ,bottom ,left and right margins of the page . These are the distances in inches from the edge of page . This also allows you to see the preview of the data when it will be printed . Header / Footer tab gives you option to set the header ( which will be displayed on top of every page ) and the footer ( which will be displayed at the bottom of ev...

  Summary :- In this session , you learned : What is an Excel workbook and worksheet ,and how to work in it . Data is entered in the cells and can be edited , if required . Names can be given to a single cell or a range of cells. You can move in the worksheet either with keyboard ,mouse or menu. Data which has been entered can be searched and replaced . The contents of the cell can be copied and moved anywhere in workbook. The worksheet ,which has been created, can be saved and you can also protect it from unauthorized users by giving passwords. Commands to leave the Excel workplace and come out to Windows shell.

Exit Excel within workbook  :- When you work is finished and it has been saved properly  to close the file and exit MS- Excel , Choose File -> Close command  Choose File -> Exit , If you have not saved your work before closing the file , the dialogue box to save the worksheet is displayed . Cheek Your Progress :- 1.  What are the different features of Excel that provide the ease of work ? 2. Differentiate between a Workbook and a worksheet .  3. What are the different type of data can be entered in worksheet cells? 4. What is fill -handle and how is it useful? 5.  Explain the three ways of referencing the cells. 6.  What are the different ways to name or copy cell contents? 7.  How the access of Workbook can be restricted from other users?

Save and Protect Workbook Within Excel :-  After you finish up your work with the workbook you will required it to be saved so that it can be opened later to resume the work in it. To give the name and save the workbook :- Choose File -> Save As command . To Simply save the workbook :- Choose File -Save command . or  Click on the Save File Tool button To Protect the Workbook :- Your data can be very confidential which has to be saved from Unauthorized people . Click on Options button from the File -> Save   As dialogue box. You can restrict the access of that workbook from other users in 3 different ways: Protection Password  1. Type the Password. which will required to open the workbook .The Password can be up to 15 characters long ,can include alphabets (Upper case or Lower case ), numbers and special characters. It is case sensitive also . 2.You will be asked to re-enter the same password . 3.Click on ok . Write Reservation Password:- This password will be r...

Inserting or Deleting Rows and Columns within Excel Worksheet :- Many a times you may require to add a row of data or a column of data which you forgot to enter earlier . Excel provides you the facility to insert rows or columns into the existing worksheet very easily . One thing , which has to be taken care of , is that inserting a row of data will shift the rest of the rows down and cause the last row of the worksheet to be removed . Same is the case while we insert a column in the worksheet , The rest of the columns shift right . This happens because the total number of rows and columns remain the same . If there is any data in the last row or column of the worksheet that will be lost . To insert cells , rows or columns . 1. Select the cell (s) where you want to insert the cell (s),row or column. 2. From the Insert menu.          1. Choose Entire Column to insert the column.         2. Choose Entire Row to Insert the row . Choose Shift ...

Rearrange Cell Contents Within MS Excel :-  Rearrange cell contents includes moving or copying or clearing cell contents . This also involves inserting or deleting rows or columns . This can be done either by cut and paste method or drag and drop method .   Move or Copy Cell Contents . Drag and Drop method  1. Select the range of cells which are to be moved . 2. Point to the border or range . The mouse pointer will change its shape to an arrow. 3. To move , press the left mouse button, drag it to the new location and release the mouse button . 4. To copy , Press the cell key while dragging the contents. Short -end menu.    1. Press the right mouse button while dragging and dropping cell contents . 2. From the short  -end menu, choose Move to move the contents copy to copy the contents. Cut and Paste Method  1. Select the cell range . 2. Select Edit - > Cut ( to move the range of cells )                 ...