Page 75 - TP_Plus_v4_Class4
P. 75

Scan the QR Code and watch the video.






                                                                                                        21 st
                          A Better Me!                                                                Century   #Responsibility
                                                                                                       Skills
                            Anaya is making a list of marks of her classmates and their total percentage after her teacher
                          asked her to do so. After completing it, she shared the Excel with her best friend without
                          telling the teacher. Is this act of her ethically correct? Write your views.



                                                                                   21 st
                          DIY In The Lab                                         Century   #Technology Literacy
                                                                                      #Information Literacy
                                                                                   Skills
                 To
                 Subject   Software Skills

                   Start Excel on the computer and click on "Blank Workbook" to create a new workbook:

                   1.   Fill in the serial numbers in column A. In column C, type the list of months. In column E, type
                      the list of days.
                   2.  Now using the Autofill feature, complete the list in columns A and C.






















                   3.   Select the cell that needs to be auto-filled. Click on the Home tab. Click on the Fill button in the
                      Editing group and select the Series option to Autofill the list of days in column E.

                   4.   Select columns B and D. Click on the Home tab and select Delete Sheet Column from the
                      Delete drop down menu to delete the columns B and D.







                 For The Teacher
                    Take the students for a quick run through of all the features taught in the chapter.
                    Discuss the difference between labels and values.
                    Demonstrate all the operations given in the chapter.



                                                                                    #Editing Cell Contents in Excel 2019  73
   70   71   72   73   74   75   76   77   78   79   80