Page 74 - TP_Pluse_V2.2_Class_5
P. 74

b.  What is a range? How can you select a range of cells using the mouse?
                        ___________________________________________________________________________

                        ___________________________________________________________________________

                     c.  Write steps to copying the data.

                        ___________________________________________________________________________
                        ___________________________________________________________________________

                     d.  What is the purpose Auto Fill feature? Write the steps to use this feature.

                        ___________________________________________________________________________
                        ___________________________________________________________________________

                     e.  Write down the steps to insert time in a cell.

                        ___________________________________________________________________________

                        ___________________________________________________________________________

                  5.  Competency-based/Application-based questions.

                     a.   Raj has a list of his favourite books in Excel 2016. He wants to move the list
                        from one worksheet to another and copy the names of the authors to a
                        new column in the same worksheet. How can Raj move the list of books to
                        a different worksheet, and what steps should he follow to copy the authors'
                        names to a new column?

                     b.   Emma wants to quickly fill a column with the names of the months of the year in Excel
                        2016. She has already typed "Jan" into the first cell. How can Emma use the Auto Fill
                        feature to complete the column with the names of the remaining months, and what
                        should she do after entering "Jan" in the first cell?




                  teCh Zone



                                                                                                    21 st
                                                                                                  Century   #Critical Thinking
                    Let's soLve                                                                     Skills
                      1.   Consider the giving spreadsheet and
                         answer the following questions:

                         a.  Your teacher has asked to insert a new
                            column and type the time at which each
                            student came to school. List the steps to
                            do so.
                         b.  You have to change the ‘Aryan’ to name
                            ‘Bharat’. How will you do that?


                  72    Plus (Ver. 2.2)-V
   69   70   71   72   73   74   75   76   77   78   79