Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 13 0 6 STUDENT DATA 2 1 Student Name Student Age 5 Year in School Kristen Hockman 17 11 10 Freshman Sophomore Junior =

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Implementing An Audit Programme Developing And Implementing A Healthcare Audit Programme

Authors: Achal Kumar Gupta

1st Edition

3659298883, 978-3659298882

More Books

Students also viewed these Accounting questions

Question

Distinguish between formal and informal reports.

Answered: 1 week ago