Question

Give the syntax and example of any three mathematical functions in spreadsheet

Answer 1

Answer:

Mathematical functions provide some of Excel's most basic functionality, allowing you to perform various operations like sums and averages.

Excel's SUM function. ...

Cumulative SUM in Excel. ...

Using SUMPRODUCT in Formulas. ...

Using the AVERAGE formula in Excel. ...

Finding a Weighted Average in Excel.

..

Answer 2

the 3 examples of the mathematical function in a spread sheet are :

1. function - SUM

  syntax --- =SUM(number1,numver2,............)

  use --- adds the value contained in a range of cells

2. function -- AVERAGE

   syntax ---- =AVERAGE(number1,numver2,............)

    use ---- finds out the average of the values contained in a range of cell

3. function ---- MAX

   syntax ---- =MAX(number1,numver2,............)

    use ---- finds out the largest value contained in a range of cell