Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculatethe score in IT he needs to achieve 85 percent in aggregate. Suggest him thesuitable option out of the following to do so.

Category: Miscellaneous Indian Gk

Hint: Think about the Excel tool that can help solve for a specific value to meet a target.

Correct Answer: C) Goal seek.

Exam Relevance: CAT, GMAT, GRE, Bank PO

Difficulty: Moderate

Explanations:

Enter the scores in English and Maths in Excel.

Set up a cell for the score in IT, which will be the variable we are solving for.

Set up a formula to calculate the aggregate score using the scores in English, Maths, and IT.

Use Goal Seek to set the target cell (the aggregate score) to 85% by changing the cell for the score in IT.

Option Analysis:

Option A: Macro is a set of recorded actions in Excel that can be replayed, but it does not solve for a specific value to meet a target. It is not suitable for this scenario.
Option B: Solver is an Excel add-in that can solve complex optimization problems, but it is more complex than necessary for this simple calculation. Goal Seek is more appropriate for this straightforward problem.
Option C: Goal Seek is the correct choice because it allows Rohit to determine the score he needs in IT to achieve an 85% aggregate score. It is designed to solve for a specific value in a formula.
Option D: Subtotal is a function used to calculate subtotals in a list, but it does not help in solving for a specific value to meet a target. It is not suitable for this scenario.

Mnemonic: Goal Seek: "Seek the Goal"