Notes for Lab 2

# Notes for Lab 2 - formula is filled down a column the cell...

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

Notes for Lab 2 Defining Names: 1) Select cell 2) Formulas tab 3) Define name Using defined named cells in formulas 1) Type = sign 2) Formulas tab 3) Use in formulas 4) Select name Absolute vs Relative Cell REferences If the column reference of a cell is made absolute (e.g. \$F10) then when a formula using such a reference is filled across a row the cell referred to remains constant, but if the formula is filled down a column the cell referred to changes (to \$F11, \$F12 etc). Make sure you understand this point by experimenting with it. If the row reference of a cell is made absolute (e.g. F\$10) then when a formula using such a reference is filled across a row the cell referred to changes (to G\$10, H\$10 etc), and if the

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.

Unformatted text preview: formula is filled down a column the cell referred to remains constant. • If both the row and column reference of a cell are made absolute (e.g. \$F\$10) then the cell referred to remains constant regardless of the fill down or fill across operation. =D2*Tax_Rates!\$B\$3 Fill a Series 1) Click first cell in column (series) 2) Home tab 3) Editing cell section 4) Fill 5) Series 6) Specify step value Move Chart 1) Chart tools/design tab 2) Move chart Changing shape of line (e.g. dashed) on a graph 1) Select line 2) Chart tools/format tab 3) Shape outline drop down list...
View Full Document

{[ snackBarMessage ]}

### Page1 / 2

Notes for Lab 2 - formula is filled down a column the cell...

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

View Full Document
Ask a homework question - tutors are online