EXCEL

Result

QUESTION/DISCUSSION

1. How to create the table 

Creating table




In addition to its other spreadsheet features, Microsoft Excel offers you the ability to create tables within a spreadsheet. known as "lists" in Excel 2003, they managed separately from data you have elsewhere on that spreadsheet page managed separately from data you have elsewhere on that spreadsheet page or any other page in the spreadsheet. see step 1 below for instructions to make and manipulate tables in Microsoft Excel. 

Select a range of cells. The cells can contain data or they can be empty, or a combination of both. you don't have to pick your cells before you create the table if you aren't sure yet. Creating table

Insert the table, To start the table creation process, you will need to insrt a table into your spreadsheet.

In Excel 2003, click the Data menu and select List.

In Excel 2007, 2010 and 2013 select either "Table" on the insert menu ribbon or "Format 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 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.)

Provide a data source for your table. If you did not previously select a group of cells, you will need to select the now. After you pick your range, 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.

Indicate Wheather your table has headers. If your table has headres, check the "My table has headers" box. If you don't check this box, the table will disply will 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.

 Enlarging and Reducing Table Size

Grab the corner of the table. Move your mouse cursor over the sizing handle at the lower right corner of the table. Your cursor will change to a 2-sided diagonal arrow. Click and hold to “grab” the corner

Resize the table. Drag your cursor inward to reduce the table size, outward to enlarge it. Dragging your cursor adds or reduces the number of rows and columns.

Dragging your cursor up toward the column header reduces the number of rows in the table, while dragging your cursor down increases the number of rows. Dragging your cursor to the left reduces the number of columns in the table, while dragging it to the right increases the number of columns. A new column header is created when a new column is added.

Inserting and Deleting table rows and columns

Right-click the table cell where you wish to insert or delete a row or column. A Popup menu appears.

Select "insert" from the popup menu. Choose one of the insert submenu options.

Select "insert columns to the left" or "insert columns yo the Right" to insert a new column in the table. Select "Insert rows above" or "insert a new row in the table.

2. Give example for mathematics  formula using Excel.

Give example for mathematic formula using Excel.

Basic Excel Math formulas: Add/subtract/multiply/divide basic math formulas example: using math formulas to create a basic calculator in excel.

This example is pretty cool because in above in about five minutes we'll create a calculator in Excel (albeit a very basic one). 
This calculator will use cells A5 and B5 as the parameters and will show the addition, subtraction, division and multiplication result for those two numbers. We'll start with the just the two parameters:

Then we can add the formula for the addition result:

You can see that when we change the parameters (A1,A2), the result of the addition formula for our mini calculator changes: MISSING IMAGE?!

Let's now add the subtraction formula :

3. How to insert symbol RM with 2 decimal places.

1. Select the cell or range of cell 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. he category box. 

3. On the Number tab, click the 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 number box, select the display style for negative numbers.

   NOTE : The Negative number 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 cells and then click-currency 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 setting 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 format, click General in the category box. cell that are formatted with the General format have no specific number format.

Conclusion

I learn from Encik Shukri how creating table, how to editing and formarting, and i learn how to using basic financial and logical functions