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:

Depreciation Expense

An accounting method that allocates the cost of a tangible asset over its useful life, representing the reduction in value of an asset over time.

Operating Expenses

The costs associated with the day-to-day operations of a business, including rent, utilities, salaries, and office supplies, but excluding the cost of goods sold.

Current Assets

Short-term assets expected to be converted into cash, sold, or consumed within one year or the operating cycle, whichever is longer.