Introduction to MS Excel
MS Excel is the spreadsheet program created by Microsoft. MS Excel has various components to make calculating, analysing and displaying data more efficient. The Excel window that appears on the screen is called a workbook. This workbook has a number of worksheets. A worksheet consists of 65,536 rows and 256 columns. The rows are numbered as 1, 2, and so on along the left border of the worksheet and columns are lettered as A to Z, AA through AZ and up to IV. A cell is the intersection of a row and a column. The formula bar is used to type any data or formulas in the cell. Status bar shows the status of a particular program. Toolbar provide commands to perform operations on data entered in a worksheet.
There are three types of data - numbers, text and formulae. Numbers are numeric entries that are used in calculations. Text is any combination of numbers, space and non-numeric characters. Formulae are equations that perform calculations on values in our worksheet. To enter the data, select the cell to enter data and double click in the active cell. Now, start typing the data in the cell. The entered data would be displayed in the formula bar at the same time. MS Excel allows the user to modify or change the existing content of the cell. AutoSum feature of Excel also provides a quicker and easier way of calculating.