When you hear the word, Microsoft Excel, what pops into your mind?

Numbers? Formulas? Functions?

Well, let us dig deeper into these words.

 
 
The numbers. Of course you are very familiar with them. These are often seen in the data you input at the worksheets.
But these are not only for that, the numbers can also be used in creating formulas.



 
 

The formulas. These are expressions used to perform calculations. Formulas begin with an equal ( = ) sign and are composed of operands and operators. You may also see constants, cell references, ranges, and grouping symbols within formulas.







The functions. These are predefined formulas that may require arguments as inputs. These may be used together with other functions and operations.

Oh and by the way, watch out for errors.

These are the common ones:

 

####
When you see this, expand the cell. This indicates that the data to be displayed is too long for the cell to display.

#N/A 
Recheck the data when you see this. This means that there is some data missing or there is no match for the function/formula you entered.

#REF! 
Be sure that the cell position you entered is correct. This error means that the cell reference is invalid.

Reference: http://moodle.pshs-brc.edu.ph/pluginfile.php/4746/mod_resource/content/0/Functions%20and%20Formula.pdf
Image Source: https://images.search.yahoo.com