FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The IF function is useful when you want to assign a value to a cell based on a logical test. Goal seeking assumes you can change the value of multiple cells referenced directly or indirectly to reach a specific goal for a value of another cell.

Detailed explanation-2: -The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.

Detailed explanation-3: -You can use the INDEX and MATCH functions together to get the same results as using LOOKUP or VLOOKUP. The formula uses the value “Mary” in cell E2 and finds “Mary” in column A. It then matches the value in the same row in column C. Because “Mary” is in row 4, the formula returns the value from row 4 in column C (22).

Detailed explanation-4: -A logical test can be a comparison between two cell references such as A2>B1. Or A logical test can be a comparison between a cell reference and a fixed amount such as C7>= 100. A comparative operator will always return a True or False result. Excel recognized True and False Statements as 1 and 0.