Question

write the name of any 4 function present in the ms excel with their syntax and example

Answer 1

mathematical function
paste special function
date/time function
text function
logical function

Answer 2

Average

AverageTo calculate the average of a group of numbers, use the AVERAGE function.

AverageTo calculate the average of a group of numbers, use the AVERAGE function.Averageif

AverageTo calculate the average of a group of numbers, use the AVERAGE function.AverageifTo average cells based on one criteria, use the AVERAGEIF function. For example, to calculate the average excluding zeros.