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

No comments:

Post a Comment