Ch3_IntroExcelFxns_sp10a

Ch3_IntroExcelFxns_sp10a - Click to edit Master subtitle...

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style Excel Functions Chapter 3 11
Background image of page 1

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

View Full DocumentRight Arrow Icon
What is a function? In any environment, it is a predefined formula that performs some calculation or manipulation. accepts one or more inputs returns exactly one output The action of a function is like a “black box” To use a function, we need not know how it performs its work, we need only to know what it does. 22
Background image of page 2
Excel Functions An Excel function is defined By its name in combination with its argument list Two different functions may actually have the same name, but different input list. Example of two functions with same name, different arguments: LOOKUP(lookup_value, lookup_vector, result_vector) 33
Background image of page 3

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

View Full DocumentRight Arrow Icon
Excel? The function is “called” from: Within a worksheet formula A worksheet cell Another function Supplies an argument to another fxn. the VBA programming environment
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/22/2011 for the course ACIS 2504 taught by Professor Mtgriffin during the Spring '08 term at Virginia Tech.

Page1 / 15

Ch3_IntroExcelFxns_sp10a - Click to edit Master subtitle...

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

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