USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Joshua created a budget workbook that contains the formula =(Summary!B3). ‘Summary’ is an example of a/an:
|
|
named range.
|
|
|
external reference.
|
|
|
names manager.
|
|
|
scope
|
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: -$B$17 is a relative reference and B17 is an absolute reference. 49. To enter an absolute reference, the dollar sign ($) can be typed or the insertion point can be placed in or to the right of the cell reference to be changed to absolute and the F4 key pressed.
There is 1 question to complete.