TheMolecularMassCalculatorworksheetwillcalculatethemolecularmassforauser‐ specifiedgasmolecule.Tospecifythegasmolecule,theMolecularMassCalculator...

TheMolecularMassCalculatorworksheetwillcalculatethemolecularmassforauser‐ specifiedgasmolecule.Tospecifythegasmolecule,theMolecularMassCalculator worksheetmustbeabletoacceptuptothree(3)differentelements.Theusermust specifythenumberofatomsforeachelement.TheMolecularMassCalculator worksheetmustreturntheatomicweightofeachelement,theformulaforeach element,themolecularformulaofthegas,andthemolecularmass. ConsidersettingupatableintheMolecularMassCalculatorworksheet,similartothe tableshownbelow.Theshadedcellsinthetableindicatewhatinformationtheuseris toprovide.Thecontentforthenon‐shadedcellsmustbegeneratedbythe spreadsheet. Element1 Element2 Element3 Element AtomicWeight Number Formula MolecularFormula MolarMass g/mol YourMolecularMassCalculatormustbeabletolookuptheatomicmassforeach elementfromatableofperiodictabledata.Periodictabledatacontainsatomicsymbol, atomicmass,andatomicnumber.Theperiodictabledataisprovidedinthetextfile namedperiodic_table.txt.Youshouldimportthedatafoundintheperiodic_table.txt textfileintoaseparateworksheetinyourworkbook.