Question

Explain the following formulas
•Compound formula
•Formula on text
•Autosum
•AVERAGE
•MAX
•MIN
•COUNT
•TODAY
pls answer......anyone knows??​

Answer 1

Answer:

Compound formula :- A chemical formula is an expression that shows the elements in a compound and the relative proportions of those elements. Water is composed of hydrogen and oxygen in a 2:1 ratio. The chemical formula for water is H2O.

Formula on text :- TEXT Formula converts a numeric value to text and display it in a specified format.

Autosum :- It is a Microsoft Excel and other spreadsheet program function that adds together a range of cells and displays the total in the cell below the selected range. For example, if you wanted to add the values of cells between A1 and A5, highlight cells A1 through A5 and click the AutoSum button (shown right).

Average:- Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

Max :- MAX will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value. Unlike MAXA function, the MAX function will count numbers but ignore empty cells, text, the logical values TRUE and FALSE, and text values.

Min:- The Microsoft Excel MIN function returns the smallest value from the numbers provided. The MIN function is a built-in function in Excel that is categorized as a Statistical Function.

Count :- Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.

Today:- The Excel TODAY function returns the current date, updated continuously when a worksheet is changed or opened. The TODAY function takes no arguments. You can format the value returned by TODAY using any standard date format. If you need current date and time, use the NOW function.