EXCEL


Excel


Latihan : CARTA

Question 1 - How to Create the Table

Method 1 of 8: Creating a Table





1 Open a workbook (spreadsheet) or have one already open.




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 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 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 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.



Edit




Question 2 - Give examples for Mathematics formula using Excel

This example is pretty cool because 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 results 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:




And again, when we change the parameters (A1,A2) the result changes.


Question 3 - How To insert Symbol RM with 2 Decimal Places

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
On the Format menu, click Cells.
On the Number tab, click Currency or Accounting in the Category box.
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.
In the Decimal places box, enter the number of decimal places that you want to display.
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

After do some exercise and calculation , finally i know how to calculate using Microsoft Excel and finished it ..

No comments:

Post a Comment