FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -All formulas begin with an equal sign (=). You can create a simple formula by using constant and calculation operator. For example, the formula =5+2*3, multiplies two numbers and then adds a number to the result. When you want to refer to variables instead of constants, you can use cell values, for example, =A1+A2.

Detailed explanation-2: -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-3: -Sometimes you need to check if a cell is blank, generally because you might not want a formula to display a result without input. In this case we’re using IF with the ISBLANK function: =IF(ISBLANK(D2), "Blank", "Not Blank")

Detailed explanation-4: -Another way is to use the keyboard shortcut, which is to press the Alt key and then the equals sign key on the numeric keypad. You can also find the equal sign in the Symbols menu under the Insert tab. Once you have inserted the equal sign into your spreadsheet, you can then use it to perform mathematical operations.

Detailed explanation-5: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.