=ROUND(AVERAGE(A1:A100),2)
The answer you may be looking for is a nested function, as one is inside another. ROUND is a math function and AVERAGE is a statistical function.
A function is a pre-written or built-in formula in Excel. There are many of them, all designed to do very specific tasks. The SUM function is one of the most common, making it easy to add a range of cells. See the related question below.
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.
Function
In Excel Where are the various function categories stored on the Ribbon?
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.
functions of excel
A nested if.
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
Excel does not have a native BOXPLOT function, but you can replicate the function by following the instructions in the related links.
A function can reference cells or named ranges in the function.
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.
function