Excel

Create the table

Once the data has been entered, it can be converted into a table. To do so:

1. Drag Select the cells A3 to E13 in the spreadsheet.
2. Click on the Home tab.
3. Click on the Format as Table option on the ribbon to open the drop down menu.
4. Choose the blue Table Style Medium 9 option to open the Format as Table dialog box.
5. While the dialog box is open, cells A3 to E13 on the worksheet should be surrounded by the marching ants.
6. If the marching ants surround the correct range of cells, click Ok in the Format as Tabledialog box.
7. If the marching ants do not surround the correct range of cells, drag select the correct range in the spreadsheet and then click Ok in the Format as Table dialog box.
8. The table should have the drop down arrows added beside each field name and the table rows should be formatted in alternating light and dark blue.

EXAMPLE MATHEMATICAL FORMULA USING EXCEL 

Example 1 : =A1+A2+A3: calculate from left to right: 8 + 6 + 2 = 16
Example 2 : =A1-A2-A3: calculate from left to right: 8 - 6 - 2 = 0
Example 3 : =A1+A2-A3: 8 + 6 - 2 = 12
Example 4 : =A1+A2*A3: the multiplication, A2 x A3, is done first, so 8 + 12 = 20
Example 5 : =(A1+A2)*A3: math inside parentheses is always done first, so 14 x 2 = 28
Example 6 : =A1+A2/A3: the division, A2 ÷ A3, is done first, so 8 + 3 = 11
Example 7 : =(A1+A2)/A3: inside the parentheses is calculated first, so 14 ÷ 2 = 7

HOW TO INSERT SYMBOL RM WITH 2 DECIMAL PLACES

1. Login to the admin panel

2. Goto System -> Localisation -> Currencies

3. Click [Insert] to add new currency to the system

4. Enter these value

Code : MYR

Symbol Left : RM

Symbol Right : - leave blank -

Decimal Places : 2

Value : - see note below-

Status : Enabled5. Click [Save] when done