Advanced formulae – Spreadsheets

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

Hold shift and press the plus sign

The hyphen: –

Hyphen Key

The asterisk : *

Asterisk key

The front slash: /

Front slash key.


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:

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:

Advanced formulae tutorial

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.

Video Tutorial

Updated 2021 November 8th

-Fixed a spelling error

-Improved formatting

-Added Tutorial Video

© 2020  Vedesh Kungebeharry. All rights reserved. 

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:

Max and Min






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.

© 2020  Vedesh Kungebeharry. All rights reserved. 

Spreadsheets: Introduction, definition & terminology

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. (

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.