A Spreadsheet Modeler Is Creating a Spreadsheet to Calculate Each

question 24

Multiple Choice

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. The modeler has named cell B2 "Hourly_Wage" to make the model more understandable. What formula should be entered into cell C5?

• A) =B1*B5
• B) =B1*$B$5
• C) =Hourly_Wage*B5
• D) =$B$2*Hourly_Wage
• E) =Hourly_Wage +B5

---

Definitions:

Health Literacy

The ability to obtain, read, understand, and use healthcare information to make appropriate health-related decisions.

Critical Thinking

The objective analysis and evaluation of an issue to form a judgment, often involving skeptical and unbiased reasoning.

Binge Drinking

The consumption of an excessive amount of alcohol in a short period, typically considered as five or more drinks on a single occasion for men, and four or more for women.

Obese

A medical condition characterized by excess body fat accumulated to the extent that it may have a negative effect on health, potentially leading to reduced life expectancy and/or increased health problems.