Microsoft Advance Excel Using Logical Functions under free online training of computer courses in Rawalpindi
Working with numbers is not always easy. A complex formula that incorporates multiple ranges of cells can be difficult to understand. Individual cells that contain important information can be difficult to find in a large worksheet. cell references, as D5: D22 or A33: C33 are somewhat abstract, and not really communicate about the data they contain. In Excel you can create meaningful names to cells or ranges that can be used to overcome these difficulties. Technical Data used in the field explained in computer courses in rawalpindi. area names are significant strings that can be assigned to individual cells or cell ranges. You can use a range name, virtually anywhere you can use a cell reference or range. The advantage name comes from the fact that a name, such as employees, is more sensitive and less abstract than a reference as C2: C55. Also named ranges are absolutely standard, so if a formula is copied or AutoComplete using named ranges that original cell references will be maintained. Some more details of computer courses in rawalpindi are as under.
These logic functions are important in the advanced work to do in Excel because it can help control the behavior of spreadsheets based on certain logical conditions. This unit will focus on the use of logic functions IF, AND, OR. Excel 2010 includes an extensive library of functions you can call to help solve problems. These tools are available in the tape library formulas in the key group functions. Excel IF function can often be found very useful. You can use this function for different values or actions in a specific condition depending on the branch. The structure of a function If the following: IF (logical test value if true, value if false) And the function returns TRUE if all its arguments are true. If an argument is false, the function and returns FALSE. For example: <10 is true and instruction 2> logic 1 1 is also true. As a result, the connection instruction 1 <10 and 2> 1 is true because the two statements are true by Y are interconnected. The following figure shows this in Excel. You can have up to 255 logical arguments in Excel and function. The following table (often referred to as a truth table) can help to understand the AND function. In the last column of the truth table, you will see the value returned by the function, according to the values of the arguments of the function value. TSK Training for Skills and Knowledge is the best institute in Rawalpindi Islamabad for Pakistani Students who wants to join computer courses in rawalpindi.