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. These are separated by calculation operators.

Detailed explanation-2: -Detailed Solution. The correct answer is =.

Detailed explanation-3: -Answer and Explanation: All Excel formulas begin with the (c) equal sign (=).

Detailed explanation-4: -The dollar sign in an Excel cell reference affects just one thing-it instructs Excel how to treat the reference when the formula is moved or copied to other cells. In a nutshell, using the $ sign before the row and column coordinates makes an absolute cell reference that won’t change.

Detailed explanation-5: -The AND function returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE. One common use for the AND function is to expand the usefulness of other functions that perform logical tests.