Page 260 - TP_IT_V1.0_C10_flipbpookl
P. 260

Step 9:  Click on OK button to use the selected database.




































              Note that the OK button is enabled only when both fields are filled in.




                      Tick ( ) if you know this.
                        The default name of the sheet can be changed by renaming a sheet with a new name.
                        The main advantage of using cell reference is that it can be used in formulas and functions.

                        A cell reference is the method used to refer to a cell or a range of cells in a spreadsheet.
                        Solver is a tool that helps you do backward calculation of the input to obtain the desired output.

                        Hyperlink means a content when clicked will open another linked file.




                      SHARING SPREADSHEET

              A file is sometimes required to be accessed by multiple users at the same time for editing. For this purpose, the
              file can be placed in the network or shared location so that it can be shared by several users and can be accessed
              simultaneously.

              Sharing a spreadsheet refers to the way of allowing multiple users to access and work together on the same document
              simultaneously.
              It saves the trouble of keeping track of multiple copies of the same spreadsheet. Sharing allows working in collaboration
              so that everyone can contribute, make changes and view it.

              The steps to make the spreadsheet shareable with the other users are as follows:
              Step 1:  Open the spreadsheet.

              Step 2:  Select on the Tools   Share Spreadsheet… option from the Menu bar.


                258   Trackpad Information Technology (Ver. 1.0)-X
   255   256   257   258   259   260   261   262   263   264   265