Value Added | daily

**Class Schedule**

Basics | sessions 01-05

22 AUG | intro

27 AUG | clients

29 AUG | servers

05 Sep | networks

10 Sep | basics lab

Web Development | sessions 06-11

12 Sep | structural layer

17 Sep | presentational layer

19 Sep | working with layers

24 Sep | behavior layer

26 Sep | images & design

01 Oct | website lab

Document Markup | sessions 12-14

03 Oct | object layers

08 Oct | graphics

10 Oct | document markup lab

Spreadsheets | sessions 15-19

15 Oct | spreadsheets

17 Oct | formulas |
functions |
all functions |
practice exercises |
next session

22 Oct | data display

18 Oct | Fall Break

24 Oct | database tools

29 Oct | spreadsheets lab

Relational Database | sessions 20-26

31 Oct | relational databases

05 Nov | tables

07 Nov | relationships

12 Nov | input & output

14 Nov | SQL

19 Nov | complex queries

26 Nov | databases lab

21 Nov | Thanksgiving

Presentation | sessions 27-30

28 Nov | presentation design

03 Dec | presentation delivery

05 Dec | presentation lab

12 Dec | 0800-1100 | final in class presentation

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

home & schedule | class blog | 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.

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 equalsadd together
the contents of cells 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 argument 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 of cells D4 through D7

or equalsD4+D5+D6+D7

if individual cells, use commas

=SUM(D2,D3,D5)

means

equalsadd D2 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 & Function Name plus a short explanation of what the function does.

The same is true in Excel for Mac