Page 89 - TGPT_V5.0_C5_Flipbook
P. 89

(ii)   You have to convert the names in lowercase. Which function will you use to convert the
                               range of names into lowercase?







                                                                                                        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.   Using the text function, convert the text string in columns C and D into uppercase.







                 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 2021  87
   84   85   86   87   88   89   90   91   92   93   94