The types of function in MS Excel.

In Microsoft Excel, there are different types of functions called predefined formulas and these include:

Average  what value would be returned based on the formula in cell a49  function

Minimum function

Sum function

Maximum function

Count function

What is a count function?

A count function is mainly used for calculating the number of entries in a cell or number field that meets a predefined value which was set by an end user.

In this scenario, “NP*” is the predefined value that was set and as such the value that would be returned based on the formula in cell A49 is 4 because A43, A44, A45, and A46 contain the value “NP.”

Read more on Brainly.com – https://brainly.com/question/26477134#readmore

Leave a Comment