ITM 215 Class 16 Mar 18

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

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

ITM 215:   Computer  Applications in  Business

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

View Full Document
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
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

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

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

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

View Full Document
7/6/2007  New Perspectives  6 Using Relative
7/6/2007  New Perspectives  When Copying Cells, the  Row Designation or the  Column Designation or  Both Remain Fixed 7 References

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

View Full Document
7/6/2007  New Perspectives  8 Using Absolute
7/6/2007  New Perspectives  9 Using Mixed References

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

View Full Document
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
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

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

View Full Document
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
7/6/2007  New Perspectives  Absolute Reference Mixed References F4 Key 13 Show Examples of  Absolute and Relative

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

View Full Document
7/6/2007  New Perspectives
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
Ask a homework question - tutors are online