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

