Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
6 views
in Data Science by (55.6k points)

A) SUM

B) AVG

C) MAX

3 Answers

0 votes
by (45.3k points)

The correct answer to the question “Which one is not a function in MS Excel” is option (b). AVG. There is no function in Excel like AVG, at the time of writing, but if you mean Average, then the syntax for it is also AVERAGE and not AVG. The other two options are correct. If you are interested in learning more about MS Excel, I suggest you take up Intellipaat’s Advanced Excel courses. And become a qualified and certified professional. Want a visual aid in better understanding the concepts of MS Excel? Watch the following video on Excel Basics for Beginners.

0 votes
by (140 points)

B) AVG There is  no function in  excel like AVG, at the time of writing, but if you mean Average, then the syntax for it is also AVERAGE and  not AVG.

0 votes
by (220 points)
AVG a function in ms excel

Related questions

0 votes
1 answer
asked Feb 14, 2020 in BI by anmolj (9k points)

1.2k questions

2.7k answers

501 comments

693 users

Browse Categories

...