Question

3. Given a worksheet that stores the top 5 students' marks. The Final marks are
calculated as 25% of Term 1 marks + 30% of Term2 marks and 45% of Term3
marks,
The Term3 marks entered in the worksheet are estimated marks.
In order to avail the scholarship, the student must obtain final % as> 80%.
Max Marks: 500
1. NAME
TERM1 TERM2 TERM3 FINAL FINAL%
12 Tarun
360
389 410 391.2 78.24
1 Rahul
377
355 430 394.25 78.85
is Karan
410
390 460 426.5 85.3
- Arjun
390
360 450 408 81.6
Shubham 380
368 410 389.9 77.98
22
(0) Use Goal Seek by taking cell from Final % column and variable cell from
Term3 column and Paste in your practical file before and after result.
(11) Use Scenario for Term3 values to get desired result in Final% and Paste
in your practical file before and after result.​

Answer 1

yes

yes qawwali 9++_+_+_