{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel.03

# Excel.03 - XP XP Excel Tutorial 3 COMPREHENSIVE Objectives...

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

XP COMPREHENSIVE Excel Tutorial 3

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

View Full Document
XP New Perspectives on Microsoft Office Excel 2007 Objectives 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 Type a function directly in a cell 22
XP New Perspectives on Microsoft Office Excel 2007 Objectives 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 mortgage payments with the PMT financial function 33

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

View Full Document
XP New Perspectives on Microsoft Office Excel 2007 Using Relative References 44
XP New Perspectives on Microsoft Office Excel 2007 Using Absolute References 55

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

View Full Document
XP New Perspectives on Microsoft Office Excel 2007 Using Mixed References 66
XP New Perspectives on Microsoft Office Excel 2007 Entering Relative, Absolute, and Mixed References 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, enter \$B\$2 To enter a mixed reference, type \$ before either the row or column reference. For example, enter \$B2 or B\$2 or 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 77

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

View Full Document
XP New Perspectives on Microsoft Office Excel 2007 Understanding Function Syntax Every function has to follow a set of rules, or syntax , which specifies how the function should be written Arguments 88
XP New Perspectives on Microsoft Office Excel 2007 Understanding Function Syntax 99

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

View Full Document
XP New Perspectives on Microsoft Office Excel 2007 Inserting a Function
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 28

Excel.03 - XP XP Excel Tutorial 3 COMPREHENSIVE Objectives...

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

View Full Document
Ask a homework question - tutors are online