Terms to Remember

1. Terms to Remember Active cell Is the cell in which you are currently working Cell Is the intersection of a row and a column Cell address Is used to identify a cell Clipboard Is used to temporarily store data Column Is a vertical group of cells in a worksheet

2. Terms to Remember (Contd..) Formula bar Is used to display the contents of the active cell Label Is the text that identifies information in a worksheet Row Is a horizontal group of cells in a worksheet Spreadsheet Is a program like Excel, used to store, calculate and manipulate data Value Is the data in a worksheet

3. Terms to Remember (Contd..) Workbook Is a file created in Excel Worksheet Is stored in a workbook Alignment Is the manner in which worksheet data is positioned in a cell with respect to the cell edges AutoFormat Is a built-in set of formats, such as alignment, font, borders and shading that you can apply to your worksheet data in a single step

4. Terms to Remember (Contd..) Borders Are used to demarcate cells Formatting Refers to changing the style or appearance of data in a worksheet

5. Did You Know? Excel Is also widely used in businesses Is used to create budgets and invoices and to keep track of income and update statistics Is used to perform tasks from preparing a simple invoice to creating elaborate 3D charts Is used to perform what if analysis to forecast future trends in businesses Is used in schools by administrative staff to maintain the accounting data

6. Guided Practice 10.1 1. Start Excel. 2. Create a new workbook. 3. Add the label Term End Mark List. 4. Enter the names, marks and sections of the students for the subjects Maths and Science. 5. Save the workbook as Term End Results in your folder.

7. Guided Practice 10.1 (Contd..) 6. Create a new folder My Excel Files in drive D. Save a copy of the workbook in the folder. 7. Close all files and exit Excel.

8. Self Practice 10.2 1. Start Excel. Create a worksheet to record the status of the submission of holiday homework by students in your class. Make provisions to note late submissions. 3. Save the workbook as Student Assignment Details in your folder.

9. Self Practice 10.2 (Contd..) Create a worksheet to record the timetable of your class. Add the label TIMETABLE FOR CLASS ___. Save the workbook as Timetable in your folder. Build a lesson plan for the subject you teach in the school. Save the workbook as LessonPlan in your folder. Close all files and exit Excel.

10. Guided Practice 10.3 Start Excel Open the Term End Results workbook from your folder. Add a new column at the beginning and type the label Serial Number.

11. Guided Practice 10.3 (Contd..) Create a number series below the label Serial Number label by using the AutoFill feature. Resize the rows and columns to fit the data in the cells. Insert a page break after the first 16 entries. Save and close the workbook.

12. Guided Practice 10.3 (Contd..) Create a new workbook and create the following series by using the AutoFill feature. a. The series of months The series of weekdays A series of dates from March 1 to April 15. A series that contains only the number 7. A series that contain odd numbers from 51 to 89. Save the workbook and close it. Exit Excel.

13. Self Practice 10.4 1. Start Excel. Open the file Student Assignment Details. 2. In the Timetable worksheet, add a new column at the beginning and type the label Serial Number . Resize the rows and columns to fit the data in the cells. 4. Create a series to enter the names of the months. 5. Add a page break after the first 15 entries. 6. Save and close the file. Exit Excel.

14. Check Your Understanding 10.5 When you double-click a cell, the insertion point appears within the cell. What does this indicate? Suppose you enter Monday in cell B1 and drag the fill handle to B10. What values are filled in cells B2 to B10? Can you create a series of values in descending order? How?

15. Guided Practice 10.6 1. Start Excel. 2. Open the Term End Results workbook in your folder. 3. Centre the heading across the worksheet. 4. Change the heading to font size 20 and italicise it. 5. Change the font of the heading to Century Schoolbook.

16. Guided Practice 10.6 (Contd..) Change the font colour of the heading to Dark Red. Change the number of decimal places to 1 in all the cells with the marks. Insert the current date in the worksheet. Preview the worksheet. Save and close the workbook. Exit Excel.

17. Guided Practice 10.7 1. Start Excel and open the Term End Results workbook in your folder. Add a border to the worksheet. Select the cells that have the student names and shade them with a colour of your choice. Save and close the workbook. Exit Excel.

