for excel

Set up a spreadsheet that is a health care calculator tool for employees to use with the following inputs that the employee would enter:

Plan Type: (1) PPO or HSA

Coverage Level: (2) Family, Plus One, or Single

There are two result cells:

(1) Monthly Premium

(2) Annual Total Deductible

Use the developer tool in Excel to create a form with two Drop Down boxes (aka Combo Box) for each of the inputs above.

Then use IF statements to have the appropriate amounts show up in the result cells. Below is the table showing the premiums and deductible by choices.

When you submit this task, save the file as an Excel file in the format: LastName_Task3.

PPO or HSA	Family, Plus-One, or Single	Monthly Premium	Annual Deductible
PPO	Single	$300	$1,000
PPO	Plus-One	$550	$1,500
PPO	Family	$750	$2,000
HSA	Single	$175	$2,500
HSA	Plus-One	$325	$4,000
HSA	Family	$500	$5,000