What is Excel?Microsoft Excelis spreadsheet software widely used to perform mathematical calculations. Thedata is spread in a tabular form consisting of rows and columns.It providesbuilt in features and tools such as formulas, functions and data analysis toolsthat make it easier to work with large amount of data.Features of Excel1. FormattingFeatures: Improve the appearance of data.2. Autocalculation: The data is automatically recalculated in the whole worksheet ifany change is made in a single cell.
3. Functionsand Formulas: Functions are the built in formulas used for calculatingpercentage, interest, average etc, in MS Excel. Formulas are mainly used forperforming simple and complex calculation.4. Fastsearching and instant replacing of data.Uses of ExcelIt helps us to1.
Arrangedata in an organized way2. Typeless and get more3. Performcalculations4. Sortdata for better analysis5. Comparetwo workbooks side by side.Starting MS Excel To start MS Excel, perform the followingsteps:Click on Start Button àType Excel àMicrosoft Office Excel willappear on the screen à Left click on Microsoft Office ExcelWorkbook and WorksheetWorkbook – Whenyou start Excel, you open a file which is called a Workbook.
It is like anotebook that has number of pages in it. Each new workbook comes with threeworksheets known as sheet tabs. They can be seen at the bottom left of theworkbook window. These are named as Sheet1, Sheet2, and Sheet3.Worksheet – Datais entered into the worksheet. You can add additional worksheets, if you needmore than three. Data can be viewed in a worksheet by clicking on its sheettab.
A worksheet is divided into rows and columns.Columns, Rows, Cell, Cell Reference, Cell pointerColumns – Eachcolumn has an alphabetical heading at the top. The first 26 columns have theletters from A through Z, then AA through AZ and carrying up to XFD. Eachworksheet contains 16,384 columns.
Rows – Each rowalso has a heading. Row heading are numbers, ranging from 1 to 1048576Cell – A cell isthe space which if formed by the intersection of one row and one column. Eachsmall rectangle in a spreadsheet is called a cell.Cell Reference –the heading of a column and a row combines to form the cell address, alsocalled the cell reference.Cell Pointer – Acell pointer is a highlighted cell boundary that indicates which cell is activeat the moment.Entering data in Excel You can enter three types of data in worksheetcells: number, text and formula.
1. Clickon the cell where you want to enter the data2. Typeyour data into the cell3. PressEnter key to move the pointer down by one cell. Press the Tab key to move tothe next adjoining cell towards right.
4. Clickon suppose cell B1 and type your data(School Name)5. Pressthe Enter key6.
Clickon suppose cell A3 and type the data.(Roll No)7. Presstab key and type the data (Name).8. Pressthe Right Arrow key and type the data (Grade). Activity: Create anexcel sheet as the mentioned below Formatting in MS ExcelCopy Paste optionCopyand paste option is used to duplicate the text.
We can copy text from onelocation to another location.Followthe steps to copy and paste the text1. Selectcell which is to be copied.2. Thecell will be highlighted with a dashed border.3. Clickon copy button in the clipboard group on the Home tab or press Ctrl + C4.
Selecta cell where you want to paste the copied text.5. Clickon paste button in the clip board group on the Home tab or press Ctrl + V6.
Clickon ESC key to remove the dashed border of the selected cell.Cut Paste OptionCutand paste option is used to remove the text from one location and add it toanother location.Followthe steps to cut and paste the text1.
Selectcell which is to be cut.2. Thecell will be highlighted with a dashed border.3. Clickon cut button in the clipboard group onthe Home tab or press Ctrl + X4. Selecta cell where you want to paste the text.
5. Clickon paste button in the clip board group on the Home tab or press Ctrl + V6. Clickon ESC key to remove the dashed border of the selected cell.Activity: Create aSheet as mentioned below and use cut paste and copy paste option Copy details of roll no 3 and paste the contentsafter roll no 5 as shown below. Cut the details of roll no 5 and paste aftercontents of roll no 3 as shown below.