Which of the Following Procedures Must Be Used to Create

question 35

Multiple Choice

Which of the following procedures must be used to create a named range for data in Microsoft Excel?

• A) highlight the required data → click the Formulas tab → click Define Name in the Defined Names section → enter a suitable name
• B) highlight the required data → click the Home tab → click Insert Name in the Cells section → enter a suitable name
• C) highlight the required data → click the Data tab → click Connections in the Connections section → enter a suitable name
• D) highlight the required data → click the Design tab → click Property Sheet in the Show/Hide section → enter a suitable name

---

Definitions:

Demand

The quantity of a good or service that consumers are willing and able to purchase at a given price over a specified period of time.

Constraint

A limitation or restriction in a problem-solving or decision-making process, often imposed by the requirements or conditions of a scenario.

Cutting Pattern

A specified arrangement or plan for cutting materials, used in manufacturing or textile production to maximize efficiency or output.

Solver

A tool or algorithm used to find the solution to mathematical problems or optimize certain parameters within constraints.