Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 46 - 2615_KEC
P. 46

    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:

                          ▶ 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.

                       44   Premium Edition-V

| 41 42 43 44 45 46 47 48 49 50 51 |