Quick start: Create an Excel table
Tables provide easy filtering, in addition to calculated columns and total rows, which make calculations simple.
Watch the video
How?
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.
2:Gife example for mathematics formula using Excel
3. How to insert Symbol RM with 2 decimal places.
- Select the cell or range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells that contains the numbers that you want to display with a currency symbol.
- 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 click Currency Style on the Formatting toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.).
- 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 General format have no specific number format.
CONCLUSION:
After i do some excise and learn about microsoft excel finaly i now how to calculate using microsoft excel.
No comments:
Post a Comment