Periodic+Table+Instructions


 * Woessner - PT Step x step**

Periodic Table of Elements
Step by step instructions =Part 1 - Periodic Table= 1)Create a square by using two adjacent cells in either the same row or the same column. Rows are easier. Why? a.Columns - In the larger left cell, you will put the element symbol (centered). In the smaller right cell you will put the element number (vertically aligned top). Select both cells and put an outside border on the square. b.Rows - In the larger bottom cell, you will put the element symbol (centered). In the smaller top cell you will put the element number (left aligned). Select both cells and put an outside border on the square. 2)Once you have the square for one element created, you may copy and paste the square to the other parts of the table to complete the layout of the periodic table. Can you drag/fill to get the element numbers to change automatically? 3)Your table should have five (5) rows and a total of 18 columns (of elements). (**RE** For purposes of this project, you will complete the table to Xenon (54 elements). Not all squares in the grid will have an element. 4)To finish the table, go through and change the element name and number in the rest squares of the table. You will need to resize the column width of the columns with the element number. You can do that by selecting all of the cells, and **format****column** width to **Auto fit selection**. 5)Next, shade the table according to the element groups. (**RE** 6)Then, hide the rows and columns to the left and under your table. Also shade the cells that are still showing but not part of your table. Now you periodic table is complete. =Part 2 - Element sheets (your own)= 1)At the bottom of the spreadsheet, click on where it says **Sheet 2** In sheet 2, set up cells to show the following information for __your__ first element: Element name Element number Now click the **triangle** next to the cell reference, and finally select the sheet for that element. Repeat for the rest of the elements. =Part 3: Linking the sheets to the table.= Select the element that you chose to investigate. For example, if you selected hydrogen, you would click on hydrogen. then click apple-k . You will get a dialogue box. Click in the middle on document, and then click on locate on the right side of the box. Click on the arrow on the side of cell reference to open it up. Click on correct sheet and then click on OK. GO to the Hydrogen Sheet and click on a cell, in the box write Back to table. Click apple-K and go to the middle of the document and and click on locate, open the cell reference tab and choose (table). You've now created links between the two sheets. 
 * RE** - means that you will have to do research for this step