1510 final

1510 final - 1.1 When you reference a cell absolutely the value wont change when you copy and paste it down a column or anywhere else A relative

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

View Full Document Right Arrow Icon
1.1 When you reference a cell absolutely, the value won’t change when you copy and paste it down a column or anywhere else. A relative cell reference only means you are selecting that cell for any reason, not keeping the value constant. One example of an absolute cell reference would be the value of “R”, The Universal Gas Constant. When you are calculating a volume, pressure or temperature using Ideal Gas Law or Van der Waals, The universal gas constant needs to be just that…constant. 1.2 A trend line will split the difference between 2 data points that are relatively close together. If you have a set of data points that are pretty much following the same pattern, a trendline will clean it all up into one, easy to read line. One example of using a trendline would be if you have 2 sets of data; one experimental and one model, the trendline will fit them together into one. 1.3 This can be done by selecting the option of “constraints.” This narrows the field to where this is possible. Many times we can make an educated guess. For example, if
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 10/07/2008.

Page1 / 2

1510 final - 1.1 When you reference a cell absolutely the value wont change when you copy and paste it down a column or anywhere else A relative

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

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