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

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
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

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