Std VI | II Semester Revision | Lesson 7, Lesson 8 & Lesson 9
Std V Computer – Lesson 6 & 7 II Semester Revision Work Sheet Std VI Lesson 7, Lesson 8 & Lesson 9 – All Questions & Answers Lesson 7: Formula and Functions in Excel Lesson 8: Introduction to Small Basic Lesson 9: Popular Service on the Internet Lesson No. 7 – Formula and Functions in Excel A) Answer the Following Q1. What is a formula in Excel? Ans: A formula is used to perform calculations in Excel and starts with (=). Q2. State any one rule for writing a formula in Excel. Ans: A formula must begin with an equal (=) sign. Q3. What is cell referencing? Ans: It is the method of referring to cells in a formula. Q4. What is relative cell referencing? Ans: It changes automatically when copied. Q5. What is absolute cell referencing? Ans: It remains fixed and uses the $ symbol. Q6. Name any two types of functions in Excel. Ans: Mathematical and Text functions. B) True o...