function microsof excel

Microsoft Excel is a software to process data automatically meliputiperhitungan basis, the use of functions, graphing and data.Perangkat management software is very helpful to solve administrative problems from the most sedernaha to the more complex. Simple problems such as making plans include namabarang needs goods, the quantity of goods and the estimated price of goods. Examples of more complex problems is the creation of financial statements (general ledger) that require many calculations, management of data by displaying charts or pivot tables or the use of mathematical functions or logic in a report. for more details on these functions to convey the exposure below
The terms in Excel 1. Cell: The smallest part of the worksheet yng can be filled with a number of characters (max. 255 characters) cell contents can be a value, a formula or text. Example: cell A3, cell D5
2. Worksheet (Work sheet): a collection of 256 columns and 65,536 rows.
3. Workbook (workbook): is a collection of 256 worksheets (labeled Sheet1 until sheet 256)
4. Range: a group of cells that will mendapataksi same whether you run the appropriate command. Giving the address / addresses be done starting from the top left corner of the cell until the cell bottom right corner. Example: A4: D6 → range starting from cell A4 to cell D6
5. Relative Address: an address which, if written into the form of a formula or function will change if copied to another cell. Example: The cell contains a formula A5 * 6, B3 copied to C5 formula in C5 changed to B8 * 6
6. Absolut Semi Address: an address that was written with the $ sign in front of the line or kolomsehingga value will not change. Example: Cell B1 contains the formula $ A1 * 7, B1 copied his formula in D5 to D5 to $ A5 * 7
7. Absolute Address: an address that was written with the $ sign in front of the line and kolom.tekan the F4 key to generate an absolute address on the formula bar. Example: cell B1 contains the formula $ A $ 1 & 5, B1 C3 copied it to the formula in C3 to $ A $ 1 * 5
8. Name Box: to show the cell / range that is active at that time. You can also create a range name via the name box to the left of the formula bar. Example: Holla another name range A5: G7
Writing Formulas 1.Operasi Logic Below there is logic operations you can use resali operation or a comparison with the symbol that is used in Excel and its functions as follows: a. =: Equal b. >: Greater than c. <: Less than d. > =: Greater than or equal to e. <=: Less than or equal to f. <>: Not equal
2. Using Functions The function is actually existing formula provided by Excel 2003, which will assist in the process of calculation. We live use as needed. Generally the writing function must be equipped with the arguments, both erupa numbers, labels, formulas, cell address or range. This argument must be written with the enclosed brackets (). A. Logic Function Logic function is a function that is used to complete the calculations associated with decision-making logic functions used are: 1. If the function: Shape writing: = IF (condition, value if true, value if false) Example: = IF (A5 <17, "children", "adult")> 30, "hot", if (A5> 0, "warm", "cold")) 2. String Functions Function string functions to alter the content of the numeric text into numbers 1. Function VALUE: used to alter the value of value to the text, writing: = VALUE (text) 2. Function FIND: used to generate position substring from a string or a number to be searched, writing: = FIND (search text, the text, starting number) 3. MID Function used untu take a certain character from a series of characters, writing: = MID (text, start position, the number of characters) 4. LEFT or RIGHT functions: used to retrieve the substring to the left or right strings, writing or = RIGHT = LEFT (text, number of characters) 5. REPLACE function: used to replace the substring with another substring in a string (a series of characters or character), writing: = REPLACE (old text, initial number, the number of characters, the new text) 6. CONCATENATE Function: used to combine strings into one sentence maximum of 30 strings, writing: = CONCATENATE (text1, text2, ...) B. Function Table: HLOOKUP and VLOOKUP function is used to read a table in a vertical (VLOOKUP) or horizontally (HLOOKUP) penulisanya: = HLOOKUP (lookup_value, table_array, row_index_num, ...) = VLOOKUP (lookup_value, table_array, row_index_num, ...)
Frequently used functions 1. Sum function: Used to add a set of data on a single range, writing: = SUM (number1, number2, ..)
2. Function Average: Used to find the average value, writing: = average (number1, number2, ...) 3. Function Max: Used to find the highest value of data collection, writing: = max (number1, number2, ...) 4. Function Min: Used to find the lowest value of the data collection, writing: = max (number1, number2, ...) 5. function Count: Used to calculate the amount of data from the range that we choose 6. Function Stedev: Used to determine the standard devisiasi of a range, writing: = stedev (number1, number2, ...) 7. Function Var: Varience used to determine the value of a range, writing: = var (number1, number2, ...)
source:
http://aguskurnia.blogdetik.com/2009/06/10/materi-microsoft-excel-2003/