# Reviewing Functions – Max,Min,Sum and Introducing average

The following video picks up from our last class here.

In this tutorial, we seek to use the basic arithmetic operations addition subtraction multiplication and division to accomplish complex tasks.

Usually when using a computer system to represent addition subtraction multiplication and division we use the following symbols respectively:

The plus sign : +

The hyphen: –

The asterisk : *

##### Division

The front slash: /

## Tutorial:

This tutorial demonstrates how a spreadsheet can be used to perform a complex calculation. The complex calculation chosen is the quadratic formula.

Note that you do not need to have an intimate understanding of the quadratic formula. All you will need to do is to break down the quadratic formula into its sub parts, and represent those parts using functions and formulas in your spreadsheet software.

This Excel document contains two worksheets. Use the first worksheet to fill in formulas and functions which can be used to calculate the items shown in the labels.

### How to fill the sheet:

A copy of the sheet is shown below:

Start filling in the correct formula for each level shown in the sheet. For example, you would start with the label negative B an insert a formula in the cell next to the label which would calculate the volume negative B. In this case you would enter =-1*C10 Into cell location H3.

Continue following all the way down for b squared, 4ac …. All the way until you have calculated root 1 and root 2.

The second sheet contains notes and solutions to the first worksheet.

### Homework

Complete the challenge listed in the sheet above. Ensure that you do not use any pre-calculated values.

## Video Tutorial

### Updated 2021 November 8th

-Fixed a spelling error

-Improved formatting

# Formulas and Functions – Part 2 (Video)

This series of videos is a continuation of the post, Formulas and Functions – Part 1 (Class Video)

Use this file and follow along with the videos, pausing the video when you need to accomplish a task:

It 5 videos covering the following functions: Max, Min, Count, Countif, Rank, and Vlookup.

A 6th function, PMT was left for your research and homework.

See the videos below, and follow the instructions for homework based on the pmt function:

## PMT

Homework – Research/examine the PMT function.

Explain :

1. The functions’ parameters.
2. The purpose of the function.

We will be discussing this function at our next class.

# Formulas and Functions – Part 1 (Class Video)

This is a recording of class made on the 8th october 2020. This video demonstrates skills that were learnt and practised in class. Use this video for review, skip through parts that are not relevant to you , just pay attention to the skills!

The video below was captured during a repeat of the class above. FYI:

# Spreadsheets: Introduction, definition & terminology

See the video below which introduces spreadsheet software

## Terminology

Spreadsheet – an electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.

A Spreadsheet consists as a grid of many cells.

Cell – A single location in a spreadsheet that can store data. It is the intersection of a row and column

row – A horizontal arrangement of cells , usually denoted by a number

column – a vertical arrangement of cells ,usually denoted by a letter, cell,

value – the data that is stored in a cell.

formula – a representation for a calculation stored within a cell. The formula itself is not displayed, rather, the results of the calculation is displayed in the cell.

range – a group of cells; can be a group of horizontal cells, a group of vertical cells, a block of cells, or even many different blocks of cells.

worksheet – a single spreadsheet in a workbook.

workbook – a file , consisting of many worksheets (individual spreadsheets). A workbook is a file which is comprised of 1 or more worksheets (spreadsheets)

(last updated Monday 11th January 2021)