Question: Question 13 0 6 STUDENT DATA 2 1 Student Name Student Age 5 Year in School Kristen Hockman 17 11 10 Freshman Sophomore Junior =
Question 13 0 6 STUDENT DATA 2 1 Student Name Student Age 5 Year in School Kristen Hockman 17 11 10 Freshman Sophomore Junior = 12 6 Senior 1 . You want to create a Combo Box in Cell C5 that will allow the user to choose from a drop-down menu what year the student is in school, and then the number associated with that year in school will be displayed in Cell B5 (for example, if the student chooses Junior from the drop-down menu, then 11 will be displayed in Cell B5). Assume the range E3:F6 has been named Year. You want the drop-down menu to show the number and name for the year in school. In other words, you want both columns of data from the Year range to be displayed in the drop-down menu. What properties need to be changed in order to create this Combo Box, and what should each of these properties be set at? (8 points) Et View Insert Format Tools Table 12tParagraph B TUA TU: MacBook Pro DO DOO 808 ll $ A 4 % 5 6 & 7 C 9 8 O - - R R T Y 11
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
