Home / How to / Introduction to Excel Basic Functions

Introduction to Excel Basic Functions

This page introduces some of the basic functions that will help when you are using functions and formulas in Excel. Below are the most basic functions in the spreadsheet not only of the Excel program , but also most of them, such as the one you have free on Google Drive.

Specifically, these are the functions that I will explain:

  • Sum
  • Subtraction
  • Product
  • Division
  • Percentage
  • Maximum and minimum
  • Average

Basic Functions in Excel :

01

Sum

Sum : With this function what we calculate is the sum of all the numbers of a data set (also called range) It is represented in the Excel sheet:

= SUM (cell (s): cell (s))

02

Subtraction

Subtraction : Analogous to the sum, but with the sign – instead of the sign :. And it will be:

= RESTA (cell (s) -cell (s))

03

Product

Product : Multiply all the numbers by obtaining the product of those numbers. It will appear:

= PRODUCT (cell (s); cell (s))

04

Division

Division : Similar to the product. The formula will appear:

= DIVIDE ((cell (s) / cell (s))

05

Percentage (%)

Percentage (%): Excel calculates the percentage of a series of data, dividing the amount by the total. The expression of this function is

= PRODUCT (%; cell (s))

06

Maximum and Minimum

Maximum and Minimum : With this Excel function we will indicate the maximum and minimum value of a set of values. A) Yes:

= MAX (range) y = MIN (range)

07

Average

Average : Returns the arithmetic mean of a series of values. With the expression:

= AVERAGE (rank)

Exercise with functions in Excel

In the exercise that I explain to you, you are going to perform your first actions to practice with Excel functions, suppose you have the following data:

Write in cell A1: the number 3 and in cell A2: write 2.
You are located in cell A3, you want to make the sum of these numbers, for this you will:
Insert, Function, choose Sum and press with the mouse or directly write in the first rectangle A1 and in the second A2 we give to accept, we obtain 5.

Proceed in the same way to perform the calculation of the other functions explained and so you will have made your first steps in Excel.

Note:

freejobalert - Find the Jobs Alert free, Updates all over the world jobs This site Provides the Jobs Free Alert, to your Inbox and Provide the Best job Alert. freejobalert.cc provides the latest job alert ( free job alert ) all over the world. freejobalert is website that gives information about Job Opportunities. The website is neither directly nor indirectly involved in any step of recruitment. We just share jobs available in different companies worldwide. Once you visit our website and click on the apply now button for the desired job, it will direct you to the career page of the concerned company. Once you reach that page, our job is done.

About healthcare

Leave a Reply

Share it
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkedin
Share On Pinterest
Share On Reddit
Share On Stumbleupon
Contact us
Hide me