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
   421   422   423   424   425   426   427   428   429   430   431