Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 83 - 2620_Birla Open Mind C-5
P. 83

    21 st
                              A Better Me!                                                     Century   #Leadership & 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  81

| 78 79 80 81 82 83 84 85 86 87 88 |