As in Excel to calculate the sum of : AutoSum
Techno / / August 12, 2017
Excel - the most important element of all Microsoft Office software package, Excel - a spreadsheet editor, in which all the work is structured aroundtables, formulas, and especially within the tables.By themselves, the table can be as simple and consolidated, which helps to automatically calculate the necessary indicators.Functions with which all calculations are performed and are quite simple, such as "plus", "minus", and there are also three-level, which even in one line does not fit.But everything, but in order, to begin with, as in Excel to calculate the amount, it's also not so easy.And for the one who first begins its study of Excel, you may have some difficulty.
To start working in Excel you need to run it.This is done as follows: you need to click on the "Start" button, which is located in the lower left corner of the computer screen, followed by select all programs, then click on the main program, and then the Microsoft Office line
To make it more clear, we will begin to consider the example of calculation AutoSum.So we put in a cell number 20 A1, A2 in the cell - 15, A3 - 5. It turns out that we have three numbers that need to be folded.Do addition, namely, double-click on the A4 cell then put an equals sign in that same cell, click on the cell A1, then on the "+" sign, then the cell A2, and then again "+", then on the A3, in the end we pressEnter, and in cell A4 get the number 40. If you click once on the A4, then the top menu to appear written formula, namely A1 + A2 + A3, thus you can see how the cell A4 was obtained.It should now be clear as in Excel to calculate the amount.But this amount of manual counting, and in Excel there is also a great feature that all she thinks.
Consider AutoSum more.Also, leave the information already entered in cells A1, A2 and A3.The number of A4 can be removed, so as of now it is received, but in another way.We get the cursor to cell A4 and click on it.Next, go to the top menu, where the contents of the cell is reflected, and look where fx icon.By clicking on it, you can see all the functions that are in Excel, there is a huge list of features, and with each version of Excel functions number is increasing.There is the "search function" to inscribe the name of the function, namely "SUM".Click OK and Excel will make the calculation itself of all the cells, which are located on the A4 cell.This is the second way to get a cell A4 number 40, to engage the sum function.
There is another option to calculate the amount in Excel.Reserve cells A1, A2, A3, and press once on A4.Then go to the menu "home" in the upper left corner of Excel, there choose the "Edit", which have the sum symbol Σ (or sigma), click on it, and thus, again, get a response 40 to the A4 cell.It turns out that in Excel to calculate the sum of three ways.Certainly worth a try each of them to have a good deal in this, and to see which method is easier, as will be faster and more convenient.Excel need to know, because sooner or later it will face, perhaps, each worker.As for the amount of features, it is the most used around the spreadsheet editor, which is why to know how to count, it is very important.