Question
In cell B7, use data validation to create a dropdown list of insurance amount choices based on the values in range A32:A131. Hint: use the
In cell B7, use data validation to create a dropdown list of insurance amount choices based on the values in range A32:A131. Hint: use the Offset and Match functions to create a named range to ensure the values displayed in the dropdown list conform to the requirements (employees can choose up to 5x salary with a maximum of $1M).
| Employee ID | 1083 |
| Name | Baze |
| Department | IT |
| Salary | $ 77,000 |
| Voluntary Life Insurance | #N/A |
| Voluntary Life Insurance is available in $10,000 increments up to 5 times the employee's base salary, with a maximum of $1 Million. | |
| $10,000 |
| $20,000 |
| $30,000 |
| $40,000 |
| $50,000 |
| $60,000 |
| $70,000 |
| $80,000 |
| $90,000 |
| $100,000 |
| $110,000 |
| $120,000 |
| $130,000 |
| $140,000 |
| $150,000 |
| $160,000 |
| $170,000 |
| $180,000 |
| $190,000 |
| $200,000 |
| $210,000 |
| $220,000 |
| $230,000 |
| $240,000 |
| $250,000 |
| $260,000 |
| $270,000 |
| $280,000 |
| $290,000 |
| $300,000 |
| $310,000 |
| $320,000 |
| $330,000 |
| $340,000 |
| $350,000 |
| $360,000 |
| $370,000 |
| $380,000 |
| $390,000 |
| $400,000 |
| $410,000 |
| $420,000 |
| $430,000 |
| $440,000 |
| $450,000 |
| $460,000 |
| $470,000 |
| $480,000 |
| $490,000 |
| $500,000 |
| $510,000 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Advanced MySQL 8 Discover The Full Potential Of MySQL And Ensure High Performance Of Your Database
Authors: Eric Vanier ,Birju Shah ,Tejaswi Malepati
1st Edition
1788834445, 978-1788834445
