SILS iSchool

05 Mar 2019

meets Tuesday and Thursday from 0800-0915

in Carolina Hall 220

Contact options

office hours in Manning 112


Value Added | daily

Class Schedule

Basics | sessions 01-05

10 Jan | intro
15 Jan | clients
17 Jan | servers
22 Jan | networks
24 Jan | basics lab

Web Development | sessions 06-11

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

Document Markup | sessions 12-14

19 Feb | document markup
21 Feb | graphics
26 Feb | document markup lab

Spreadsheets | sessions 15-19

28 Feb | spreadsheets
05 Mar | formulas | functions | all functions | practice exercises | next session
07 Mar | data display

 09-17 Mar | Spring Break 

19 Mar | database tools
21 Mar | spreadsheets lab

Relational Database | sessions 20-26

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

Presentation | sessions 27-30

18 Apr | presentation design
23 Apr | presentation delivery
25 Apr | presentation lab
30 Apr | 0800-1100 | final in class presentation





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

back to top

Formula

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

For example:

=D4+D5+D6+D7
means
equalsD4plusD5plusD6plusD7

back to top

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

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

back to top

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
[MSExcel 2014 displaying a power function]

The same is true in Excel for Mac

[MSExcel 2013 displaying a power function]

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 of cells 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

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

[MSExcel 2007+ find function dialog box]

The same is true in Excel for Mac

[MSExcel 2013 find function dialog box]

back to top

Common Functions include:

back to top