Lab 8 Excel Tutorial - Lab8ExcelTutorial 1.)

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Lab 8 Excel Tutorial 1.) What I have below is a screen cap of Excel 2007 with the columns labeled as shown in  your lab manual. I also took the liberty of putting all the temperatures in K and the  volume of HCl in mL. Notice that these are not actual lab values, so you’ll need to use  what you collected from your classmates in lieu of what I added. 2.) On the next page, I calculate 1/T first, because it is easiest. Type in “=1/” in the box you  want your value to appear in, then click on the cell containing the quantity you want. In  this case, we are dividing by the first temperature, in cell A2, so click on that.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2b.) When you have finished typing this in, hit enter and Excel will calculate the value for  you.  2c.) You can then put your Excel cross-shaped curser in the LOWER RIGHT HAND  CORNER of the box you just made (like above), and drag down through all the data points  you want to calculate (for every temperature, here). This will do the calculation you just did  for every highlighter cell.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/22/2010 for the course CHEM 3 taught by Professor Pedersen during the Fall '08 term at University of California, Berkeley.

Page1 / 8

Lab 8 Excel Tutorial - Lab8ExcelTutorial 1.)

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online