Question 1 - How to Create the Table
To make working with data easier, you can organize data in a table format on a worksheet.
Tables provide easy filtering, in addition to calculated columns and total rows, which make calculations simple.
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
Writing Excel formulas is a little different than the way it is done in math class.
Excel formulas starts with the equal sign ( = ) rather than ending with it.
The equal sign always goes in the cell where you want the formula answer to appear.
The equal sign informs Excel that what follows is part of a formula, and not just a name or a number.
Question 3 - How To insert Symbol RM with 2 Decimal Places  Adding Number Formatting
Number formatting refers to the addition of currency symbols, decimal markers, percent signs, and other symbols that help to identify the type of data present in a cell and to make that data easier to read.
Excel makes it easy to add number formatting to a worksheet by using icons on the Home tab of the ribbon.
For this tutorial we will add percent signs and currency symbols where needed as well as reducing the number of decimal places for one column of values.CONCLUSION after learning using excel I know how to make calculations such as charts, percentages, currency calculation in an easy way. |
No comments:
Post a Comment