𝗠𝗦-𝗘𝗫𝗖𝗘𝗟. Class 7 ICT Chapter-4 PPT

This is All about MS-Excel

1. MS-EXECL. Chapter – 4. Subject – ICT. Prepared by Sai Krishna Pradhan. MS-EXECL

2. Ms-Excel - Ms – excel is a spreadsheet program that is used to record & analyze numerical data. Ms – excel comes in handy when we want to record, analyze & store such numeric data. The point where a column & a row meet is called a cell. The address of a cell is given by the letter representing the column & the number representing a row.

3. Opening of workbook in Ms-Excel – There are different methods of opening work book in Ms-excel – Click on the file tab. Click new option. Under available templates, double-click on the blank document. ★ To quickly create a new blank work book (keyboard shortcut)- CTRL+N.

4. Opening of a new workbook on an existing workbook – Click on the file tab. Click on new option. Under templates , click new from existing. In the new from existing workbook dialog box, browse to the drive, folder, or internet location that contains the workbook that you want to open. Click on the workbook, & then click on create new

5. Ms-excel – 👍Advantages – Excel has the ability to organize large amount. It is easy to enter and format the data. It has the ability to create the graphical representation of your data. 👎 Disadvantages – The amount of time it takes to enter the data can be inefficient. It can lead to boredom which leads to potentially costly inattentiveness. Entering the data into excel manually can take a very long time.

6. The cell, row and column – A cell is the insertion between a row & a column on a spreadsheet that starts with cell A1 . The cell address, cell name, or cell pointer “D8” (column D, row 8) is the selected cell & the location of what is being modified. Ms-excel is in tabular format consisting of rows & columns . Row runs horizontally while column runs vertically . Each row is identified by row number, which runs vertically at the left side of the sheet. Each column is identified by column header, which runs horizontally at the top of the sheet.

7. The cell address – A cell is the insertion between a row & a column on a spreadsheet that starts with cell A1. The cell address, cell name, or cell pointer “D8” (column D, row 8) is the selected cell & the location of what is being modified.

8. Worksheet – An excel worksheet is a single spreadsheet that contains cells organized by rows & columns. A worksheet begins with row number one & column A. Each cell can contain a number, text or formula . A cell can also reference another cell in the same worksheet , the same workbook or a different workbook .

9. Insertion of new worksheet – Three new blank sheets always open when you start Ms-excel. Steps to insertion of new worksheet – Right click the sheet name & select insert option. Now you’ll see the insert dialog with select worksheet option as selected from the general tab. Click the OK button. 4. Now your blank sheet is ready you can type text.

10. Steps image –

11. Steps to renaming of sheet – Double click the sheet tab or right-click the sheet tab & then click rename on its shortcut menu. The current name on the sheet tab appears selected. Replace the current name on the sheet tab by typing the new sheet name. Press enter.

12. Steps to deleting a sheet – Right click the sheet name and select the delete option. Press the delete button.
Now your worksheet will get deleted.

13. Steps image –

14. Sheet will get deleted if it is empty, otherwise you’ll see a confirmation message.

15. Steps to Moving or copying of a sheet – Select home > format > move or copy sheet. Or, you can also right-click a selected sheet tab, & then click move or copy. In the move or copy dialog box, click the workbook to which you want to move or copy the selected sheets.

16. Steps image –

17. Entering data to the cell – In Ms-excel, there are 1048576*16384 cells. Ms-excel cell can have text, numeric value or formulas. An Ms-excel cell can have maximum of 32000 characters. For inserting data in Ms-excel, just activate the cell type text or number & press enter or navigation keys.

18. Inserting formula – For inserting formula in Ms-excel go to the formula bar, enter the formula & then press enter or navigation key. ★ The shortcut key to create a blank sheet – Shift+F11.

19. Formatting cells – When we format cells in excel, we change the appearance of a number without changing the number itself. We can apply a number format ( 0.8,$0.80,80%, etc. ) or other formatting ( alignment, font, border, etc. )1. Enter the value 0.8 into cell B2. Adding font styles, design, and colour to the text & cell – Setting Font- You can assigns any of the fonts this is installed for your printer to cells in a worksheet. Setting font from home – You can set the font of the selected text from Home >> Font group >> select the font. Setting font from format cell dialogue – Right-click on the cell >> format cells >> font tab. Press ctrl + 1 or shift + control + F.

20. Text decoration – Bold - It makes the text in bold by choosing Home >> font group >> click B or press ctrl + B. Italic – It makes the text italic by choosing Home >> font group >> click I or press ctrl + I. Underline – It makes the text as underlined by choosing Home >> font group >> click U or press ctrl + . Double underline – It makes the text highlighted as double underlined by choose Home >> font group >> click arrow near U >> select double underline.

21. Setting colours – Changing background colour – By default the background colour of the cell is white in Ms-excel. You can change it as per your need from Home tab >> font group >> background colour. Changing foreground colour – By default, the foreground or text colour is black in Ms-excel. You can change it as per your need from Home tab >> font group >> foreground colour. Also you can change the foreground colour by selecting the cell Right click >> format cells >> font tab >> colour.

22. Deletion of data from cells – To delete the actual cell selection rather than just clear the cell contents, follow these steps - Select the cells, rows, or columns you want to delete. Click the drop-down button attached to the delete button in the cells group of the home tab. Click delete cells on the drop-down menu.

23. Insertion of pictures - Open your spreadsheet in Excel 2010 . Select the cell into which you want to paste the picture . Click the insert tab at the top of the window. Click the picture button in the illustrations selection of the ribbon at the top of the window. Browse to the picture that you want to add your spreadsheet, select it, then click the insert button. (Optional) – Manually resize the cell so that the picture is contained within it. You can do this by clicking the right border of the column letter at the top of the spreadsheet, then dragging it so that the cell is wide enough for the image. You can then repeat this with the row number.

24. Steps to Use of function – Open an existing excel workbook. If you want, you can use this example. Create a function that contains more than one argument. Use auto sum to insert a function. Insert a function from the functions library. Use the insert function command to search & explore functions. SUM AVERAGE AUTOSUM COUNT.

25. Creating of chart – A chart is a tool you can use in excel to communicate data graphically. Steps to create a chart – Select the source data for which you want create the chart. Click on insert tab. Select the required chart type.

26. THANK YOU