In the last part, you will set up an excel sheet to calculate the mass of a precipitate formed in a chemical reaction 1. In A1 input the balanced molecular equation for the reaction of 25.0mL of 0.15M aqueous silver nitrate reacting with 30.0mL of 0.25M lead(11) chloride to form a solid precipitate and another aqueous species.
2. In cells A4-B7 enter the names and molar masses of the compounds in the balanced molecular equation. Be sure to label the column in A3 and B3 correctly with units.
3. In C4-C7 determine the moles of the reactants, again labeling C3 correctly.
4. In D4-57, determine the limiting reagent. You can use any method you have learned, but it must be done in excel using a formula(s). Properly label C3-D3.
5. In F4, determine the amount of solid produced, in grams.
6. In G4, determine the amount of excess reagent remaining, in moles.
7. Save and print the normal spreadsheet. Then using (ctrl"), convert the spreadsheet into a formula spreadsheet and print.