Lab Sections 2 and 4, General Chemistry:
What are your issues with Excel? Let's talk about the problems we are having here, so the whole class can benefit. This will be our running "how-to" discussion for Excel issues. You will be able to access previous questions and solutions, ask your own questions, view my solutions to your specific problem, and also contribute your knowledge to benefit others.
Excelsior!
Pat
A Few Words of Wisdom From Albert Einstein...
"Anyone who has never made a mistake has never tried anything new."
"The important thing is not to stop questioning. Curiosity has its own reason for existing."
"We can't solve problems by using the same kind of thinking we used when we created them."
"Peace cannot be kept by force. It can only be achieved by understanding."
source: Collected Quotes of Albert Einstein; Copyright: Kevin Harris 1995
4 comments:
How do you change the displayed units on a graph? On the time vs. Temp graphs for the last few labs, it breaks the time down into 1:12, 2:24 etc. I wanted it to show every thirty seconds. Any suggestions?
Try putting the numbers in your worksheet column as 0.0, 0.5, 1.0, etc... and see if that makes a difference. This should be regular number formatting, with one decimal place.
There is a way to format time that looks really cool in Excel tables (like 1:00:00), but when you use that format in your columns and then graph the data, the graph scale is skewed like you described.
If this adjustment doesn't work, let me know. :-)
When using the template for Hess's law calculations, I removed the (') mark and entered my data, but the formula did not automatically complete my calculations for Q and Heat of reaction. Sometimes the words 'true' or 'false' was entered in the box, not exactly what I was looking for. What am I doing wrong here?
Hmmm... I'm not sure what went wrong. I think this is one we will have to examine together in the spreadsheet. It is possible that some command or extraneous cells were entered into the formula cell accidentally. We'll figure it out.
Post a Comment