Question

which among the following is not part the syntax for AVERAGEIF

Answer 1

logical test

Explanation:

• AVERAGEIF is a type of function which is available in Microsoft Excel.
• Microsoft Excel is a type spreadsheet application which is developed by Microsoft.
• Microsoft Excel is also called as MS - Excel.
• The function AVERAGEIF, returns the average or arithmetic mean of the cells in given range which meet a criteria.
• The syntax of AVERAGEIF is                                                 AVERAGEIF(range, criteria, [average_range]).
• The AVERAGEIF contains range, criteria and average_range. But it does not have logical test.

Therefore, logical test is not a part of the syntax of AVERAGEIF.