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:

Health Risks

Potential conditions or behaviors that increase the likelihood of developing health problems or diseases.

Social Class

A division of a society based on social and economic status, influencing individuals’ access to resources and power.

Life Expectancy

The average period that a person may expect to live, often calculated from the time of birth based on a range of demographic factors.

Morbidity Statistics

Data and figures that measure the incidence and prevalence of diseases across different populations and demographics.