Page 426 - TP_IT_V1.0_C10_flipbpookl
P. 426
• Display all the records of table Student.
• Insert one record of your choice.
• Display record of student whose roll number is 3.
• Display record of students who are in class ‘X’.
• Display the record of ‘Anuj’
9. Consider the following marksheet and use the goal seek feature to find the marks in place of question mark (?).
10. Create a scenario for calculating the percentage of five friends using three subjects.
11. Calculate the simple interest with the given Principal=Rs 5000 Rate=5% Time=10 yrs.
• Use goal seek to have less of interest by changing the time variable only.
• Use solver to have less of interest by changing all -rate, principal and time.
12. Create a macro to create a list of students in your class. Format the data with specific font size, color and style. Save
it as a macro.
13. Sunil runs a small business and wants to ensure that he meets customer demand without overstocking. He sells a
product with the following details:
• Current inventory level: 150 units
• Forecasted monthly demand: 200 units
• Desired safety stock: 50 units
Sunil wants to determine the reorder quantity needed to maintain the desired safety stock level at the end of the
month.
14. Yash is a student aiming to achieve a specific target average in his final grades across multiple subjects. He has
already received marks in five subjects and has one more subject left. He wants to determine the minimum marks
he needs to score in the sixth subject to achieve an overall average of at least 85%. Additionally, he wants to
ensure that no individual subject mark is below 50%.
Current Marks:
Subject 1: 82
Subject 2: 88
Subject 3: 79
Subject 4: 91
Subject 5: 85
424 Trackpad Information Technology (Ver. 1.0)-X

