Auto sum methods in MS Excel

AUTO SUM METHOD
Since, we add numbers more than any other operationin spreadsheets, Excel spreadsheet has an additional feature - Auto Sum. Move to cell C9 again and press the delete key to erase your last formula. Now look at  the upper area of the screen, just below the menu bar, for a ∑ (summation) symbol button. Point to it and click with the left mouse button. It is added automatically. Observe that thecells you would logically desire to add, have a marquee around them and that the SUM function is displayed in cell C9. You will need to confirm that this is the correct formula.

Formula methods in MS Excel

ADDING NUMBERS
There are several ways for learning how to add numbers. Each method has its advantages and disadvantages. 
To commence,, move the cursor to cell C9 and click on it.  Always move the cursor to the cell where you want the answer to be located. 
TYPE-IN METHOD
We want to add the three numbers in cells C6, C7 and C8. To use this method, type (using the keys on the keyboard) the following in cell C9: = C6 + C7 + C8 
The spreadsheet should look like the image above asyou are typing in this equation. Now press the Enter key. Then, click on cell C9 again. The total of these cells will now appear in C9. 
When you have completed typing your equation, you will see this formula in the area below the menu bar. 
Change the number in cell C6 to 500 (and press Enter). You can see how the total is automatically recalculated. Whenever a number is entered in a cell, the entire spreadsheet will mechanically recalculate. 
SUBTRACTION, MULTIPLICATION AND DIVISION

Formulae Function MS Excel

Formulae Function 
From the example given below, you will learn how toenter and copy formulas. In this example, you have to calculate the total price of each quantity and then the final total value of all quantities. To calculate the total price of  the pens, you enter the quantity in cell address B2 and price in cell address C2. Multiply these values and place the result in cell address D2. Repeat the procedure for the items Pencil and Pen Box. The total of all the  three items will be placed in cell address D5. 
Formula can also be entered by using the cell address. In the above example, the value is to be calculated by using the formula Quantity * Rate. To calculate the value of first item, pen, in the cell D2, type = B2 * C2 or +B2*C2 (Cell names can be indicated by small letters or capital letters). When typed, it will appear in cell D2.

Closing the Excel workbook

A. To close the Excel workbook: 
•  Select the File option on the Menu bar and click the left button of the mouse. A pull-down menu is displayed immediately. 
•  Select the Close option and click the left mouse button. A message box is displayed immediately, asking you whether you want to save this sheet with three options ‘Yes’,  ‘No’ and ‘Cancel’. Select 'Yes' to save the workbook. You will be asked for a file name. Give a name to the file and click 'Save'. If you donot wish to save the workbook, select  'No' and click the left mouse button. This will close the sheet without saving it. Click 'Cancel' to cancel the operation. 
B. To close the Excel program
•  Move the mouse pointer to the 'Close' button at theright hand corner of the Title bar. 
•  Click the left mouse button. 

Components of an excel workbook

COMPONENTS OF AN EXCEL WORKBOOK
Row Number
The horizontal group of cells is termed as a row. Each row is assigned a number. The row numbers appear on the left side of the workbook
Column Number
The vertical group of cells is termed as a column.Each column is assigned a number. The column number appears below the Formula Bar in the workbook.
Column Headings
The name given to each column is termed as column  heading. These appear just below the Formula Bar.
Vertical Scroll Bar
The vertical scroll bar consists of two buttons UpArrow Scroll button and the Down Arrow Scroll button. Clicking on any of these buttons allows you to see those rows of a sheet, which are not visible on thescreen.

Microsoft Excel Notes

TO START MICROSOFT EXCEL
1.  Move the mouse pointer over the Start button present on the extreme left of the task bar and then click the left mouse button. A push-upmenu appears.
2.  Place the mouse pointer over the Program option inside the push up menu. A submenu is displayed.
3.  Move the mouse pointer over the Microsoft Excel option and click the left mouse button. A blank workbook is instantly displayed on the screen. Data can be entered in the file 
Book1 and calculations can be made on entered data.
When MS-Excel is loaded, the Excel window will appear on the screen. The Excel window is shown below.

Introduction to Spreadsheets

Introduction to Spreadsheets 
Spreadsheet is a computer application that simulates a paper worksheet. It displays  multiple cells that together formulate a grid consisting of rows and columns, each cell  containing either alphanumeric text or numeric values. A spreadsheet cell may alternatively contain a formula that defines how the contents of  that cell are to be calculated from the contents of any other cell (or combination of cells) each time any cell is updated. 
Spreadsheets are frequently used for financial information as they robotically enable the re-calculation of the total sheet, after a modification to

Text Processing Software

Text Processing Software 
The text processing Software or Word Processing is  one of the most significant  Application packages of Windows. The Word processing software is used for creating  documents. Drafts, letters, reports, essays, write-ups etc. can be created by means of word processing software. Earlier, Word Star was being used extensively for this purpose.  However, the most commonplace word processing package used today is Microsoft Word. 
Microsoft Word is Microsoft's word processing software. It was first released in 1983 bearing the name Multi-Tool Word for Xenix systems.Later, Versions for several other platforms including IBM PCs running DOS (1983), theApple Macintosh (1984), SCO UNIX, OS/2 and Microsoft Windows (1989) were written. It is a component of the Microsoft Office  system; however, it is also sold as a standalone product and included in Microsoft Works Suite. 

Different versions of windows

The different versions of Windows are discussed below: 
WINDOWS 1.0 
Microsoft released the first version of Windows wayback in 1985. It marked a major breakthrough as it allowed users to switch from character based (CUI)/non-graphical MS-DOS to the GUI based operating system. The product  incorporated a set of desktop applications, including the MS-DOS file management  program and value additions such as a calendar, card file, notepad, calculator, clock andtelecommunications programs. It allowed users to work with multiple applications at the same time (multitasking). 
WINDOWS 3.0 
Microsoft released this version of Windows in 1990.Some of its main features were: 
•  32 bit operating system with support for advanced graphics 

Features of windows

FEATURES OF WINDOWS 
Microsoft Windowsis a series of software operating systems and graphical user  interfaces developed by Microsoft. Some of its important features are listed below:
1. Faster Operating System:Windows include tools that increase the speed of the computer. Windows includes a set of programs designed to optimize the efficiency of computer, especially when used together.
2. Improved Reliability:Windows improves computer reliability by introducing new wizards, utilities and resources that lend a hand in helping your system operate  effortlessly.