Defined names with a global scope can be created for cells and ranges using the Name box in the Formula Bar, and using the ____ command in the Defined Names group on the FORMULAS tab.
A) Create from Formula
B) Create from Selection
C) Create from Cell
D) Create from Range

Question

Quizplus · Accepted Answer

The "Create from Selection" command in the Defined Names group on the FORMULAS tab is the best choice to create defined names with a global scope for cells and ranges, as it allows users to quickly name a range of cells based on the selected range. The other options are not relevant for creating defined names with a global scope.

Defined Names with a Global Scope Can Be Created for Cells