Calc Open Office Part III

Functions

• What is a Function ?

• A function is a pre-defined calculation entered in a cell to help you analyze or manipulate data in a spreadsheet.
• All you have to do is add the arguments, and the calculation is automatically made for you.

• Adding a Function

1. Select the cell that you want to get the result
2. Go to Insert > Function or click on the icon in the function tool bar

• Function Wizard

• You can select the function category from the category list.
• Then, select the function you need from the function list.
• e.g. Selecting the SUM function

Without functions...

• For basic equations, you may use,

1. plus sign (+) for addition
2. hyphen (–) for subtraction
3. asterisk (*) for multiplication
4. forward slash (/) for division

                            e.g. = SUM(A1:A2) is same to =A1+A2
Exercise  Calculate the subject sum values using SUM function

Statistical Functions

• Statistical functions are used to analyze data.
• To insert these functions you have to select the function category as Statistical at the function wizard.

1. MIN - Minimum/lowest value
2. MAX - Maximum/highest value
3. COUNT - Total number of entries
4. AVERAGE – Average value of selected entries
5. MEDIAN -The entry that is exactly half way between the highest and lowest number in a list 
6. MODE -The most common entry in a list of numbers

Exercise Calculate the average marks of students

Exercise Calculate minimum and maximum values.

Logical Functions... (IF)

• Format of the function : IF(Test;Then_value;Otherwise_value)
• Test = The condition that you are going to check
• Then_value = What should be the answer if your test is successful /true
• Otherwise_value = What should be the answer if your test is not successful /false

Exercise Lets find the grades of students for our sample marks sheet.
                          Grading Criteria :
                                  if average>50 → PASS
                                     else → FAIL
Step 1 : Place the cursor where you need the answer

Step 2 : Get the function wizard and select “IF” function

Step 3 : Click the “shrink” button in front of “Test”

Step 4 :Complete the test condition

Out put