In this article we will look at one of the office applications MS Office Excel.
MS Office Excel is a program that is part of the Microsoft Office suite. Used for various mathematical calculations, charting, creating tables, etc.
A program document is a workbook. The book consists of an unlimited number of sheets, set by the user.
Each sheet of the program is a table consisting of 65536 rows and 256 columns. Each cell of such a table is called a cell.
An Excel cell has its own individual address, consisting of a row number and a Latin letter of a column (for example, 1A, 2B, 5C).
The main functions of the program
SUM function (amount in Excel)
Summing numbers and numbers in Excel can be done in three ways.
- Using the standard addition sign is a plus (“+”). Most often, this method is used when adding a small number of digits or numbers, as well as inside formulas to add the calculations of other functions.
- Using the input of the SUM function and selecting the arguments. Allows you to add numbers located in a single array (parts of a column, row), several non-adjacent cells, one two-dimensional array, an array of adjacent cells and parts of non-adjacent ones. Amount in Excel using this function can be calculated any.
- Using the “Σ” auto-sum symbol and choosing a range of terms. It is used to calculate the amount in the same cases as SUM.
ROUND formula
The result of any calculation, as well as the amount in Excel, may be subject to rounding. Rounding in Excel is important not to be confused with value mapping.
To perform the "rounding in Excel" action, you must select a cell containing the calculation result, put an equal sign ("=") before the number, select the "ROUND" function, and set the required number of digits.
Regarding the display of characters, it should be noted that the cell displays the number of bits that is placed in it for the visibility of the user. But in this case, rounding as such does not occur. When changing the size of the cell, the number of discharges also changes both to a larger, with increasing cells, and to a smaller, when decreasing, side.
As you can see, rounding in Excel is not such a difficult task.
“PROPNACH”, “DLSTR” - text functions that allow you to change the length of a string or the case used, as well as combine or split lines.
“BDSUM”, “BDSUMM” - functions for databases. Allows you to read the number of database records, the sum of the values. These functions are similar to the sum function in Excel of type "SUM".
"CELL" - this function provides the user with information about the properties of the cell.
Math functions are the core of Excel. Calculations using them are the main purpose of the program. Excel has a huge variety of mathematical functions, such as sine, cosine , arcsine, arcsine, tangent, cotangent. When using these functions, multi-bit values are often obtained. So the "Rounding in Excel" item in this article will come in handy in this case too.
"MUMNOZH", "MOPRED", "MOBR" for operations with numerical arrays, matrices.
“UNIT”, “INTERMEDIATE” for obtaining final and intermediate values.
Logarithms, linear logarithms, decimal logarithms.
Statistical. "BETAOBR" - makes the return of the inverse function to the integral density function of beta probability. "WEIBULL" - return of the Weibull distribution.
MS Office Excel also has financial functions, functions of links and arrays , functions of date and time, verification of assignments and properties.
Thus, this program is an indispensable tool for people of any profession who are somehow related to numbers and numbers.