FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula. For example, the following formula multiplies 2 by 3 and then adds 5 to that result to come up with the answer, 11.

Detailed explanation-2: -Mathematical operators All formulas in Excel must begin with an equals sign (=). This is because the cell contains, or is equal to, the formula and the value it calculates.

Detailed explanation-3: -All formulas in spreadsheet programs, like Microsoft Excel, OpenOffice Calc, and Google Sheets start with an equal sign (=). To display an equal sign, but not have it start a formula, you must “escape” the cell by entering a single quote (’) at the beginning.

Detailed explanation-4: -Equal signs start all formulas. Constants, such as numbers or text values, can be entered directly into a formula. Operators specify the kind of calculation that the formula performs. For example, the ^ (caret) operator raises a number to a power, and the * (asterisk) operator multiplies numbers.

Detailed explanation-5: -Equal Sign (=) The most commonly used symbol in Excel is the equal (=) sign. Every single formula or function used has to start with equals to let Excel know that a formula is being used. If you wish to reference a cell in a formula, it has to have an equal sign before the cell address.