Excel.03

# Excel.03 - COMPREHENSIVE Excel Tutorial 3 Working with...

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

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

View Full Document

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

View Full Document

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

View Full Document

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: COMPREHENSIVE Excel Tutorial 3 Working with Formulas and Functions 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 New Perspectives on Microsoft Office Excel 2007 2 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 New Perspectives on Microsoft Office Excel 2007 3 Using Relative References New Perspectives on Microsoft Office Excel 2007 4 Using Absolute References New Perspectives on Microsoft Office Excel 2007 5 Using Mixed References New Perspectives on Microsoft Office Excel 2007 6 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 New Perspectives on Microsoft Office Excel 2007 7 Understanding Function Syntax • Every function has to follow a set of rules, or...
View Full Document

## This note was uploaded on 03/27/2008 for the course IT 41 taught by Professor Clayton during the Spring '08 term at Drake University .

### Page1 / 28

Excel.03 - COMPREHENSIVE Excel Tutorial 3 Working with...

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

View Full Document
Ask a homework question - tutors are online