Page 35 - TP_Plus_v4_Class6
P. 35

2.  Competency-based/Application-based questions:
                            a.   Sonia is preparing project details in a spreadsheet. Some text in a cell is too long and gets hidden
                              when she types text in the adjacent cell on the right. How can she overcome this problem?

                            b.   Anaya has prepared mark sheet for her class. She realised that she had forgotten to enter marks
                              of one subject. How can she create space in the marksheet to enter those marks?




                              Scan the QR Code and attempt the quiz.





                          A Better Me!                                                              Century   #Responsibility
                                                                                                      21 st
                                                                                                     Skills  #Accountability
                          Don't copy someone's data without his/her permission. It is an illegal activity.





                                                                                   21 st
                         DIY In The Lab                                          Century   #Productivity & Accountability
                                                                                      #Technology Literacy
                                                                                  Skills
                 To
                 Subject   Creating a Marksheet

                   Create a marksheet for ten students and follow the given instructions:
                   a.  Insert a row after sixth row.

                   b.  Insert a column to the right of third column.
                   c.  Using AutoFill feature, fill the Roll numbers 1 to 11 for the students.






























                 For The Teacher

                    Do a detailed walk-through with students on all the topics presented in the chapter.
                    Provide some tasks which make use of the functional facilities discussed in the chapter.




                                                                                                #More on Excel 2019  33
   30   31   32   33   34   35   36   37   38   39   40