Question

1. Given a worksheet that stores the top 5 students’ marks. The final marks are calculated as 25%of Term1 marks+30% of Term2 marks +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%
Name Term1 Term2 Term3 Final Final%
Teena 360 389 410 391.2 78.24
Tahir 377 355 430 394.25 78.85
Krishna 410 390 460 426.5 85.3
Arav 390 360 450 408 81.6
Simar 380 368 410 389.9 77.98
Estimate how much Term3 marks would be required by each student to meet this condition. For this:
i. Use scenario for Term3 values to get desired result in Final%.

Answer 1

Answer:

MS Excel” program STEP 2: Fill your data by these information “Sl No”, “Name”, “F/Name”, “English”, “Chemistry”, “Mathematics”, “Physics”, “Biology”, “Drawing”, “History”, “Total Marks”, “Marks Obtained”, “Minimum no”, “Maximum no”, “Average”, and “Grade”. Bold your text and then fill it by your own information as given below

3. Step 3 : Use this function in first cell of “Marks Obtained” which is given as =sum(F5:L5)