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 keyboardThere are three sections to the reference using formula.a. Path and file name
b. Sheet name
c. Cell
2. Creating The Reference With The MouseBoth spreadsheets must be open in order to construct the reference with the mouse. Choose the cell where the formula should be entered.
OpenOfficeOrgCBSESkillEducation