Ionization Energy And The First 20 Elements: Msexcel Activity

ADVERTISEMENT

Ionization Energy and the first 20 elements: MSExcel activity
Your task: 1. To use Excel to calculate the ionization of the first 20 elements, and graph the results.
2. To use Excel to try and modify the formula that you used to get better, more accurate
results.
Data: Use the grid in the packet, pg 4, as a guide to help you build your data table. It is important that
Excel is used to calculate the values – don’t calculate them yourself and type then in!
The data table should include an “actual IE” column and a “percent error” column.
Using Excel:
There are 5 important things that you need to know how to do in Excel to be successful in this project.
Take notes in the space below if you don’t know how to do a task.
Performing formulas and calculations:
Sample Excel table
A
B
C
1
2
3
4
5
6
Referencing another cell in a calculation:
Copying the contents of a cell:
Copying the contents of a cell while keeping the reference cell consistent:
Making a graph or chart:

ADVERTISEMENT

00 votes

Related Articles

Related forms

Related Categories

Parent category: Education
Go
Page of 2