USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In Excel, which of the following is NOT a function?
|
|
Sum
|
|
|
Average
|
|
|
Add
|
|
|
Maximum
|
Explanation:
Detailed explanation-1: -Detailed Solution. The correct answer is “ALT".
Detailed explanation-2: -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.
Detailed explanation-3: -The MAX Function[1] is categorized under Excel Statistical functions. MAX will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value.
Detailed explanation-4: -Answer. Answer: AVG is not a function in MS Excel.
There is 1 question to complete.