HOW TO MAKE USE OF MICROSOFT EXCEL
In explaining the exactly how one can make use the Microsoft Excel, it will be very important to note the real definition of what the subject matter is. As it where, MICROSOFT EXCEL is a spreadsheet application package designed for the purpose of keeping of financial records, documenting files, for calculation and also for data analysis. That is a a summary of what the Microsoft Excel is.
For users who have lots of financial calculation to deal with, is getting the calculation done without stress by making use of Microsoft excel. To this end, the iMportancy if Microsoft Excel cannot be over emphasized there making us to bring to you how you can make use of Microsoft Excel without going through some unforeseen stress and will be giving you the formula you will be using to solve some challenges. The Element of Ms Excel Work Sheet
The Microsoft Excel from studies shows that it has a component which are applications that made up a work sheet. We have four element of a Ms excel work sheet. Below are the four element as we do have it in Microsoft Excel
- Vertical boxes that are found in the work sheet
- Horizontal boxes that one can found in the ms excel work sheet
- Cell is the intersection between column and rolls, that is the boxes that are formed by rolls and colums
- Cell pointer is that rectangular box that helps to indicate where to type
Now, as we speak of all these four columns, we will be laying emphasis on the cell pointer. The cell pointer comprises of the combination of column and rolls. The rolls are usually indicated by the serial numbers which ranges from 1. Again, the column could also be ranging from alphabetic ranging from A. To this end, the cell pointer is the combination which lies between the column and rolls. This means that when you see A2 that word, it is a cell Address.
We will be dealing with some important applications found in the Microsoft Excel which are Data, and Formula. Users should please take note of is the word formula. According to a journal by James Watty, Data are raw materials which are not yet process, and when at last it is processed it changes to information.
A formula are those set of written instruction that you follow to get a particular result. When you have a problem you want to solve, the steps and style you follow to get that problem resolve is what we called formula.
Types of Formula
We have two types of formula and they are legitimate formula and illegitimate formula
- Legitimate formula are those formula that makes use of the real numbers
- Illegitimate Formula are those formula that makes use of the sell address.
When you are calculating with the legitimate formula, you are expected to make use of the real numbers in the cell. Each box are expected to have a data. Box A1 may have 2000 and box B2 may have 100, when you are expected to add this two, the act of stating =2000+100 to get the answer is legitimate formula.
And for the illegitimate formula is to make use of the cell address to solve the problem. When you are solving a problem making use of the cell address to calculate the problem. That is if 2000 is in box A1 and the 100 is in box B1, and you are adding for an answer to you then make use of A1+B1 that is what is illegitimate formula.
For users who want to make use of this formula, they can copy paste the rest of the answer. Copy paste means the act of making the rest of the question in different box get the answers without calculating on them.
With this little information in mind, there are lots of topic you can deal with so long you know the formula of the financial question or data information. For users who wants to solve issues like the simple interest , you are expected to make use of the popular formula to solve the said problem. You can use the PTR/100 formula.
This is the little i can offer. But you can always drop your comments for more suggestions and other related issues.
How To Make Use Of Microsoft Excel