To Set Up a Scenario, You Create or Use a Worksheet

question 121

Multiple Choice

To set up a scenario, you create or use a worksheet that contains sets of input and output cells, as you do with data tables. For example, in a worksheet listing sales assumptions and projections, the projections are ____.

• A) input cells
• B) output cells
• C) guiding cells
• D) lead cells

---

Definitions:

Spending Variance

The difference between the actual amount of money spent and the budgeted amount, often analyzed in cost management.

Customers Served

The total number of customers who receive service or goods from a company within a specified period.

Fixed and Variable Cost

Costs that remain constant regardless of the level of production or sales (fixed) and costs that change in proportion to the level of production or sales (variable).

Total Expenses

The sum of all costs and expenses incurred by a business, including cost of goods sold and operational expenses.