A Small Business Owner Uses an Excel Spreadsheet to Calculate

question 17

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

---

Definitions:

Alkene

Hydrocarbons that contain at least one double bond between carbon atoms, part of the unsaturated hydrocarbons class.

Molar Heat

The heat absorbed or released by one mole of a substance during a phase change or chemical reaction, often measured in Joules per mole (J/mol).

Bredt's Rule

A principle stating that bridged bicyclic compounds cannot have a double bond at a bridgehead position unless the rings are sufficiently large.

Catalytic Cracking

A chemical process used in petroleum refineries to break down large, heavy hydrocarbon molecules into smaller, more useful ones, often utilizing a catalyst.