Excel

Excel

Tugasan 1

Tugasan 2

Tugasan 3

Tugasan 4

Tugasan 5

Lab Report Excel

1) How to create the table 
  ü  Turn on your computer and open the "Excel" program.
       ü  Open the workbook that you'd like to use. You can create your table in anexisting       
           workbook or you can create a new workbook. If you want to create anew workbook,
           simply click on "File" then "New" in the menu along the top of your screen.
  ü  Select the cells you wish to include in your table. You can select these cells byholding
           down your left mouse button and moving your mouse over the cells you want to include.

      ü  Create your table by clicking "Insert" then "Table." Your table is now complete,and you

          can sort or calculate data in the table separately from data that is not inthe table.

     ü  Format your table. Once you have created your table, you can click on "TableTools" to

        format or edit your table the same way you would format a typical spread sheet.

2) State 5 example for mathematics formula using Excel
      i. SUM

ü  SUM(3, 2)
 Adds 3 and 2 (5)

ü  SUM("5", 15, TRUE)
Adds 5, 15 and 1, because the text values are translated into numbers,and the logical value TRUE is translated into the number 1 (21)

ü  SUM(A2:A4)
Adds the first three numbers in the column above (40)

ü  SUM(A2:A4, 15)
Adds the first three numbers in the column above, and 15 (55)

ü  SUM(A5,A6, 2)
Adds the values in the last two rows above, and 2. Because nonnumericvalues in references are not translated, the values in the column aboveare ignored (2)

   ii. AVERAGE

ü  AVERAGE(A2:A6)
Average of the numbers in cells A2 through A6.

ü  AVERAGE(A2:A6, 5)
Average of the numbers in cells A2 through A6 and the number 5. 

ü  AVERAGE(A2:C2)
Average of the numbers in cells A2 through C2.

   iii. COUNT NUMBER

ü  COUNT(IF((A2:A11="South")*(C2:C11="Meat"),D2:D11))
Number of salespeople who sold meat in the South region (3)

ü  COUNT(IF((B2:B11="Suyama")*(D2:D11=>1000),D2:D11))
Number of sales greater than 1000 by Suyama (2)

   iv. MAX

ü  MAX(A2, A3)
would return 10.5

ü  MAX(A3, A5, 45)
would return 45

ü  MAX(A2:A6)
would return 200 

ü  MAX(A2:A6, 325)
would return 325

   v. MIN 

ü  The MIN functions returns the smallest value in a data set. For example:=MIN(D2:D7) applied to the data set above should return 2

3) How to insert Symbol  RM  with 2 decimal places.

    ü  Click the File tab and then click Excel Options.   
 ü  Click the Advanced tab.   
    ü    Select the Automatically Insert a Decimal Point check box in the EditingOptions section.
 

    

   
















ü  (Optional) Type a new number in the Places text box or use the spinnerbuttons to change
       the value


   ü  Click OK