Page 55 - KEC Khaitan C5 Flipbook
P. 55

4.  Think and answer.
                    a.   Your friend Rohan is using Excel 2021 to do some calculations and wants to see
                        the formula he has entered for a cell. Which part of the Excel window would you
                        suggest he look at to view or edit the formula he is using?
                        _______________________________________________________________________________
                        _______________________________________________________________________________

                    b.   Your friend Riya is working on an Excel workbook with several sheets, and she need to add
                        a new sheet for extra information. Which option should you suggest her to insert a new
                        worksheet into existing workbook?
                        _______________________________________________________________________________
                        _______________________________________________________________________________
                    c.   The class teacher has asked Samaira to create a worksheet displaying the time table of the
                        class. She has also asked her to save it with the name of her choice and further rename the
                        worksheet by specifying the name, "Time Table". Suggest her the method to rename the
                        worksheet.
                        _______________________________________________________________________________
                        _______________________________________________________________________________


                                                                                               21 st
                    LAB ACTIVITY                                                             Century   #Technology Literacy
                                                                                                  #Information Literacy
                                                                                              Skills
                     Visit your computer lab and perform the following actions:
                       (a)  Start MS Excel and click on Blank workbook.
                       (b)  Write the names of all your friends in Column A.
                       (c)  Now, write all of your friends’ birthdays in Column B.
                       (d)   Add another worksheet to this workbook by left-clicking on the ‘+’ sign at the bottom of
                            the screen.
                       (e)   Now, select and copy all the names of your friends from the first worksheet and paste
                            them into the second worksheet.
                       (f)  In the second worksheet, write the addresses of all your friends in Column B.
                       (g)  Save the workbook and exit Excel.




                          COding Zone      COding Zone     {}      =     COding Zone
                                {C ding z ne}
                                                                                         21 st
                                                                                            #Critical Thinking
                                                                                       Century
                                                                                        Skills
                                                                                                    COding Zone
                                                                          </>
                     Open Excel and use the Fill Color option present in the font group to fill colour in the
                     following cells:
                     I5, I6, I7, I8, I9, I10, I11, I12, I13, I14, I15, J13, J14, J15, K13, K14, K15, L13, L14, L15.
                     Identify the letter formed.



                   FOR THE TEACHER

                   1.   Demonstration of all the steps taught in the chapter to work in Excel would be helpful to aid the students
                     in following the instructions properly.
                   2.   Give students adequate practice time to get familiar with the different components of the Excel window.




                                                                                         Excel 2021—An Introduction  53
   50   51   52   53   54   55   56   57   58   59   60