Excel

Lab Report

QUESTION/DISCUSSION

                             

1. How to create the table

è CREATE TABLE Example

Now we want to create a table called "Persons" that contains five columns: P_Id, LastName,        FirstName, Address, and City.

CREATE TABLE Persons ( P_Id int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) )

We use the following CREATE TABLE statement:

2. Give example for mathematics formula using Excel:-

è Writing the Formula

Ad

Trade Binary Optionswww.BBinary.comTrade On Our Award Winning Platform 100% Intro. Bonus, Register Now!

Writing Excel Formulas

© Ted French

Writing the Formula

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.

Excel formulas look like this:

=3 + 2

rather than: 

3 + 2 =

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. Goto 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