FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Formulas are entries in Excel that have equations, by which values are calculated. A typical formula might contain cell references, constants, and even functions.

Detailed explanation-2: -Ture or falsea) formula are entries that have an equation that calculates the variety to display. [ ] b) a cell reference refers to a cell or a range of cells on a insert tab. [ ]

Detailed explanation-3: -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-4: -Formulas are equations that perform calculations on values in our worksheet.

Detailed explanation-5: -To enter an Excel formula into a cell, you start with an equal (=) sign. Excel then knows that the expression that follows should be interpreted as a calculation, not text. After the equal sign, you enter the formula. For example, you can find the sum of the numbers in cells C2 and C3 by using the formula =C2+C3.