FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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.

Detailed explanation-2: -Excel uses standard operators for formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents. All formulas in Excel must begin with an equals sign (=).

Detailed explanation-3: -To multiply in Excel you’ll need to write your formula with the arithmetic operator for multiplication, the asterisk symbol (*).

Detailed explanation-4: -Logical operators in Excel are also known as comparison operators. They are used to compare two or more values. The return output given by these operators is either TRUE or FALSE. We get a TRUE value when the conditions match the criteria and FALSE as a result when the conditions do not match the criteria.

Detailed explanation-5: -The syntax for the Excel AND function is as follows: AND(logical1, [logical2], …) Where logical is the condition you want to test that can evaluate to either TRUE or FALSE. The first condition (logical1) is required, subsequent conditions are optional.