What are formula and function?

Published on 11-Aug-2022

The system used for addition, subtraction, multiplication, division fixing of percentage etc on the basis of digits included in worksheet is called Formula. By using formula different acute Accounts works are done.

Such as we are to add digits kept in cell A1 and A2 then typing = A1 + A2 and pressing Enter the addition of the digits of the two cells will be available. Here = A1 + A2 is the formulas.

Function: The earlier preserved formula is the spreadsheet software for mathematical works is called Function. Each function has a short shop. Function is the short shop of formula where different Mathematical formulas are preserved earlier. That the process of using formulas in short shapes is called function, such as: To add A1, A2, A3, A4, A5 The formula is A1 + A2 + A3 + A4 + A5 where much time is needed to typist, and there is possibility of error. Using function, the above formula can be written as = SUM (A1: A5) Here SUM is function.

Quiz Practice

Correct Answer of previous question :
Total Answred:
Correct:
Wrong:
Accuracy(%):

More Article

 Tag  #

User Comments

Your name:


Your email:


Your Website (Optional):


Your Comments:


Type Author Name: