Creating Formulas/Functions and Charts for a Microsoft Office Excel Cell
Microsoft Excel is typically meant for all calculations and creating formulas. It’s very simple to apply the formula (in other words creating a function for the input data) you wish to do.
Open Microsoft Office Excel:
For creating a formula first you must have entered the data that you wish to perform the function in Cells. In the following figure I have entered data from A2 to A5
Then select the result cell, where the result of the function/formula needs to be entered.
Go to Formulas Tab, there you can see a list of formulas like AutoSum,Recently Used,Logical,Text etc.
Click on the icon of the formula category which you wish to perform.
From the list of the formula, displayed click on the appropriate one, which needs to be performed. See here I have chosen Product.
Now the Function Argument dialogue Box will appear.
Number holds the input data for the function.
The box also displays the formula Result .If you are ok with the result,click Ok.
The result will appear in the selected result cell (i.e., A6 in our example).
I hope it’s very easy for you to understand the formula function in Microsoft office Excel using the above example
Creating Charts in Excel:
Charts are very much important if a spreadsheet contains large volumes of data, and is difficult to analyze each. It is just a visual treatment.
The data for which the chart to be prepared must be entered before.
Go to Insert tab, you can see the list of charts available like Column, Line, Pie, Bar etc.
Click on the desired chart icon and from the list the one you wish to have. Here I am giving an example of 3D column chart.
The chart will be displayed in the same worksheet on which you are working on.
You can customize the chart by Right click and the various options available there.
Here I am formatting the chart area. The dialogue box will appear where you can fill the area, apply shadow etc.
If you wish to move the chart to a different location, Right Click on the border of the chart and click Move Chart, where you can specify the new location of the chart, to a new worksheet or to a new chart sheet
