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