Excel

1)How to Create the Table 

1. 
   1
   Open a workbook (spreadsheet) or have one already open.
2. 
   2
   Select a range of cells, if you wish. If you have already determined which cells will make up your table, you can select that range of cells now. You can change this range later when you create the table.
3. 
   3
   Create the table.
   • To create a list (table) in Excel 2003, select "List" from the Data menu.
   • To create a table in Excel 2007 or 2010, select the range of empty cells or cells containing data that you want to have in your table. Then, either select "Table" from the Tables group on the Insert menu ribbon or select "Format as Table" in the Styles group on the Home menu ribbon, and select one of the table styles. (The former option applies Excel's default table style, while the other lets you choose a style when you create the table. You can later apply or change the table style by selecting one of the options from the Table Styles group in the Table Tools Design menu ribbon.)
4. 
   4
   Provide a data source for your table, if you did not previously select a group of cells. After you perform the appropriate action from those listed in the previous step for creating a data table or list table, a dialog box will appear, either the Create Table dialog (Create List dialog in Excel 2003) or the Format As Table dialog. The "Where is the data for your table?" field displays the absolute reference(s) for the current cell(s) selected. If you want to change this information, you can type in a different cell or range reference.
5. 
   5
   Indicate whether your table has headers. If your table has headers, check the "My table has headers" box.
   • If you don't check this box, the table will display default header names ("Column 1," "Column 2," etc.). You can change a column name by selecting the header and typing in your own name in the formula bar.
6. 2)Give examples for Mathematics formula using Excel
7. 
   

Using mathematical operators to calculate percentages (Excel Formulas example)

Consider the following situation:
You are offered a loan of $5,000 and asked to return it in 12 monthly installments of $588.
How much money will you be required to pay back?
What is the yearly percentage of interest you will be paying?
These questions are easily solved with Excel.
We'll start by typing in the values we already know:

To define the formula that calculates the total payment amount, we simply create a formula that multiples the number of payments by the monthly payment amount:

Note
I strongly advise you to recreate this example in Excel. Merely reading this guide is not nearly as helpful as recreating the examples shown here in Excel and playing around with them.
If you aren't sure how to enter formulas into Excel, skip ahead to the next chapter titled 'How to insert & edit formulas'
To calculate the yearly interest rate (in percentages), we'll create two additional formulas.
The first one will calculate the percentage of the 'pay back amount' out of the 'loan amount'. This is done by dividing the 'total payment amount' with the 'original loan amount' and multiplying by 100, as seen here:

We can already see that will be paying back more than 140% of the original loan ... ouch!
To complete the calculation of the yearly interest rate, we simply need to subtract 100 from the number we already have:
3)How To insert Symbol RM with 2 Decimal Places 
 


1. Select the cell or range of cells that contains the numbers that you want to display with a currency symbol.
How to select a cell or a range
2. On the Format menu, click Cells.
3. On the Number tab, click Currency or Accounting in the Category box.
4. In the Symbol box, click the currency symbol that you want.
 NOTE   If you want to display a monetary value without a currency symbol, you can click None.
5. In the Decimal places box, enter the number of decimal places that you want to display.
6. In the Negative numbers box, select the display style for negative numbers.
 NOTE   The Negative numbers box is not available for the Accounting number format.

Tips

• To quickly display a number with the default currency symbol, select the cell or range of cells and then clickCurrency Style  on the Formatting toolbar.
• To change the default currency symbol for Excel and other Microsoft Office programs, you can change the default country/region settings in Control Panel. Note that although the Currency Style button  image does not change, the currency symbol that you chose will be applied when you click the button. For more information, see Change the default country/region.
• To reset the number format, click General in the Category box. Cells that are formatted with the Generalformat have no specific number format.

Conclusion

I learned how to use excel, model making tables and how to use the formula.