Chapter 3 - FORMULAS AND FUNCTIONS
Chapter-3: FORMULAS AND FUNCTUIONS Q.1 QUESTIONS AND ANSWERS: A.What is a Formula?Explain with the help of examples. ANS. Formulas are used to perform calculations involving addition,subtraction,multiplication and division.It is an expression that can include cell addresses,numbers,arithmetic operators and paranthesis.FOR EX. SUM,AVERAGE,ETC. B.What is Cell Reference?Mention its types. ANS. The cell address in the formula is known as cell reference. There are three types of cell references: 1.Relative cell reference 2.Absolute cell reference 3.Mixed cell reference