answersLogoWhite

0

What are the function in excel?

User Avatar

Anonymous

9y ago
Updated: 5/29/2022

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.

What else can I help you with?

Related Questions

What is the step function of Microsoft Excel?

There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.


A formula prewritten by excel is called?

Function


In excel 2013 where are the various function categories stored on the Ribbon?

In Excel Where are the various function categories stored on the Ribbon?


Does the uplookvert function in Excel exist?

There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.


What is the function of percentage in micro-soft Excel?

functions of excel


An If function within an if function in Excel is called what?

A nested if.


How does the trig function ACOS work in Excel?

In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000


How do you make a box plot in Excel?

Excel does not have a native BOXPLOT function, but you can replicate the function by following the instructions in the related links.


What is a function reference in Excel?

A function can reference cells or named ranges in the function.


Can you enter a function in Excel using autocomplete?

You can use the clipboard in Excel. It is a facility as opposed to a traditional function, like the SUM function or AVERAGE or MAX and other functions that are built in to Excel.


Which formula prewritten by excel?

function


What is quartile Excel function?

There is no function to create a quartile in Excel. A quartile is a 25% division of a statistical collection of data. You can use Excel to create a chart to let you observe the quartiles of the data.