Question

C E F G В Activity 1 $20 D Activity 3 $30 Activity 2 $40 Unit Profit NM 4 Resourceſ Resource Used per Unit Produced 1 Totals 400 100 200 Available 400 100 200 | Activity 3 Activity 1 50 Activity 2 50 | 10 Units Produced Total Cost $3,000 0 Where are the changing cells located? Multiple Choice 0 E5:E7 £5:07 0 B10:D10 0 G10 610 0 B2:02 B2:02 0 B2:D2, B4:07, and G5:67

Answer 1

Changing cells are those cells which will affect any formula or other cell(s) data, if the data of that cell is altered.

A cell reference refers to a cell or a range of cells on a worksheet the data of which can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

Here,

If the data of the UNITS PRODUCED for each activity is altered, the TOTAL COST is also altered.

Thus the answer is - Option 2 (B10:D10)

The other options are disregarded as the values of those cells either can't be altered (unit profit) or their alteration will not have any impact on the cost (the total of resources used, as they can't be more than resources available).