Which of the following procedures must be used to create a named range for data in Excel?
A)highlight the required data → click the Data tab → click Connections in the Connections section → enter a suitable name
B)highlight the required data → click the Design tab → click Property Sheet in the Show/Hide section → enter a suitable name
C)highlight the required data → click the Formulas tab → click Define Name in the Defined Names section → enter a suitable name
D)highlight the required data → click the Home tab → click Insert Name in the Cells section → enter a suitable name

Question

Quizplus · Accepted Answer

To create a named range for data in Excel, we need to select the required data and then click the Formulas tab. In the Defined Names section, we need to click on Define Name and provide a suitable name for the range.

Which of the Following Procedures Must Be Used to Create