Which of the Following Procedures Must Be Used to Create

Multiple Choice

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