EXCEL

RESULT

How To Create the Table

Microsoft Excel 2007

Creating Tables

Excel Tables are useful for managing sets of related data. Excel 2007 makes it easy to set up a Table and add data to it. For basic information on Tables, refer to Tables Overview

.

·                     Creating a Table

·                     Using Forms to Enter Table Data

·                     Using the Worksheet Window

Creating a Table

By creating a table with Excel's Table button, you will have access to Table Tools and the accompanying Design command tab (neither of which are available for normal a data range).

You can either create a blank table or create a table from an existing data range.

Creating a Table: From a Blank Cell Range

1.     On your worksheet, select a range of cells you want to make into a Table

                2.  From the Insert command tab, in the Tables group, click TABLE

      NOTES:

       Create Table dialog box appears, displaying the selected cell range.

       Behind the Create Table dialog box, the selected cell range is highlighted with an           animated border.

    3.    OPTIONAL: To specify a different cell range, in the Where is the data for your table? text box,      type the desired cell range

OR

To select the range

a.                    Click COLLAPSE DIALOG BOX

b.                    Select the desired cell range

c.                    Click EXPAND DIALOG BOX

d.                    Click OK

1.                     OPTIONAL: If your selected cell range already has headers (i.e., column labels),   select My table has headers

2.                    To accept the selected cell range for your table, click OK

The selected cell range is converted into a Table.

NOTE: For information on Table terms, refer to Tables Overview: Table Terms.

Creating a Table: From an Existing Data Range

1.                     Select the data that will make up your Table

2.  From the Insert command tab, in the Tables group, click TABLE

The Create Table dialog box appears, displaying the selected data range.

If Excel detects headers (i.e., column labels) in the selected data range, the My table has headers option is automatically selected.

3. OPTIONAL: If your table does not already have headers (i.e., column labels), deselect My table has headers
4. OPTIONAL: To specify a different cell range, in the Where is the data for your table? text box, type the desired cell range
5. OR
   To select the range 
   a.                    Click COLLAPSE DIALOG BOX
   b.                    Select the desired cell range
   c.                    Click EXPAND DIALOG BOX
   d.                    Click OK
   1.         To accept the selected cell range for your Table, click OK
   The selected cell range is converted into a Table.

Give Example for Mathematics Formula Using Excel

Whenever the contents of the cells referenced in a math formula change, Excel will automatically recalculate the answer for you. That is what makes this software program so powerful. As some formulas can get extremely complicated, it is a good idea to lock those cells that contain the formulas and protect the worksheet. A cell, or a group of cells, can be locked via the Protection tab on the Format window. Instructions for protecting a worksheet or workbook can be found in the "Protecting a Worksheet or Workbook" section of our tutorial Excel Made Easy: A Beginners Guide

The 5 basic rules to remember as we discuss Excel formulas are:

1.                     All Excel formulas start with an equal (=) sign. This tells Excel that it is a formula.

2.                    The answer to the formula displays in the cell into which the formula is entered.

3.                    Cells are referenced in a formula by their column-row identifier, ie. A1, B2.

4.                    The symbols for addition, subtraction, multiplication, and division are: + - * /

You do not have to enter capital letters in your formula; Excel will automatically capitalize  them.

Example of simple math formulas:

·                     =A1+A6   this Excel formula adds the contents of cell A1 and A6

·                     =A1+A2+A3   this Excel formula adds the contents of the three cells specified. (See the SUM function for adding multiple numbers)

·                     =A3-A1   this Excel formula subtracts the contents of cell A1 from the contents of cell A3

·                     =B2*B3   this Excel formula multiples the numbers in cells B2 and B3

·                     =G5/A5   this Excel formula divides G5 by A5. (NOTE: If you see the error message #DIV/O! in a cell, you are trying to divide by zero or a null value - which is not allowed.)

·                     =G5^2   this formula tells Excel to square the value in cell G5. The number after the caret is the exponent. Likewise, the formula H2^3 would cube the value in cell H2.

We can combine multiple operations in one formula. Make sure you use parentheses where needed or you may not get the correct results (see Order of Operations below). Here are some examples:

·                     =(C1+C3)/C4   This Excel formula adds the value in C1 to the value in C3, and then divides the result by the value in C4

·                     =4*(A2+A5)+3   This Excel formula adds the contents of A2 and A5, multiples this sum by 4, and then adds 3.

How to Insert Symbol RM with 2 Decimal Places

If you are selling for Malaysian customer, it is a good practise to include Ringgit Malaysia (MYR) as one of you currency options.  Follow the steps bellows to insert MYR into the system :

1.                     Login to the admin panel

2.                    Go to System -> Localisation -> Currencies

3.                    Click [Insert] to add new currency to the system

4.                    Enter these value

·                 Code : MYR

·                 Symbol Left : RM

·                 Symbol Right : - leave blank -

·                 Decimal Places : 2

·                 Value : - see note below-

·                 Status : Enabled

5.                    Click [Save] when done

Now you can see "RM" symbol added to the currency option at your store front.

Notes :

1. How to set the value.

·                 Go to Yahoo Currency Converter (you can search with Google

·                 Check the value of MYR compare to USD $1.

·                 Set this value as the value in the currency setting above.

2. I prefer to set USD as the default currency.

3. Open Cart able to link to Yahoo Currency Converter to auto update the currency value      from time to time.

4. You can actually do the same steps for any other currency.