Question

_____________ ਇਕ ਪਰਿਭਾਸ਼ਿਤ ਫਾਰਮੂਲਾ ਹੁੰਦਾ ਹੈ ਜੋ ਕਿਸੇ ਵਿਸ਼ੇਸ਼ ਕ੍ਰਮ ਵਿਚ ਵਿਸ਼ੇਸ਼ ਮੁੱਲਾਂ ਦੀ ਵਰਤੋਂ ਕਰਦਿਆਂ ਹੋਇਆਂ ਗਣਨਾ ਕਰਦਾ ਹੈ।

A _________ is predefined formula that performs calculations using specific values in a particular way.

एक _________ पूर्वनिर्धारित सूत्र है जो एक विशेष तरीके से विशिष्ट मानों का उपयोग करके गणना करता है। *

1) FILTER
2) SORTING
3)FUNCTION
4)NONE OF THESE​

Answer 1

A FUNCTION is a predefined formula that performs calculations using specific values in a particular way. (option 3)

• Functions can be defined as the predefined formulas with the help of which calculations are performed using some specific values which are called arguments. These perform calculations in a particular order or structure.
• Functions can be utilized to perform both simple as well as complex calculations.
• For example, the function AVERAGE determines the average of numbers in the selected range. Say, there are some numbers in the range from cell A1 to A10, then entering =AVERAGE(A1:A10) in a cell will return the average of these numbers in that cell.
• Thus, the correct answer will be "FUNCTION" that is, 'option 3'.

#SPJ1