A defined name can be used outside its scope if it is ____, which means if its original scope is identified in its reference.
A) qualified
B) saved
C) archived
D) linked

Question

Quizplus · Accepted Answer

A defined name can be used outside its original scope if it is qualified, meaning its original scope is identified in its reference. This is done by specifying the name of the worksheet or workbook where the defined name is located, followed by an exclamation mark and then the name itself. For example, if the defined name "Sales" was created in a worksheet named "Quarter1", it can be used in a formula in a different worksheet by qualifying it as "Quarter1!Sales".

A Defined Name Can Be Used Outside Its Scope If