Formulae Flashcards
all about formulae
1
Q
What is a Formula
A
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.
2
Q
Example of a Simple Formula
A
To add the values in cells A1 and B1:
=A1 + B1
3
Q
Example of a Complex Formula
A
To calculate the average of cells A1 to A10 and then add 5:
=AVERAGE(A1:A10) + 5
4
Q
Difference Between a Formula and a Function
A
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.
