Multiple Choice
A small business owner uses an Excel spreadsheet to calculate the costs of various health insurance options for her employees. The individual annual premium is in cell B5. The employers monthly contribution is in Cell D9 and the monthly cost of the family option is in cell B6. Which multimath formula should be entered in Cell E9 to calculate the monthly premium for an employee who selects the individual-only healthcare?
A) =(B5/12) +B6
B) =(B5/12) -D9
C) =B5-D9
D) =B5+B6-D9
Correct Answer:
Verified
Correct Answer:
Verified
Q3: Parker Manufacturing buys life insurance policies for
Q4: Ridell's employer pays for $60 of his
Q6: Which amount will the insurance company pay
Q10: Calculate the individual monthly premium for an
Q15: Leonard uses Excel to track life insurance
Q21: Term life insurance is a type of
Q23: _ protects the insured against property damage
Q32: What amount of property insurance coverage is
Q33: What is the annual premium for a
Q34: If the Townsend family pays $4.10 per