SILS iSchool

30 March 2021

Value Added | daily

Class Schedule

Basics | sessions 01-03
  1. 19 Jan intro and clients | lecture | labs
  2. 26 Jan servers and command line | lecture | labs
  3. 02 Feb networks and protocols | lecture | labs
Web Development | sessions 04-08

  1. 09 Feb structural layer | lecture | labs
  2. 16 Feb presentational layer | lecture | labs
  3. 23 Feb using a structure | lecture | labs
  4. 02 Mar behavioral layer | lecture | labs
  5. 09 Mar design thoughts | lecture | labs
Dealing with Markup | sessions 09-10
  1. 16 Mar control objects and display | lecture | labs
  2. 23 Mar tools that read markup | lecture | labs
Working with data | sessions 11-14
  1. 30 Mar formulas, functions, vectors | lecture | labs
  2. 06 Apr data display | lecture | labs
  3. 13 Apr manipulate data sets | lecture | labs
  4. 20 Apr relational data bases | lecture | labs
Presentations | sessions 15-16
  1. 27 Apr designing a presentation | lecture | labs
  2. 04 May delivering a presentation | lecture | labs

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

Excel formulas: The most popular functions and tools, with examples

use the formula example for function demonstrations too

back to top


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

For example:


back to top


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

For example:

equals add together the contents ofcells D4 through 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

equalsadd togetherthe contents ofcells D4 through D7

For argument of function:

if individual cells, use commas

equalsaddD2 and D3 and D5

if a range of cells, use a colon

= SUM(F2:F4,F7:F17)
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 and 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

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

back to top

30 March lecture | preps | spreadsheets | formulas | functions