Question

Explain these function with syntax and example?a) sum b)average c) max d) round e)today ok class 8 book is computer

Answer 1

Here is your answer
1.Sum - it adds up the values given as parameters in the function. Syntax: = sum(D5;E5;F5)
2.average- it calculates the average of the values given as parameter in the function.Syntax: = average(D5:D11)
3. Max- It returns the highest value from the list of values given as parameters .Syntax: =Max(D5:D6:D7)
4.Round- it rounds the numbers to the nearest decimal place.Syntax: = round(D5)
5.today - it shows the current date and time.Syntax : today()

Answer 2

Answer:

a) The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.

b) Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

c) The Microsoft Excel MAX function returns the largest value from the numbers provided. The MAX function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel.

d) A function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments. Number (required) is the value you want to round up.  If the Num_digits argument is 0, the function rounds the value up to the nearest integer.

Explanation: