Functionality

                Well here’s the easiest part in solving mathematical formulas.  Using functions instead of formulas.  Imagine if you would want to add all the numbers in column A, and you are using formulas.  Well that would be very tiring.  For example:  =A1+A2+A3+A4+A5+… That is very unpractical.  That is one of the reasons that functions are commonly used instead of formulas.  Some examples that our teacher told us are:

·         =SUM(A1:A5)

·         =PRODUCT(A1:A5)

·         =QUOTIENT(A1,A2)

       For using subtraction, the function is the same as addition but instead of subtracting positive numbers, try adding negative numbers.