Q. What are the two ways of referencing cells in other worksheets?
Answer – In spreadsheet there is two different method to referencing cells in other sheet –
1. Entering the formula directly using the keyboard
There are three sections to the reference using formula.
a. Path and file name
b. Sheet name
c. Cell
2. Creating The Reference With The Mouse
Both spreadsheets must be open in order to construct the reference with the mouse. Choose the cell where the formula should be entered.
OpenOfficeOrg
CBSESkillEducation
