Excel Notes - Relative reference when the fill handle is...

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

View Full Document Right Arrow Icon
1 t Relative reference – when the “fill handle” is dragged and formulas change automatically adjusting for the new position. t Absolute reference – when the “fill handle” is dragged the same cell reference is kept where a “$” is added. t 3-D Reference – combines sheet reference and cell reference. For example: =SUM(Sheet1:Sheet3!B1:B3) adds all the values from B1 to B3 in all the sheets from Sheet1 to Sheet3. The “!” separates the sheet reference from the cell reference. The “:” between the first and third sheet says itshould include all the sheets between Sheet1 and Sheet 3. The “:” between the first and the third cell says it should include all the cells between B1 and B3. t Pivot Table - an interactive table enabling you to quickly group and summarize large amounts of data.
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 t Example: Interest = 8% Annually Loan Amount = $150,000 Loan Term = 30 years t To find Monthly Payment t Monthly Rate = .08/12 (convert to monthly) = 0.0066667
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 02/27/2011 for the course ISQS 2340 taught by Professor Staff during the Spring '08 term at Texas Tech.

Page1 / 3

Excel Notes - Relative reference when the fill handle is...

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