0
This is far too broad a question to be answered fully. To see a list of all Excel functions just type the word 'function' into MS Excel Help and you will get a list of all of them.
Basically a function is a device that does calculations Behind the Scenes and shows the result in a particular cell. For example, if you have a series of figures in column D, starting at row 4 and ending at row 24 and you want them all to be added together with the result shown in cell D25, you would enter this formula in that cell:
=SUM(D4:D24) - the function in this case is SUM and this is probably the most commonly used Excel function.
The next most common function is the IF function - if a certain set of circumstances exists do one thing and if it doesn't, do another thing. For example, =IF(B4="","",1) which means, "If cell B4 is blank do nothing, but if it isn't blank enter the number 1 in the current cell.
See related links for a list of Excel functions.
You can create calculations in Excel
eg =b1+b2+b3
or =sum(b1:b3) to add the values in these three cells
Sum is one of hundreds of Excel functions to fulfilparticular calculation types
eg =average(range) mean average value try also MAX MIN COUNT which will give yo the largest, smallest and nmber of entries in a range
A function is a pre-defined formula that comes built into Excel which you can use in your own formulas.
=SUM(A2:A23)/150 This function adds the contents in A2 through A23, and then divides the result by 150.
=MAX(G3:G23) This function displays the highest number found in cells G3 through G23.
Like what it is used for? It is a speadsheet. It is used for a lot of different things. It is also a calculater.
Wiki User
∙ 6y ago
Wiki User
∙ 13y agoA "Function" in Microsoft Excel is a pre-defined formula used to performing common operations.
There are about 250 functions in Excel, depending on the version. They range from the simple such as "=Sum()" and "=Average()" to Bessel functions and stuff I've never heard of. The Help files in Excel are remarkably complete, but don't explain WHY a function might be used; it presumes that you know what the function is SUPPOSED to do. One of the nicest features is the "Function Wizard". which will walk you through the process of using most functions.
Wiki User
∙ 6y agoA formula is an instruction in a spreadsheet to carry out some activity, normally a calculation. A formula must begin with the equals sign. Formulas can be simple or complex and they are built by the user. A very simple example of a formula which would add values in two different cells would be:
=A1+A2
A function is a pre-defined formula that is built into the spreadsheet program and can be used as a formula or as part of a formula. There are many such functions, the most commonly used one being the SUM function, which allows you to quickly add up values in a range of cells. To add all the values from all the cells from cell A1 to A15 would be done with the SUM function in a formula like this:
=SUM(A1:A15)
See the related questions below.
A formula is an instruction that tells the computer to work out the answer for the values entered. A formula is like a mathematical equation. All formulae in Microsoft Excel must begin with an equal sign (=).
Wiki User
∙ 14y agoA "Function" in Microsoft Excel is a pre-defined formula used to performing common operations. There are about 250 functions in Excel, depending on the version. They range from the simple such as "=Sum()" and "=Average()" to Bessel functions and stuff I've never heard of.
The Help files in Excel are remarkably complete, but don't explain WHY a function might be used; it presumes that you know what the function is SUPPOSED to do. One of the nicest features is the "Function Wizard," which will walk you through the process of using most functions.
Wiki User
∙ 14y agoHere are the Math and Trig functions:
ABS
ACOS
ACOSH
ASIN
ASINH
ATAN
ATAN2
ATANH
CEILING
COMBIN
COS
COSH
DEGREES
EVEN
EXP
FACT
FACTDOUBLE
FLOOR
GCD
INT
LCM
LN
LOG
LOG10
Wiki User
∙ 13y ago- DATE - Returns the serial number of a particular date
- DELTA - Tests whether two values are equal
- HOOKUP - Looks in the top row of an array and returns the value of the indicated cell
- PMT - Returns the periodic payment for an annuity
- PROPER - Capitalizes the first letter in each word of a text value
Wiki User
∙ 13y agoExcel function are programmed commands for various calculations.
Wiki User
∙ 10y agoSUM
MIN
MAX
AVERAGE
COUNT
Herode Mezidor
Add your answer:
Earn +20 pts
MAX MIN COUNT and SUM are examples of what?
They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.
What is the function of percentage in micro-soft Excel?
functions of excel
What is in an expression?
In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.
What is an expression in excel?
In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.
How many functions can be nested with the same formula in MS Excel?
Excel 2003 = 8 levels of nesting Excel 2007 = 64 levels of nesting
Why is there a need to know what functions are in creating formulas in Microsoft Excel?
Functions are basically built-in formulas in Excel. They are used extensively in Excel, so it is very important to know how to use them.
Give 5 functions of formulas in Excel?
Built-in formulas in Excel are known as functions. Here are five common ones: SUM AVERAGE COUNT MIN MAX
What is it called when you have IF functions in Excel?
They are often used for when Excel is doing what is called What-If Analysis.
What are the 20 function in excel?
It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.
What are Excel's prewriten formulas called?
functions
In Excel MAX and AVERAGE are examples of what?
Functions.
In Excel what are prewritten formulas designed to compute statistics called?
Statistical Functions See related links for a list of statistical functions available in Excel.
