FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Formulas are equations that perform calculations on values in your sheet. 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.

Detailed explanation-2: -In Microsoft Excel, a formula is an expression that operates on values in a range of cells. These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division.

Detailed explanation-3: -You might think multiplying values in Excel has its own formula or uses the “x” character to denote multiplication between multiple values. Actually, it’s as easy as an asterisk-*. To multiply two or more values in an Excel spreadsheet, highlight an empty cell.

Detailed explanation-4: -A formula in Excel is used to do mathematical calculations. Formulas always start with the equal sign ( = ) typed in the cell, followed by your calculation. Formulas can be used for calculations such as: =1+1.