Page 190 - IT 402 v2.0 class 10
P. 190

Sneak Peek




                To Create a Hyperlink in Microsoft Excel:

                1.  Click the cell to create a hyperlink.
                 .   lick on the  Insert  tab.  lick on the   yperlink  button in the   inks  command group.
                 .   nder   ink to  section  click   xisting File  or   eb  age .

                 .   ocate desired existing file or webpage.
                5.  In the   ext to display  box  type the text to be used to represent the hyperlink.
                 .   lick on  O   button.







                                          Lab Assignment ‘n Activity                           E x p e r ie ntial   L e ar ning




             Complete the following activities and tick on the circle.

                 et us consider admin of a school wants to link the   onsolidated  otal Marks  of each
                student  calculated in previous assignment  in a new workbook created by him.  y using
                  yperlink  method  link the desired data of student.
                 ink your school website in cell  5.






            SHARING A DOCUMENT

        In  OpenO ce   riter   Impress  and   raw   only  one  user  can  open  a  document  for  editing.   owever
        sometimes it is necessary to have multiple people working on a file at the same time.  his can be to either
        speed  up  data  entry  or  simply  make  things  easier  for  collaboration  purposes.   ut  in   alc   many  users
        can open the same worksheet workbook for entering and editing the data at the same time.  his feature
        enables to share the spreadsheet file with several users and edit the same workbook without keeping track
        of multiple versions.

         ach user who wants to collaborate should ensure to enter their Names:

        Step 1:   lick on the   ools  menu and then select  Options .

        Step 2:  Select   ser  ata
        Step 3:   ype the desired details

        Step 4:   lick on  O   button.










         188       Touchpad Information Technology-X
   185   186   187   188   189   190   191   192   193   194   195