preps | spreadsheets | formulas | functions

Value Added | daily

**Class Schedule**

Basics | sessions 01-03

- 19 Jan intro and clients | lecture | labs
- 26 Jan servers and command line | lecture | labs
- 02 Feb networks and protocols | lecture | labs

Web Development | sessions 04-08

- 09 Feb structural layer | lecture | labs
- 16 Feb presentational layer | lecture | labs
- 23 Feb using a structure | lecture | labs
- 02 Mar behavioral layer | lecture | labs
- 09 Mar design thoughts | lecture | labs

Dealing with Markup | sessions 09-10

Working with data | sessions 11-14

- 30 Mar formulas, functions, vectors | lecture | labs
- 06 Apr data display | lecture | labs
- 13 Apr manipulate data sets | lecture | labs
- 20 Apr relational data bases | lecture | labs

Presentations | sessions 15-16

This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.

home & schedule | syllabus | contact | grades

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

use the formula example for function demonstrations too

A formula starts with =, and is followed by mathematical operators and cell addresses

=D4+D5+D6+D7

means

equalsD4plusD5plusD6plusD7

A function is a predefined formula that performs a mathematical operation on a group of cells

=SUM(D4:D7)

means

equals add together
the contents ofcells D4 through D7

or

equalsD4+D5+D6+D7

- the = sign which tells Excel that a formula or function follows
- the function name such as SUM for addition or AVERAGE for determining the average of a series of numbers
- 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
- this naming logic is very similar to what we have seen before where a function is applied to a range of cells

- in the formula bar
- directly into the cell
- use the name box
- OR use the Function Wizard to help you create the desired results

The same is true in Excel for Mac

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

=SUM(D4:D7)

means

equalsadd togetherthe contents ofcells D4 through D7

or

equalsD4+D5+D6+D7

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

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

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

30 March lecture | preps | spreadsheets | formulas | functions