Question

state the formulas for the calculation function in the excel sheet


UF YOU SAY CORRECT I WILL MAKE YOU BRAINLIEST
​

Answer 1

Answer:

Some of the basic formulas are Sum, Average, Count, min, Max, Text Function , VLOOKUP Function, IF.

Step-by-step explanation

     1.The Excel MIN function returns the smallest numeric value in a range of values. The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values. Get the smallest value.

      2.The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values TRUE and FALSE, and text values. Get the largest value.

     3.The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.

     4.The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.

    5.The formula to find the average of given numbers or values is very easy. We just have to add all the numbers and then divide the result by the number of values given. It can be expressed as: Average = Sum of Values/ Number of values.

     6.The sum function is the most used function when it comes to computing data on Excel. This function works to sum a group of numbers in a specific set of cells. This means you don’t need to type a long cumbrous formula just to calculate the sum of all the data you need. Because of its popularity, newer versions of Microsoft Excel have a button specifically for this function.

     8. HOPE IT HELPS U

         PLEASE MARK MY ANSWER AS THE BRAINLIEST.