FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Just like a basic formula, you need to start with the equal sign. After that, you would put the function name, then the range of cells inside parentheses, separated with a colon. For example: =SUM(B2:B5).

Detailed explanation-2: -A TRUE function is a logical function which returns the value TRUE. In excel, while calculating or applying any condition, we want that output to return a true value. In these scenarios, we use a TRUE function which is the built-in function in Excel.

Detailed explanation-3: -The TRUE Function[1] is categorized under Excel Logical functions. It will return the logical value of TRUE. The function is equivalent to using the Boolean value TRUE directly in a formula. In financial analysis, the TRUE function is often used with other logical functions such as IF, ERROR, etc.

Detailed explanation-4: -A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references. These are separated by calculation operators.