Formulae

Question 1

What is a Formula

Answer 1

A formula in a spreadsheet is an expression that calculates the value of a cell. Unlike functions, which are predefined, formulas are custom expressions created by the user.

Question 2

Example of a Simple Formula

Answer 2

To add the values in cells A1 and B1:
=A1 + B1

Question 3

Example of a Complex Formula

Answer 3

To calculate the average of cells A1 to A10 and then add 5:
=AVERAGE(A1:A10) + 5

Question 4

Difference Between a Formula and a Function

Answer 4

Formula and Function. Formulas are defined as a statement written by any user, either simple or complex whereas a function is a type of formula which is pre-defined.