Give any three examples of built in functions

Examples of built-in functions in Microsoft Excel:

Here are three examples of built-in functions in Microsoft Excel:

SUM: The SUM function adds up a range of numbers.

Example: =SUM(A1:A10)

This formula adds up the values in cells A1 through A10.

 

AVERAGE: The AVERAGE function calculates the average of a range of numbers.

Example: =AVERAGE(B1:B10)

This formula calculates the average of the values in cells B1 through B10.

 

 IF: The IF function checks a condition and returns one value if true and another value if false.

Example: =IF(C1>10,”Greater than 10″,”Less than or equal to 10″)

This formula checks if the value in cell C1 is greater than 10. If true, it returns the text “Greater than 10”, otherwise it returns “Less than or equal to 10”.

These are just a few examples of the many built-in functions available in Microsoft Excel.

Share this:

Leave a Comment