Tools for Information Literacy

Functions

---

Functions are built-in specialized algorithms

They can apply to an individual cell or to a range of cells, on the same spreadsheet,
or on another worksheet in the same workbook,
or on another worksheet in another workbook.

Excel formulas: The most popular functions and tools, with examples

What is a function? components examples decision tools common functions help with functions

back to top

Functions have three parts

1. the = sign which tells Excel that a formula or function follows
2. the function name such as SUM for addition or AVERAGE for determining the average of a series of numbers
3. the cells on which the particular function operates must be enclosed by parentheses, and it contains the cell references so that the function knows which cells to calculate
4. this naming logic is very similar to what we have seen before where a function is applied to a range of cells

options for entering functions (or formulas, as well) into the spreadsheet

1. in the formula bar
2. directly into the cell
3. use the name box
4. OR use the Function Wizard to help you create the desired results

The same is true in Excel for Mac

What is a function? components examples decision tools common functions help with functions

back to top

Examples of functions

• =SUM(D4,I48,V65)
• =AVERAGE(D1:D18)

Functions can perform mathematical operations on a group of cells

=SUM(D4:D7)
means
equalsadd togetherthe contents ofcells D4 through D7
or
equalsD4+D5+D6+D7

For argument of function:

if individual cells, use commas

=SUM(D2,D3,D5)
means
equalsaddD2 and D3 and D5

if a range of cells, use a colon

= SUM(F2:F4,F7:F17)
means
equalsaddF2 through F4 and F7 through F17together

What is a function? components examples decision tools common functions help with functions

back to top

Tools to help decide on the function to use

Insert Function or fx function wizard or hit = and then the function draw down box. The Function dialog box has Function Category and Function Name plus a short explanation of what the function does.

The same is true in Excel for Mac

What is a function? components examples decision tools common functions help with functions

back to top

Common Functions include:

• SUM
• AVERAGE and MEDIAN
• COUNT, COUNTA, and COUNTIF
• MAX and MIN
• NOW()
• ROUND
• VLOOKUP and XLOOKUP

What is a function? components examples decision tools common functions help with functions

back to top

Microsoft offers online help for all classes of functions available in MSExcel.

Links to help on all available functions

Functions - alphabetically

Functions by category

Create Custom Functions in Excel 2007+

What is a function? components examples decision tools common functions help with functions

back to top