CBSE BOARD X, asked by bardhanmalina, 1 year ago

compare between formula and function

Answers

Answered by kajal292942

Answer:

The difference is that a function is a built-in calculation, while a formula is a user-defined calculationA formula could just use a single function. For example, if you enter =AVERAGE(A1:A56) , that is a formula, using the AVERAGE function

Answered by nitishakg

Answer:

a formula is any calculation in Excel, but a function is a pre-defined calculation. =MAX(A1:B20) is a formula containing a function. Mastering the use of functions in formulas is a key skill in learning financial modelling.

A formula starts with an = sign, such as =(D1+D2)/A$3 . ... The difference is that a function is a built-in calculation, while a formula is a user-defined calculation. A formula could just use a single function. For example, if you enter =AVERAGE(A1:A56) , that is a formula, using the AVERAGE function.

Previous Question

Next Question

Similar questions

Math, 6 months ago

निदेश:- 1. सभी प्रश्न अनिवार्य हैं। 2. प्रश्न 1 से 5 तक वस्तुनिष्ठ प्रकार के प्रश्न हैं। 3. प्रत्येक प्रश्न के आवंटित अंक उनके सम्मुख अंकित हैं। 4. जहाँ आवश्यक हो स्वच्छ नामांकित चित्र बनाइये। 05 प्रश्न-1. सही विकल्प चुनकर लिखिये। d.3.1212 i. निम्नलिखित में से कौन सी अपरिमेय संख्या है? a.0.23 b.0.2023002300023... C.0.2325 ii. निम्नलिखित में a./2x-1 b.x-1 c.x2+3x d.VR3-1 x+2 बहुपद iii. दो चरों...

Math, 6 months ago

एक प्राकृत संख्या का अभाज्य गुणनखंड , उसके गुणनखंडो के क्रम को छोड़ते हुए अद्वितीय होता है क्या?

Math, 6 months ago

hay guys please answer it correctly please yaar o . intergers hay ok . 1954+(2010)+(-1979) ...

Math, 1 year ago

Do anko ki sakhyao ke anko ka gudanfal 18 hai jab sakhya me se 27 ghtaya jata hai to sakhya ke sthan badal jate hai, sakhya yat kijiye...

Math, 1 year ago