FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
A
calling the sheet
B
name reference
C
sheet name
D
worksheet reference
Explanation: 

Detailed explanation-1: -External reference in Excel is a reference to a cell or a range of cells outside the current worksheet. The main benefit of using an Excel external reference is that whenever the referenced cell(s) in another worksheet changes, the value returned by the external cell reference is automatically updated.

Detailed explanation-2: -References to cells or cell ranges in other worksheets are called external references.

Detailed explanation-3: -external reference. What term is used when referencing cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?

There is 1 question to complete.