DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
([ ])
|
|
|
( )
|
|
|
(” “)
|
|
|
( !)
|
Detailed explanation-1: -How to reference another sheet in Excel. To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address. For example, to refer to cell A1 in Sheet2, you type Sheet2!A1.
Detailed explanation-2: -Select the cell or cells where you want to create the external reference. Type = (equal sign). Switch to the source workbook, and then click the worksheet that contains the cells that you want to link. Press F3, select the name that you want to link to and press Enter.
Detailed explanation-3: -Reference Another Workbook Type = and start building the reference. Select the workbook with the cell(s) you want to reference. Select the cell(s) you want to reference. Click or press Enter.