Back
A) SUM
B) AVG
C) MAX
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.
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.
31k questions
32.8k answers
501 comments
693 users