meets Tuesday and Thursday from 0800-0915
office hours in Manning 112
Class Schedule
10 Jan | intro
15 Jan | clients
17 Jan | servers
22 Jan | networks
24 Jan | basics lab
29 Jan | structural layer
31 Jan | presentational layer
05 Feb | working with layers
07 Feb | behavior layer
12 Feb | images & design
14 Feb | website lab
19 Feb | document markup
21 Feb | graphics
26 Feb | document markup lab
28 Feb | spreadsheets
05 Mar |
formulas |
functions |
all functions |
practice exercises |
next session
07 Mar | data display
19 Mar | database tools
21 Mar | spreadsheets lab
26 Mar | relational databases
28 Mar | tables
02 Apr | relationships
04 Apr | input & output
09 Apr | SQL
11 Apr | complex queries
16 Apr | databases lab
18 Apr | presentation design
23 Apr | presentation delivery
25 Apr | presentation lab
30 Apr | 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 same is true in Excel for Mac
=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
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 & Function Name plus a short explanation of what the function does.
The same is true in Excel for Mac