Periodic Trends Lab In this activity, you will explore the trends of atomic radius vs$.$ atomic number and ionization energy vs$.$ atomic number. Using the table of values below, construct two graphs using Excel showing the periodic property vs$.$ atomic number. In this lab, atomic number is the independent variable and the periodic property is the dependent variable. You will need to graph an XY Scatter chart in Excel. Instructions for making an XY Scatter Chart in Microsoft Excel: $1.$ Copy your data into a blank worksheet. $2.$ Select the data that you want to plot in the line chart. $3.$ Click the Insert tab, and then click Insert Line or Area Chart. $4.$ Click Line with Markers. $5.$ Click the chart area of the chart to display the Design and Format tabs$.6.$ Click the Design tab, and then click the chart style you want to use. $7.$ Click the chart title and type the text you want. $8.$ To change the font size of the chart title, right$-$click the title, click Font, and then enter the size that you want in the Size box. Click OK$.9.$ Click the chart area of the chart. $10.$On the chart, click the legend, or add it from a list of chart elements $($on the Design tab, click Add Chart Element $>$ Legend, and then select a location for the legend$).11.$To plot one of the data series along a secondary vertical axis, click the data series, or select it from a list of chart elements $($on the Format tab, in the Current Selection group, click Chart Elements$).12.$On the Format tab, in the Current Selection group, click Format Selection. The Format Data Series task pane appears. $13.$Under Series Options, select Secondary Axis, and then click Close. $14.$On the Design tab, in the Chart Layouts group, click Add Chart Element, and then do the following: a$.$ To add a primary vertical axis title, click Axis Title $>$Primary Vertical. and then on the Format Axis Title pane, click Size & Properties to configure the type of vertical axis title that you want. b$.$ To add a secondary vertical axis title, click Axis Title $>$ Secondary Vertical, and then on the Format Axis Title pane, click Size & Properties to configure the type of vertical axis title that you want. c$.$ Click each title, type the text that you want, and then press Enter $15.$Click the plot area of the chart, or select it from a list of chart elements $($Format tab, Current Selection group, Chart Elements box$).16.$On the Format tab, in the Shape Styles group, click the More button $,$ and then click the effect that you want to use. $17.$Click the chart area of the chart. $18.$On the Format tab, in the Shape Styles group, click the More button $,$ and then click the effect that you want to use. $19.$If you want to use theme colors that are different from the default theme that is applied to your workbook, do the following: a$.$ On the Page Layout tab, in the Themes group, click Themes. b$.$ Under Office, click the theme that you want to use. This procedure will produce a graph similar to this: Element Symbol Atomic Number Atomic Radius $($Angstroms$)$ Ionization Energy $($Electron$-$Volts$)$ H $10\mathrm{.}7913\mathrm{.}6$ He $20\mathrm{.}4924\mathrm{.}587$ Li $32\mathrm{.}055\mathrm{.}392$ Be $41\mathrm{.}49\mathrm{.}322$ B $51\mathrm{.}178\mathrm{.}298$ C $60\mathrm{.}9111\mathrm{.}26$ N $70\mathrm{.}7514\mathrm{.}534080\mathrm{.}6513\mathrm{.}618$ F $90\mathrm{.}5717\mathrm{.}422$ Ne $100\mathrm{.}5121\mathrm{.}564$ Na $112\mathrm{.}235\mathrm{.}139$ Mg $121\mathrm{.}727\mathrm{.}646$ Al $131\mathrm{.}825\mathrm{.}986$ Si $141\mathrm{.}468\mathrm{.}151$ p $151\mathrm{.}2310\mathrm{.}486$ s $161\mathrm{.}0910\mathrm{.}36$ Cl $170\mathrm{.}9712\mathrm{.}967$

Questions: $1.$ Looking carefully at the data, what elements have been left out? Why do you think they have been omitted? $2.$ Describe the general trend for ionization energy for a period and a group. $3.$ Describe the general trend for atomic radius for a period and a group. $4.$ Place one graph on top of the other and describe the relationship between the trends in each graph. $5.$ Why is there a dip in ionization energy between the elements Be and B$,$ between Mg and Al$,$ and between Ca and Ga$?($Hint: Think about electron distributions$)$ Be sure to write a formal lab report using the template from Module $1.$ Paste your graphs, data, and questions and all other sections in the appropriate order