A Spreadsheet Modeler Is Creating a Spreadsheet to Calculate Each

question 7

Multiple Choice

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After entering the data below, the modeler would like to enter a formula in cell C5 that can then be copied to cells C6 through C9 without further modification. What formula should be entered in cell C5 to make this possible?

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

---

Definitions:

Cost-benefit Value

The analysis or assessment of the anticipated costs and benefits of a particular project or decision.

Resist Change

The tendency of individuals or organizations to oppose or struggle against modifications to the status quo.

Defending

The act of safeguarding something from criticism, danger, or attack, often applied in contexts ranging from personal beliefs to protecting market share.

New Technology

Refers to the latest advancements and innovations in technology that offer new capabilities or significant improvements over previous versions.