Excel

         


                                                   

MICROSOFT EXCEL

QUESTION

1. How to create the table

- On your worksheet, select a range of cells you want to make into a table

- Go to insert tab and click at table icon

- To accept the selected cell range for your table, click OK. The selected cell range is converted into a table.

2. Give example for mathematics formula using Excel

- Open Microsoft Excel

- When creating formulas in Microsoft Excel, you ALWAYS start by typing the equal sign.You type it in the cell where you want the answer to appear

 - The best way of adding cell references is by using the Excel feature called pointing. Pointing allows you to click with your mouse on the cell containing your data to add its cell reference to the formula. The formula will add the numbers 3 + 2. The final formula will look like this = E1 + E2

- The answer will appear

3. How to insert Symbol RM with 2 decimal places

- Open Microsoft Excel

- List the account

-  Go to icon that have symbol $ and click at the more accounting format

- Set the account to RM and the set to 2 decimal places

- The account will be like this

4. Conclusion

 - Learn how to how create table using Excel

 - Learn how to use mathematics formula using Excel

 - Learn how to insert symbol RM in Excel