FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -IF is one of the Logical functions in Microsoft Excel, and there are 3 parts (arguments) to the IF function syntax: logical test: TEST something, such as the value in a cell. value if true: Specify what should happen if the test result is TRUE. value if false: Specify what should happen if the test result is FALSE.

Detailed explanation-2: -A function is called by using the function name, followed by a set of parentheses containing the data to be passed to the function. The data passed to the function are referred to as the “actual” parameters.

Detailed explanation-3: -Almost all functions require arguments enclosed in parentheses and separated by commas. If arguments are required, do not place any spaces between the function name and the left parenthesis. Syntax rules must be followed. Text strings must be enclosed in quotes.

Detailed explanation-4: -The TODAY function syntax has no arguments. Note: Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39, 447 days after January 1, 1900.