Functions of Basic Formula in Microsoft Office Excel 2013

The formula or function of the basic formula is to perform calculations on the data in Microsoft Office Excel 2013. Any use of the basic formula, we must begin with an equal sign (=). The equal sign (=) is intended to initiate a function in Microsoft Office Excel 2013. Noteworthy is the address of the data, if the wrong type in the address, then the data would be worth one (#VALUE). The Basic formula of excel 2013 and their function, among others :
  • Basic arithmetic: Sum Formula (+), subtraction (-), multiplication (*), and division (/).
  • SUM: has a function to add data.
There is a Data Items consisting of markers, eraser, ruler, pencils, and books. The each of item having a amount that is not the same as other items. From the picture above, to find how many item as a whole, we can use the SUM formula. By typing the address C2 as first data, through C6 as the last data so it can be a whole total.
  • MIN: has a Function to find the lowest value of the data set.
There is a value of data from several students with different values ​​from one another. From the picture above, to find the lowest value of all values ​​is to use the MIN formula. By typing the address C2 as first data, up to C9 as the last data so that it can be seen what is the lowest.
  • MAX: the Function of MAX formula are to find the highest value of the data set.
There is a value of data from several students with different values ​​from one another. From the picture above, to find the highest value of all values ​​is to use the MAX function. By typing the address C2 as first data, up to C9 as the last data so that it can be seen what is the highest value.
  • AVERAGE: the Function of Average formula are to find the average value of the data set.
There is a value of data from several students with different values ​​from one another. From the picture above, to find the average value of all values ​​is to use the AVERAGE formula. By typing the address C2 as first data, up to C9 as the last data so that it can be seen what is the average value.

To limit their digits behind the comma (,), we can arrange it in the cell format by right-clicking the right in the column which will be set. Then select the Number tab and select the Category Number. Please set in column Decimal Places, in accordance with your wishes.

  • COUNT: the Function of COUNT formula are to calculate the amount of data.
There is a value of data from several students with different values ​​from one another. From the picture above, to find the total of students if we count from the amount of value is to use the COUNT function. By typing the address C2 as first data, up to C9 as the last data so that it can be seen what is the count of students.
  • CONCATENATE: this formula have a function to combine data between columns. To combine the data in the Subject field and the Domain, so needed CONCATENATE function to combine data between columns.

That is some basic formulas of microsoft office excel 2013 and their function that consists of Basic arithmetic: Sum Formula (+), subtraction (-), multiplication (*), and division (/), SUM, MIN, MAX, AVERAGE, COUNT AND CONCATENATE.

Post a Comment for "Functions of Basic Formula in Microsoft Office Excel 2013"