A Student Is Using a Spreadsheet Model to Track Monthly

question 19

Multiple Choice

A student is using a spreadsheet model to track monthly income and expenses and also to calculate his annual income. After pressing Ctrl+~, the formula view of the spreadsheet (shown below) was visible. What spreadsheet construction error did the student commit?

• A) Using an advanced Excel formula instead of a simpler mathematical calculation.
• B) Entering data in more than one place.
• C) Failure to adequately use labels to identify cells.
• D) Incorrect formula.
• E) There are no errors in the spreadsheet.

---

Definitions:

Research Hypothesis

An assertion or conjecture regarding the outcome of a study, proposing a potential relationship between variables.

Archival Research

A method of research involving the analysis of existing records or archival data to find answers to research questions.

Police Records

Documents and files maintained by law enforcement agencies that detail criminal incidents, arrest records, investigative reports, and other law enforcement activities.

Confounding Variable

Variable related to an independent variable that provides an alternative explanation for the relationship between the independent and dependent variables.