Explanation: In this problem, Rohit needs to calculate the score he must achieve in IT to have an 85% aggregate score across three subjects: English, Maths, and IT. The aggregate score is calculated as the total marks obtained divided by the total possible marks, multiplied by 100 to get a percentage.
First, let's understand the concept of Goal Seek in Excel. Goal Seek is a powerful tool that allows you to find the input value needed to achieve a specific result in a formula. It is particularly useful when you know the desired output but need to determine the input value that will produce that output.
To use Goal Seek for this problem, Rohit would set up his Excel sheet as follows:
1. Enter the scores and total marks for English and Maths.
2. Set up a cell for the IT score, which is the variable we need to find.
3. Create a formula to calculate the aggregate score using the scores from all three subjects.
The formula for the aggregate score would be:
\[ \text{Aggregate Score} = \left( \frac{\text{English Score} + \text{Maths Score} + \text{IT Score}}{\text{Total Possible Marks}} \right) \times 100 \]
Given:
- English Score = 25 out of 30
- Maths Score = 22 out of 30
- Total Possible Marks = 30 (English) + 30 (Maths) + 30 (IT) = 90
Rohit wants an aggregate score of 85%. Using Goal Seek, he can set the target cell (the cell with the aggregate score formula) to 85 and specify the IT score cell as the variable to change. Excel will then calculate the exact IT score needed to achieve the 85% aggregate.
The other options are not suitable for this problem:
- Macro: A macro is a set of recorded actions that can be replayed to automate tasks, but it does not solve for a specific target value in a formula.
- Solver: Solver is used for optimization problems with multiple variables, which is more complex than what Rohit needs.
- Subtotal: Subtotal is used for summarizing data and does not help in finding a specific input value to achieve a target output.
Therefore, the correct answer is Goal Seek, as it directly addresses Rohit's need to find the specific IT score required to achieve an 85% aggregate score.