Introduction to Functions 
As a spreadsheet application, StarCalc is equipped with various functions that can solve almost any kind of calculation. In order to use the functions more effectively, you should know which ones are available and how they work. A function in your application involves three issues. The purpose of the function: what is it used for? Different functions are meant for different purposes. The arguments used by the function: what does the function need, in order to carry its assignment; an argument (or arguments) is (are) the value (values) that the function needs to work efficiently. A function can use more than one argument. A function's arguments are mostly made in two categories, some arguments are required; in other words, if you don't provide them, the function will throw an error. Other arguments are set with default values; in other words, the application will provide their arguments if you don't. The cell responsible for displaying the result: in what cell will the result appear (it has to appear somewhere)? The use and implementation of a function always starts with an equal sign "=" followed by the name of the function. If you remember the name of a function and know its arguments and decide to use it, you can type = in a cell and the name of the function followed by an opening parenthesis. StarCalc will know that you are trying to use a function and will help. Although the functions are not casesensitive, it is a good idea to always write them in uppercase. 
Mathematical Operations 
Before getting into functions, let's experiment with StarCalc's use and recognition of mathematical operations. StarCalc is aware of such algebra operations as the addition (+), the subtraction (), the multiplication (*), and the division (/). These operations can be applied to numbers typed in a cell when performing the operation, they can be gotten from another cell. On the Status Bar, the AutoCalculate pane is a special area that allows you to get a quick result of the most used functions in StarCalc. 
The Sum 
The SUM function is the most basic and probably the most popular function used in StarCalc. It is used to sum the contents of two or more cells and display the result in another cell. The formula bar is equipped with a smart button called the Sum button. You can click an empty contiguous cell, and then click the AutoSum button. Before performing the SUM function, the computer will ask whether it found the right cells that you want to get the sum of. If the computer found the right cells, press Enter, otherwise use your mouse or your keyboard to select the cells you want to consider. 
Practical Learning: Use the AutoSum 

AutoCalculate 

Introduction to Math and Trigonometric Functions: SUM 
StarCalc is made of many functions. Whenever the sum is not involved, you will use one of the other various functions to get a particular result. The SUM function is used to add the contents of various cells. 
Practical Learning: Using the SUM Function 

Statistical Functions: Average 
The AVERAGE function displays the average or mean value of selected cells. It takes the sum of the cells involved (you don't need to calculate the sum first), divides the result by the number of cells involved, and displays the result. We will use the AVERAGE function to get the average grade for each student's grade. 
Practical Learning: Using the Average Function 

Statistical Functions: MIN  MAX 
The MIN (MAX) function will examine the contents of selected cells and display the content of the cell that has the lowest (highest) value. Now we will learn about the MIN and the MAX functions. 
Practical Learning: Using the MIN And MAX Functions 

Statistical Functions: COUNT  COUNTA 
The COUNT function counts the number of cells that contains numbers in the range or group of cells involved in your selection. While the COUNT function counts the cells that contain numbers, the COUNTA function counts the number of nonempty cells (regardless of what is in those cells, as long as they contain something) in the cells involved. 
Practical Learning: Using the COUNT and COUNTA Functions 

Logical Functions – IF 
If you want to display something in a cell but conditional to another cell's content, you can use the IF function. Of course the IF function can do more than that. The IF function will check the truthfulness or negativity of a statement. If the result is true, then it will execute the first expression; if the result is false, it will consider the second option. We are going to use the IF function to find out whether a student passes the mark or fails the class, based on the overall average of the student's grades. We will set the mark at 14.50. If a student's average is above 14.50, then he goes to the next grade, otherwise, … 
Practical Learning: Using the IF Functions 

Previous  Home  Next 


Copyright © 2002 FunctionX  
