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:

Case Law

Legal principles developed through decisions in court cases rather than statutes.

Fifth Amendment

An amendment to the U.S. Constitution that provides protections including the right against self-incrimination and double jeopardy.

Self-Incrimination

The act of giving testimony that implicates oneself in criminal wrongdoing. The Fifth Amendment to the Constitution states that no person “shall be compelled in any criminal case to be a witness against himself.”

Double Jeopardy

To place at risk, jeopardize, a person’s life or liberty twice. The Fifth Amendment to the Constitution prohibits a second prosecution for the same criminal offense.