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

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

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

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

View Full Document
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
Ask a homework question - tutors are online