EXCEL 2016 FUNCTIONS LIST HOW TO

It can also select the most likely range of cells in a column or row that you want to use as the argument, then enters them for you. To use AutoSum in Excel, go to the Editing group under the Home tab on the Ribbon.Īs you can see, you can use this tool to calculate the SUM, AVERAGE, COUNT, MAX, or MIN.ĪVERAGE is the average of all the values in the cells.ĬOUNT counts the number of cells that contain numbers. In other words, if we select sell E13 in the worksheet below, the AutoSum feature will add the numbers in the cells above it that are still in the same column. defines the AutoSum as a 'function in a spreadsheet program that inserts a formula in the selected cell that adds the numbers in the column above it.' Once again, we enter 'average of cells' in the 'Search for a Function field,' then click the Go button. To do this, we are going to click Insert Function on the Ribbon under the Formulas tab. We want the average sales for January displayed in D12. We want to determine the average sales for the month of January. As you can see, we've created a row for the average sales.

EXCEL 2016 FUNCTIONS LIST HOW TO

Now that you know how to insert a function, let's insert a function into an actual spreadsheet.Ĭlick Cancel to exit out of the Insert Function box – if you're following along – and take a look at our sample worksheet in the following snapshot. In the snapshot below, you can see what calculation it performs. In the Select a Function field, you can click on different functions to see what calculations they perform. We already clicked on 'AVERAGE'.

In the 'Select a Function' field, Excel provides a list of functions that relate to what you entered into the 'Search for a Function' field. In the Search for a Function section of the above dialogue box, you can type in a description of what type of function you want to use. We typed in Average of Cells. Click Go. The great thing about using functions in Excel is that you don't have to know the function to get started. All you have to know is what you want to do, such as average a column of numbers. When you click Insert Function, you'll see this dialogue box: You will also not worry on the accuracy of your worksheets since the program was able to condense your supposed to be long formulas in just a single word.To insert a function directly into a cell, click the cell where you want to insert the function. Next, go to the Formulas tab, then click Insert Function. The platform surely will make your job easier and faster. Knowing the ability of Excel’s basic functions, you can save lots of time and effort in making long and complicated formulas.

The answer will be shown in the cell you initially choose.

(Note: If Excel did not automatically select the cells you want, you can click and drag over the ones you do want to include.)

The cells that Excel thinks you want to calculate will be highlighted and the function will appear in the cell.

Click on the Auto Sum drop down button.

On the ribbon, go to the Editing group found on the Home tab.

Click on the cell where you want your answer be placed.

To use the Auto sum button, just follow the instructions enumerated below: Basically, their names define their purposes. These are SUM, AVERAGE, COUNT NUMBERS, MAX and MIN. There are five basic functions under the Auto Sum button. Take note that the content inside the brackets depends on the function being used. The structure of basic functionsĪ function begins with an equals sign (=), followed by the name of the function, then the details of the function enclosed in brackets. If you are dealing with these kinds of work, this article is for you! Excel’s basic functions are intended to help you deal with these stuffs. It would also be tedious to anyone of us to work on the average of a thousand numbers by just relying on self-created formula. How do these “basic Excel functions” work?īasically, no one would be happy adding up 500 items on Excel workbook by clicking on them one by one so they will be in a single formula. It also has its “functions”, or specially programmed formulas, which allow users to perform more complicated calculations in just few clicks. However, calculations using formula is not the only feature Excel can boast. Students, and even professionals, rely on its capabilities to lessen their burden on doing certain calculations and operations over and over again. Users appreciate the fact that calculations can be made easier using this platform. One of the most advantageous uses of Excel is its capability to handle formulas.

Excel’s basic functions: SUM, AVERAGE, MAX, MIN and COUNT

Excel 2016 functions list