Thursday, September 25, 2008

What is Microsoft Excel?

Excel is used for calculation in tabular form. The main window is called worksheet in Excel. It is divided into a row and columns. The intresection of a row and colunm is called cell.Cells contain the data ,text,and formulas used in calculation. Row are labeled by numbers(1,2,3.....)and colunms are labeled with leters (A,B,C..,AA,AB,AC...).Cells are then labeled with both the colunm, letters and row number in that order. A cell is selection (highlighted) by clicking the cursor on it. a cell which is selected at a given time cell is called the active cell.there are some essential features of Ms Excel.Many Toolbars displaying shortcut buttons are available to make editing and formatting quicker and easier in MS Excel.Excel provides an Undo feature , which is used to remove the effect of last action. Action can be done again by using Redo.Header feature is used to automatically display text at the top of each page. Footer is text that appeares at the bottom of each page. Autofill is the Excel feature that allows you to automatically fill cell with a series of numbers, datas ect. the use of Styles in Excel allows to quickly format a document with a consistent and professional look.Paragraph and character styles can be designed , saved, changed & deleted. Excel allows you to find a particular value or piece of text by using Find command. After you have found the word, it can be replaced by executing Replace commanf. Spelling and Grammar feature in Excel help th euser correct any mistakes made when typing in a sheet. Your misspelled words are highlighted. Spelling errors are highlighted bby red underline and gremmar errors by green underline.AutoFormat is a feature that automaticcally changes text as you type. A Template is a performatted document that serves as a madel for other documents. AutoShape toolbar alows you to draw many different geometrical shapes, arrows, chart symbols, stars, and banners on the worksheet. Excel allows you to keep track of cell addresses and to easily enter formula for performing calculations.Microsoft Excel has many built-in-functions. The function name tells Excel what calculation you want to perform. You can apply lengthy calculations on worksheet easily by using these functions. Sorting is the process of arranging your data in a particular order. You can sort the data in your worksheets in ascending or descending order. Charts are representation of your data. Excel provides different types of charts. These charts can be formatted , resized or moved. You can display the required data ina worksheet by using this feature.