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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
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

This note was uploaded on 12/15/2010 for the course CSE CSE 1520 taught by Professor Paul during the Spring '09 term at York University.

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 Right Arrow Icon
Ask a homework question - tutors are online