The ________ command produces multiple named ranges at one time from the headings in rows,columns,or both from the data set.
A) Create New Names
B) Define Names
C) Create from Selection
D) Alt + Shift + F11

Question

Quizplus · Accepted Answer

The "Create from Selection" command allows you to quickly create named ranges based on the headings in your dataset. It can create named ranges from rows, columns, or both, and is the most efficient way to assign names to a large number of cells at once. The other options listed are not capable of creating multiple named ranges at once from headings in the dataset.

The ________ Command Produces Multiple Named Ranges at One Time