Page 37 - 2620_Birla Open Mind C-6
P. 37

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?

                          A Better Me!


                          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  35
   32   33   34   35   36   37   38   39   40   41   42