3 Li2S lithium sulfide. One method uses VLOOKUP and direct worksheet and cell references.
Naming And Writing Formulas For Chemical Compounds Flow Chart Flow Chart Teaching Chemistry Chemistry Lessons
4 MgBr2 magnesium bromide.
Names and formulas worksheet 2. In the Name Manager dialog box click New button see screenshot. 2 CaO calcium oxide. 1 FeCN 3 iron III cyanide 2 K 4.
7 HClO4 q perchloric acid. To create a name in Excel select all the cells you want to include and then either go to the Formulas tab Defined names group and click the Define name button or press Ctrl F3 and click New. For the list on the right give the chemical formula that corresponds to the name Name Formula 1 NaF 13 potassium fluoride 2 K2CO 3 14 ammonium sulfate 3 MgCl 2 15 magnesium iodide 4 BeOH 2 16 copper II sulfite.
In the example shown the formula in E5 is. 11 tricarbon octafluoride C 3 F 8. Answer keys are provided separately.
Here are printable chemistry worksheets in pdf format. The difference is that you include the sheet name in the table_array argument to tell your formula in which worksheet the lookup range is located. The key here is that the INDIRECT function acts as the messenger that returns the correct sheet address in a dynamic way to the different lookup formulas.
Anne Marie Helmenstine PhD. To list worksheets in an Excel workbook you can use a 2-step approach. Updated August 03 2018.
Ad The most comprehensive library of free printable worksheets digital games for kids. Its very similar to a regular VLOOKUP formula that searches on the same worksheet. Current tab you can use a formula based on the CELL functionCELL retrieves the workbook name and sheet and the MID and FIND functions are used to extract just the sheet name.
A magnesium oxide MgO b sodium fluoride NaF c aluminum nitride AlN d potassium sulfide K 2 S e lithium iodide LiI f calcium bromide CaBr 2 g beryllium oxide BeO h nickel III chloride NiCl 3 i magnesium nitride Mg 3 N 2. Write the formulas for the a carbon dioxide b silicon dioxide Cc water Id carbon disulfide e sulfur trioxide f ammonia g carbon tetrachloride h hydrogen peroxide Ii methane j ozone trioxygen k diphosphorus trioxide I nitrogen monoxide. In the New Name dialog type any name you want remember that spaces are not allowed in Excel names and check if the correct range is displayed in the Refers to field.
9 sodium nitrate NaNO3. For starters lets investigate a simplest case - using VLOOKUP to copy data from another worksheet. In Excel you can define a range name and then apply a formula to list all sheet names from current workbook please do with following steps.
The second worksheet asks for the chemical name based on the chemical formula. The other approach uses INDEX MATCH and Excel Table names and references. Names and Formulas COMBO TYPE FORMULA NAME Hg P I Hg 3P Mercury I phosphide Mn 4 SiO 4 I MnSiO 4 Manganese IV orthosilicate F As C AsF 3 Arsenic trifluoride B P C BP Boron monophosphide Au NO 3 I AuNO 3 Gold I nitrate C2O4 Li I Li2C2O4 Lithium oxalate I H2TeO 4 Telluric acid I GaSCN3 Gallium thiocyanate I CrP 2O7 Chromium IV pyrophosphate.
Get a list of all worksheet names from a workbook dynamically with formulas. Name the following ionic compounds. 5 BeOH2 beryllium hydroxide Write the formulas for the following ionic compounds.
Write the names of the following chemical compounds. I ran into this formula on the MrExcel message board in a post by T. To get the name of the current worksheet ie.
7 magnesium oxide MgO. H3PO4aq phosphoric acid. 6 potassium iodide KI.
1 define a named range called sheetnames with an old macro command and 2 use the INDEX function to retrieve sheet names using the named range. Write the formulas of the following acids and bases. Ad The most comprehensive library of free printable worksheets digital games for kids.
Get thousands of teacher-crafted activities that sync up with the school year. In the example shown the formula in B5 is. In the above formulas.
8 aluminum chloride AlCl3. 1 NaBr sodium bromide. The first worksheet in each set asks you to name the chemical formula based on the chemical name.
Write the formulas for the following compounds. Vlookup to compare two lists in separated worksheets. Names and Formulas Worksheet Answers 1.
7 MgI 2 magnesium iodide 8 NiO 2 nickel IV oxide 9 P 2 S 5 diphosphorus pentasulfide 10 SnSe 2 tin IV selenide Write the formulas of the following chemical compounds. A2 is the first cell of the worksheet that you want to compare Names-2 is another worksheet name that you want to compare A2A19 is the name column to be compared with. Get thousands of teacher-crafted activities that sync up with the school year.
Go to click Formula Name Manager see screenshot. Names and Formulas Worksheet 1. Mixed Naming Worksheet 2 W 303.
Compound Names and Formulas Worksheet Three For the list on the left name the compound. 99 hydrobromic acid HBr 100hydrofluoric acid HF 101 carbonic acid H 2 CO 3 102 lithium hydroxide LiOH 103 nitrous acid HNO 2 104 cobalt II hydroxide CoOH 2 105 sulfuric acid H 2 SO 4 106 beryllium hydroxide BeOH 2. Acid Name Anion in Acid Acid Formula XXXXXXXXXX Name Formula XXXXXXXXXXX Hydrophosphoric acid Phosphide P-3 H3P Sulfuric acid Sulfate SO42- H2SO4 Nitrous acid Nitrite NO2- HNO2 Chromic acid Chromate CrO42- H2CrO4 Hydrosulfuric acid Sulfide S-2 H2S Name the following acids.
3 5 Ionic Compounds Formulas And Names Teaching Chemistry Chemistry Education Chemistry Lessons
404 Not Found Chemistry Worksheets Chemistry Classroom Naming Chemical Compounds Worksheet
Ion Names Formulas And Charges Chart Notebook Size Pad Of 30 Chemistry Classroom Science Chemistry Chemistry Basics
Naming Ionic Compounds Lab Ionic Compounds Naming Compounds Worksheet Chemistry Classroom
Writing Binary Formulas Worksheets Answer Key Writing Worksheets Word Problem Worksheets Writing Linear Equations
Understanding Chemical Formulas Worksheet Best Chemical Formula Writing Worksheet Ii Revised 1 8 Pdf I Writing Worksheets Chemistry Worksheets Chemical Formula
Naming Ionic Compounds Puzzle Sheet By Brian Boroski Tpt In 2021 Ionic Compounds Persuasive Writing Prompts Chemistry Worksheets
Naming Molecular Compounds Worksheet Answers Encouraged To Be Able To My Own Website On This Momen Chemistry Lessons Teaching Chemistry Chemistry Worksheets
Iupac Names Of Unbranched Alkanes Chemistry Textbook Chemistry Basics Chemistry Classroom In 2021 Teaching Chemistry Chemistry Basics Study Chemistry
List Of Chemical Formula Or Common Name Of All Inorganic Compound Brainly In Chemistry Basics Chemistry Lessons Science Formulas
3 5 Ionic Compounds Formulas And Names Ionic Compounds Names Chemistry
Chemical Formulas And Names Worksheet Worksheets Are A Crucial Part Of Gaining Knowledge Of English Littl In 2021 Chemistry Lessons Ap Chemistry Chemistry Education
Chemistry Ionic Compounds Polyatomic Ions Worksheets Answers Naming Compounds Worksheet Ionic Compounds Polyatomic Ion
Wordpress Com Chemistry Lessons Teaching Chemistry Chemistry Worksheets
Learning To Write Chemical Formulas From Names Teaching Chemistry Chemistry Classroom Teaching Writing
Coschemistry Lesson 6 05 Naming Alkanes Chemistry Worksheets Practices Worksheets Worksheet Template
Chemical Formula Worksheets Answer Key Teaching Chemistry Chemistry Education Chemistry Lessons
Pin By Christina Brock On Chemistry Teaching Chemistry Chemistry Lessons Chemistry Education
Naming Ionic Compounds Polyatomic Ion Chemistry Worksheets Ionic Compounds
Comments :
Post a Comment