ITM 215 Class 16 Mar 18

ITM 215 Class 16 Mar 18 - ITM 215 Computer Applications in...

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

View Full Document Right Arrow Icon
ITM 215:   Computer  Applications in  Business
Background image of page 1

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

View Full Document Right Arrow Icon
 7/6/2007  New Perspectives  Copy formulas Build formulas containing relative,  absolute, and mixed references Review function syntax Insert a function with the Insert  Function dialog box Search for a function 2 Objectives
Background image of page 2
 7/6/2007  New Perspectives  Use AutoFill to fill in a formula and  complete a series Enter the IF logical function Insert the date with the TODAY function Calculate monthly loan payments  with  the PMT financial function 3 Objectives
Background image of page 3

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

View Full Document Right Arrow Icon
 7/6/2007  New Perspectives  4 In A Flash Review, Absolute, IF
Background image of page 4
 7/6/2007  New Perspectives  When Copying Cells, the  References in Formulas are  Automatically Adjusted for  the New Location 5 Relative Cell 
Background image of page 5

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

View Full Document Right Arrow Icon
 7/6/2007  New Perspectives  6 Using Relative 
Background image of page 6
 7/6/2007  New Perspectives  When Copying Cells, the  Row Designation or the  Column Designation or  Both Remain Fixed 7 References
Background image of page 7

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

View Full Document Right Arrow Icon
 7/6/2007  New Perspectives  8 Using Absolute 
Background image of page 8
 7/6/2007  New Perspectives  9 Using Mixed References
Background image of page 9

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

View Full Document Right Arrow Icon
 7/6/2007  New Perspectives  To enter a relative reference, type the  cell  reference as it appears in the  worksheet. For example, enter B2 for  cell B2 To enter an absolute reference, type $  (a  dollar sign) before both the row  and  column references. For example,  10 Entering Relative,  Absolute, and Mixed 
Background image of page 10
 7/6/2007  New Perspectives  Select the cell reference you want to  change Press the F4 key to cycle the reference  from relative to absolute to mixed  and then back to relative 11 Entering Relative,  Absolute, and Mixed 
Background image of page 11

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

View Full Document Right Arrow Icon
 7/6/2007  New Perspectives  Absolute reference:  remains  constant throughout a copy  operation Specified with a dollar sign before the  column and row, i.e. $B$4 Relative reference: adjusts during a  copy operation Specified without dollar signs, i.e. B4 Mixed reference:  either the row or  12 Cell Referencing
Background image of page 12
 7/6/2007  New Perspectives  Absolute Reference Mixed References F4 Key 13 Show Examples of  Absolute and Relative
Background image of page 13

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

View Full Document Right Arrow Icon
 7/6/2007  New Perspectives 
Background image of page 14
Image of page 15
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 47

ITM 215 Class 16 Mar 18 - ITM 215 Computer Applications in...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online