Page 163 - Computer - 10(A&B)

Step 3: You see the defined scenarios with the comments that were entered when the scenarios were created.
• Double-click a scenario name in the Navigator to apply that scenario to the current sheet.

• To delete a scenario, right-click the name in the Navigator and choose Delete option.
• To edit a scenario, right-click the name in the Navigator and choose Properties option.
• To hide the border of a set of cells that are part of a scenario, open the Properties dialog box for
each scenario that affects the cells and clear the Display border checkbox. Hiding the border also
removes the listbox on the sheet where you can choose the scenarios.

To know the cell values in the scenario that affect
other cells values, choose Tools  Detective Trace
Dependents. You see arrows to the cells that are
directly dependent on the current cell.

Goal Seek

Let’s suppose that in the previous exam, you have scored average marks 67.5 , and you need at least 75 marks
to get distinction in the class. Luckily, you have one final exam that might be able to raise your average. You can
use Goal Seek to find out how many marks you need on the next exam.
The marks in Term 1 and Term 2 are 80 and 75. Even though we don’t know what the Term 3 will be, we can go
ahead and write a formula or function that calculates the final grade. In this case, each exam is weighted equally,
so all we have to do is average all three exams by typing =AVERAGE(B2:B4). Once we use Goal Seek, cell B5 will
show us the minimum marks we’ll need to score in Term 3.
Step 1: Select the cell containing the value you want to change. When you use Goal Seek, you’ll need to select a
cell that already contains a formula or function. In our example, we’ll select cell B5 because it contains
the formula =AVERAGE(B2:B4).

45