Question

Give the syntax and an example of any three mathematical

functions used in a spreadsheet.​

Answer 1

Answer:

The syntax and example of any three mathematical functions in spreadsheet are as follows:

1. SUM(): This is a function which is used to add all the values within a range of cells.

Syntax: sum(cell address1: cell address2)

2.COUNT(): It is used to count the number of data.

Syntax: count(cell address1: cell address2)

3.AVERAGE(): This function is used to find the average of a given number of cells.

Syntax: average(number1, number2,.....).

Explanation: