The correct answer is A. Input cells.
Input cells are the cells in a spreadsheet that contain the data that you want to use to solve the problem. The solver cannot change the values in input cells.
Constraints are the rules that you specify to tell the solver how to solve the problem. For example, you might specify that the total cost of the items you buy must be less than a certain amount.
The target cell is the cell that contains the value that you want to maximize or minimize. For example, you might want to minimize the total cost of the items you buy.
Changing cells are the cells in the spreadsheet that the solver can change to solve the problem. The solver will change the values in the changing cells until it reaches a solution that satisfies all of the constraints.
Here is an example of how you might use the solver to solve a problem. Suppose you want to buy a new car. You have a budget of $20,000, and you want to buy a car that gets at least 30 miles per gallon. You also want a car that has at least four seats.
You can use the solver to find the car that meets all of your requirements and costs the least amount of money. To do this, you would first enter the data for the cars you are considering into a spreadsheet. Then, you would specify the input cells, constraints, and target cell. The input cells would be the cells that contain the data for the cars, such as the price, fuel economy, and number of seats. The constraints would be the rules that you specify, such as the budget and fuel economy requirements. The target cell would be the cell that contains the value that you want to maximize or minimize, such as the price.
Once you have specified the input cells, constraints, and target cell, you can click on the Solve button. The solver will then find the solution that satisfies all of the constraints and minimizes the value in the target cell. In this case, the solver would find the car that meets all of your requirements and costs the least amount of money.