Ashu must apply Goal seek to get the desired result.
i. Scenarios: Scenarios are a tool to test “what-if” questions. Each scenario is named, and can be edited and formatted separately. It is essentially a saved set of cell values for your calculations. You can easily switch between these sets using the Navigator or a drop-down list which can be shown beside the changing cells
ii. Goal Seek: It is used to calculate a result based upon existing values. Using Goal Seek option under Tools menu, we can discover what values will produce the result that we want.
iii. Solver: It is more elaborated form of Goal Seek. The difference is that the Solver deals with equations with multiple unknown variables. It is specifically designed to minimize or maximize the result according to a set of rules that we define.
iv. Subtotal: SUBTOTAL is a function listed under the Mathematical category when you use the Function Wizard (Insert > Function). Because of its usefulness, the function has a graphical interface.
SUBTOTAL, totals/adds data arranged in an array—that is, a group of cells with labels for columns and/or rows. Using the Subtotals dialog, you can select arrays, and then choose a statistical function to apply to them. For efficiency, you can choose up to three groups of arrays to which to apply a function.
