Which of the following is Not a Statistical Function in Excel? - Compute Expert

Which of the following is Not a Statistical Function in Excel?


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> Excel Quiz >> Which of the following is Not a Statistical Function in Excel?





Question

Which of the following is not a statistical function in excel?
  1. =AVERAGE( )
  2. =COUNT( )
  3. =MIN( )
  4. =MAX( )
  5. =IF( )



Answer

E. =IF( )


Explanation

Statistical functions in Excel are the functions we can use to get results related to statistical processes and calculations.

You can see the list of statistical functions in excel by doing this if you want. Go to the Formulas tab on your excel ribbon and click the More Functions dropdown button there. Then, highlight the word “Statistical” from the dropdown choices by using your pointer.

Which of the following is Not a Statistical Function in Excel? - Screenshot of the Way to Access the Statistical Functions List in Excel

From the functions that are on that list, IF isn’t one of them. Thus, the correct answer choice for the question is E.

Go back to the Compute Expert's excel quiz page



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!




Follow our tutorial content also on


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2022 Compute Expert