Microsoft Excel ☺

Tugasan 1 (Excel)

HOT TO CREATE THE TABLE

• On a worksheet, select the range of cells that you want to include in the table. The cells can be empty or can contain data.
• On the Home tab, in the Styles group, click Format as Table, and then click the table style that you want

Keyboard shortcut    You can also press CTRL+L or CTRL+T.

• IF the selected range contains data that you want to display as table headers, select the My table has headers check box in the Format as Table dialog box.

Table headers display default names if you do not select the My table has headers check box. You can change the default names by selecting the default header that you want to replace, and then typing the text that you want

Next steps

• The Table Tools become available when you select a table, and a Design tab is displayed. To get a good idea of what you can add to or change in your table, click the Design tab, and then explore the groups and options that are provided on this tab.
• For detailed instructions on how to create a table, see Create or delete an Excel table in a worksheet.

_____________________________________________________________________________________________

State 5 example for mathematics formula using Excel

Creating formulas in Microsoft Excel is not difficult. Just combine the cell references of your data with the correct mathematical operator.

The mathematical operators used in Excel formulas are similar to the ones used in math class.

• Subtraction - minus sign ( - )
• Addition - plus sign ( + )
• Division - forward slash ( / )
• Multiplication - asterisk (* )
• Exponentiation - caret (^ )

_________________________________________________________________________________

 How to insert Symbol RM with 2 decimal places

.

 

1. highlight nombor 

2. right click then FORMAT CELLS

3. click Number decimal (d.c.) => 24. currency => symbol RM

  If don’t have find RM,use CONTROL PANEL for change to RM

 1. click control panel2. regional and language options3. select Malay (Malaysia)OR 

4. customize => currencyCurrency symbol: RMDecimal symbol: .No. digits after decimal: 2Digit grouping symbol:

Tugasan 2 (Excel) Tugasan 3 (Excel) Tugasan 4 (Excel) Tugasan 5 (Excel) Lab Report Excel 1 (1) Lab Report Excel 2 (1) Lab Report Excel 3 (1) Lab Report Excel 4 (1) Lab Report Excel 5 (1)