Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 78 - 2612 Digimind C5
P. 78

    d.  Describe the purpose of the Name box.
                             _______________________________________________________________________________
                             _______________________________________________________________________________

                          e.  How can you add a new worksheet in a workbook?
                             _______________________________________________________________________________
                             _______________________________________________________________________________

                                                                                                   21 st
                      6.  Competency-based/Application-based questions.                         Century   #Technology Literacy
                                                                                                  Skills
                          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?

                                                                                                     21 st   #Technology Literacy
                            LAB ACTIVITY                                                           Century   #Information Literacy
                                                                                                    Skills

                          Visit your computer lab and perform the following actions:
                          ▶ Start MS Excel and click on Blank workbook.
                          ▶ Write the names of all your friends in Column A.
                          ▶ Now, write all of your friends’ birthdays in Column B.
                          ▶  Add another worksheet to this workbook by left-clicking on the ‘+’ sign at the bottom of the
                             screen.
                          ▶  Now, select and copy all the names of your friends from the first worksheet and paste them
                             into the second worksheet.
                          ▶ In the second worksheet, write the addresses of all your friends in Column B.
                          ▶ 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.

                       76   Premium Edition-V

| 73 74 75 76 77 78 79 80 81 82 83 |