{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel Notes

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

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

1 triangle45right Relative reference – when the “fill handle” is dragged and formulas change automatically adjusting for the new position. triangle45right Absolute reference – when the “fill handle” is dragged the same cell reference is kept where a “\$” is added. triangle45right 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. triangle45right Pivot Table - an interactive table enabling you to quickly group and summarize large amounts of data.

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

View Full Document
2 triangle45right Example: Interest = 8% Annually Loan Amount = \$150,000 Loan Term = 30 years triangle45right
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online