Could you answer parts 1-4 for this question. I do not understand how to do it
A B C D E F G I L M N O P Q R S U 2 Exercise: Create a simple application that calculates the yearly college expense for a student. All form controls should be placed in the gray box below. The results should look approximately like the picture to the right. 3 4 5 1. Add three option (radio) buttons and name them Undergraduate Program, Masters Program, and Doctoral Program for the program the student is in. (To make them look professional, you should align them nicely, but you won't be graded on this. Also, you can surround them by a group box, to show that they are a logical group, but this is optional.) Link these three buttons to cell C27 (yes, hidden behind the gray box). Be careful to spell the names of the option buttons EXACTLY as shown. Student options Yearly expense $18,000.00 Undergraduate Program 2. Add a check box and name it Out-of-State Student. Link it to cell C28. In this case, there are only two possibilities: The student is either an in-state student or an out-of-state student. Be careful to spell the name of the check box EXACTLY as shown. Expenses for in-state student living on campus Undergraduate Masters Doctoral $15,000 $20,000 $5,000 Masters Program Doctoral Program 3. Add another check box and name it Lives Off Campus. Link it to cell C29. Again, there are only two options: The student lives on campus or off campus. Be careful to spell the name of the check box EXACTLY as shown. Percentage increases Out-of-state Living off campus O Out-of-State Student 35% 20% 4. Enter an appropriate formula in cell 124 to calculate the yearly expense of the student, depending on the options checked. Hint: As part of the formula, you can use the INDEX function on the range H28:J28. Lives off Campus Notes: (1) If a student is out-of-state, the relevant expense in row 28 is increased by 35%. If, in addition, the student lives off campus, an extra 20% is added. The effects of these increases should be compounded. (2) The doctoral expense is lower because most doctoral students receive considerable financial aid. 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Student options Yearly expense Expenses for in-state student living on campus Undergraduate Masters $15,000 $20,000 Doctoral $5,000 Percentage increases Out-of-state Living off campus 35% 20% 2 A B C D E F G I L M N O P Q R S U 2 Exercise: Create a simple application that calculates the yearly college expense for a student. All form controls should be placed in the gray box below. The results should look approximately like the picture to the right. 3 4 5 1. Add three option (radio) buttons and name them Undergraduate Program, Masters Program, and Doctoral Program for the program the student is in. (To make them look professional, you should align them nicely, but you won't be graded on this. Also, you can surround them by a group box, to show that they are a logical group, but this is optional.) Link these three buttons to cell C27 (yes, hidden behind the gray box). Be careful to spell the names of the option buttons EXACTLY as shown. Student options Yearly expense $18,000.00 Undergraduate Program 2. Add a check box and name it Out-of-State Student. Link it to cell C28. In this case, there are only two possibilities: The student is either an in-state student or an out-of-state student. Be careful to spell the name of the check box EXACTLY as shown. Expenses for in-state student living on campus Undergraduate Masters Doctoral $15,000 $20,000 $5,000 Masters Program Doctoral Program 3. Add another check box and name it Lives Off Campus. Link it to cell C29. Again, there are only two options: The student lives on campus or off campus. Be careful to spell the name of the check box EXACTLY as shown. Percentage increases Out-of-state Living off campus O Out-of-State Student 35% 20% 4. Enter an appropriate formula in cell 124 to calculate the yearly expense of the student, depending on the options checked. Hint: As part of the formula, you can use the INDEX function on the range H28:J28. Lives off Campus Notes: (1) If a student is out-of-state, the relevant expense in row 28 is increased by 35%. If, in addition, the student lives off campus, an extra 20% is added. The effects of these increases should be compounded. (2) The doctoral expense is lower because most doctoral students receive considerable financial aid. 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Student options Yearly expense Expenses for in-state student living on campus Undergraduate Masters $15,000 $20,000 Doctoral $5,000 Percentage increases Out-of-state Living off campus 35% 20% 2
