# Spreadsheet Functions

## Functions

A function is a predefined formula provided by a spreadsheet application.

Functions are written in the following format:

=FunctionName(parameter1, parameter2, …, parameterN)

e.g

=sum(e3, d4, r5),

=max(a5,a27,b44)

=SUM(D3,D4,D5,F3:F4)

a function with a single parameter is shown below:

=FunctionName(parameter)

e.g.

=SUM(F3:F4)  (note this is 1 parameter, a range)

=ABS(-44)

Note that a function’s  actions can be accomplished with a formula:

e.g =SUM(D3:F3) becomes =D3+E3+F3

Absolute addressing – prevents a cell’s row number or column letter from being updated when a formula is copied to another cell.

e.g          \$C4        – prevents the column letter from being updated

C\$4        – prevents the Row number from being updated

\$C\$4      – prevents both column letter and row number from being updated.

Secret tip!!!!!!!!  – use F4 to set a cell’s address to absolute addressing.

## Class Demo

Download the excel file here:

https://drive.google.com/file/d/1NNSBoalQj278kbyctaYaaw5M1OII8tto/view?usp=sharing

## Homework:

Give examples of the following functions:

Sum, average, max, min , count, counta, countif , date , if

© 2019  Vedesh Kungebeharry. All rights reserved.