EXCEL

shipment of audio recordings

QUESTION/DISCUSSION

How to crate 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 youwant 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 typicalspreadsheet

State 5 example for mathematics formula using Excel

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 325v.

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

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.