The following video picks up from our last class here.

© 2021 Vedesh Kungebeharry. All rights reserved.

Skip to content
# Tag: spreadsheets

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

# Advanced formulae – Spreadsheets

##### Addition

##### Subtraction

##### Multiplication

##### Division

## Tutorial:

### How to fill the sheet:

### Homework

## Video Tutorial

### Updated 2021 November 8th

# Formulas and Functions – Part 2 (Video)

## Max and Min

## Count

## Countif

## Rank

## Vlookup

## PMT

# Formulas and Functions – Part 1 (Class Video)

# Spreadsheets: Introduction, definition & terminology

## Terminology

The following video picks up from our last class here.

© 2021 Vedesh Kungebeharry. All rights reserved.

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 : *

The front slash: /

Click the link below to download the file. Do not open the documents using Google Sheets, rather download the documents and open it with your desktop application of Microsoft Excel:

https://drive.google.com/file/d/1lubYKdD70AAx_9eD2BeoBb8FbjKcd9Wq/

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.

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.

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

-Fixed a spelling error

-Improved formatting

-Added Tutorial Video

© 2020 Vedesh Kungebeharry. All rights reserved.

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:

Homework – Research/examine the PMT function.

Explain :

- The functions’ parameters.
- The purpose of the function.

**We will be discussing this function at our next class.**

© 2020 Vedesh Kungebeharry. All rights reserved.

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:

© 2020 Vedesh Kungebeharry. All rights reserved.

See the video below which introduces spreadsheet software

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.

Oxford English Dictionary via google. (https://www.google.com/search?q=define+spreadsheet&oq=define+spreadsheet&aqs=chrome..69i57j0l7.4183j1j7&sourceid=chrome&ie=UTF-8)

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)

© 2020 Vedesh Kungebeharry. All rights reserved.