intro - Introduction to Excel Functions and Templates In...

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

View Full Document Right Arrow Icon
Introduction to Excel Functions and Templates In Excel, a function is a predefined or built-in formula for a commonly used calculation. Each function has a name and a Syntax. Syntax Syntax is the rule a function follows, using the following format: =FUNCTION(argument1,argument2,argument3) a. the name of the function goes in place of “FUNCTION” b. an “argument” is the cell reference, value, or text reference required by the function to perform a calculation. c. a comma is used to separate the arguments in the function. eg. =PMT(rate,nper,pv,fv,type) or =PMT(B3,B4,B5,0,0) Range A Range of cells is used in some functions for its calculation. A Range is denoted by the use of a colon ( : ) between the cell references. To select the cells starting at B5 and continuing to cell B10 inclusive, the entry would be B5:B10. eg. =AVERAGE(range of cells) or =AVERAGE(B5:B10) Function Dialog Box The function dialog box guides the user in selecting the correct arguments required by the function. The cell references can be typed in to each argument’s field. At the right of each
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/22/2009 for the course MATH 1101 taught by Professor Tonycirusolo during the Fall '05 term at Niagara College.

Page1 / 2

intro - Introduction to Excel Functions and Templates In...

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

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