## 17 Oct 2018

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

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

22 Oct | data display
18 Oct | Fall Break
24 Oct | database tools

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

## School Information

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.

### Functions are built-in specialized algorithms

use the formula example for function demonstrations too

### Formula

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

#### For example:

=D4+D5+D6+D7
means
equalsD4plusD5plusD6plusD7

### Function

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

#### For example:

=SUM(D4:D7)
means equalsadd together the contents of cells D4 through D7
or equalsD4+D5+D6+D7

### 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 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
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 formulas 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

### 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 of cells D4 through D7
or equalsD4+D5+D6+D7

#### For argument of function:

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