If the Data Cells Are in Column D and the Changing

question 36

Multiple Choice

If the data cells are in column D and the changing cells are in column C,which of the following are linear formulas in a spreadsheet?

• A)SUMPRODUCT(D1:D6,C1:C6)
• B)SUMPRODUCT(C1:C3,C4:C6)
• C)SUM(C1:C6)
• D)All of the above
• E)a and c only

---

Definitions:

Factor X

An element, influence, or set of circumstances that contributes to a result or outcome.

Selection Bias

A distortion in statistical analysis resulting from the method of collecting samples, leading to an unrepresentative sample and misleading results.

Cohort Study

An observational study in which a defined group of people (the cohort) is followed over time to study the incidence of disease or various outcomes.

Asbestos

A group of naturally occurring fibrous minerals known for their resistance to heat, chemicals, and electricity, historically used in construction but hazardous to health.