18. Self Practice 10.8 Start Excel and open the Timetable workbook you created in the previous chapter. Apply the font, font size, font style and font colour of your choice to the contents of the worksheet. Right-align the days of the week. Insert the current date in the worksheet. Add borders and shading of your choice to the cells. Save and close the workbook. Exit Excel.

19. Check Your Understanding 10.9 The data entered into a column does not always fit within the column. In this case, you can resize the columns so that the contents fit or merge the cells of the column with the cells in the adjacent rows so that the contents appear in a single cell. Which method would you prefer to use and why?

20. Check Your Understanding 10.9 (Contd..) You have entered the value 23.7896 in a cell. You then decide you want to restrict the number of decimal places to two. How will you do this? The number you enter in a cell is right aligned. Can it be centred? How would you do this? Excel provides an alignment option that is not available in Word. Which is it? What are the various ways in which you can draw borders around cells and ranges?

21. Guided Practice 10.10 Start Excel and open the Term End Results workbook in your folder. Move the details of the sixth student between the tenth and eleventh student detail rows. Renumber the Serial No. column accordingly. Preview the worksheet. Save and close the workbook. Exit Excel.

22. Guided Practice 10.11 Start Excel and open the Term End Results workbook in your folder. Copy the worksheet you have created to sheet 3 of the same workbook. Change the name of the worksheet tab to Term Results. Save and close the workbook. Exit Excel.

23. Self Practice 10.12 Start Excel and open the Timetable workbook in your folder. Copy the timetable to sheet 3 of the same workbook. Move the last period of the timetable to be between the second and third periods. Re-number the periods accordingly. Change the name of the worksheet tab to Timetable. Save and close the workbook. Exit Excel.

24. Check Your Understanding 10.13 How many times can you paste the content you have copied onto the clipboard? What are the different ways in which you can rename a worksheet? What is the use of Create a Copy check box in the Move or Copy dialog box?

25. Test Your Knowledge 1. You have typed the midterm test marks of all your students in a worksheet. For students who did not attend the test, you have typed a hyphen. But the alignment of the marks and the hyphen does not match. Which of the following alignments could be used to ensure that the alignment of the marks and the hyphens are the same throughout the column? Right-align the numbers Right-align the hyphens Left-align the hyphens

26. Test Your Knowledge (Contd..) 2. Vivek has created a timetable for his examination in a worksheet. He wants to move some of the values in column A to columns D and F. He cuts the values in column A and pastes it in column D. However, when he tries to paste the contents in column F, he is not able to do so. What could be the reason . a. The cells in column F already contained some values. b. The cut values can be pasted only once. c. The cells in column F were formatted.

27. Test Your Knowledge (Contd..) Rohan, a government school teacher, has prepared the mark list of his class students. He takes a print out of the worksheet. However, he finds that the cell boundaries are not visible in the print out. What should he do to print the mark list along with the cell boundaries.

28. Test Your Knowledge (Contd..) a. It is not possible in Excel. Instead, he should create a Word table with borders. b. He should add a background colour to the cell boundaries. c. He should select the cells and add borders to them.

29. Test Your Knowledge (Contd..) Sheela wants to copy and paste a large range of cell contents from one sheet to another. She copies the cells contents. Before pasting it, she has to select the destination cell range. Which of the following methods is the most efficient way of doing so?

30. Test Your Knowledge (Contd..) Select the first cell of the range to which the data is to be copied. Select an exact range that matches the cell range to be copied. Select the entire worksheet to which the data is to be copied.

31. Test Your Knowledge (Contd..) 5. Vinod has entered the date in mm/dd/yy format. He wants to format the date in dd/mm/yyyy format. The steps to perform this are given in the following slide in a jumbled order. Identify the correct sequence of steps.

32. Test Your Knowledge (Contd..) On the Format menu, click Cells. Click the cell or range of cells containing date values. Click the Number tab. Under Category, click Date. Under Type, click the dd/mm/yyyy date format, and then click OK.