Page 35 - Plus V4 with Adobe class 6
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 change this?
                       b.   Anaya has prepared mark sheet for her class. She realised that she has 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. Now, follow these instructions:

              a.  Insert a row after fifth 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