Computer Applications
What are functions? Explain the different parts of functions.
MS Excel
7 Likes
Answer
Functions are pre-designed formulas to perform simple and complex calculations.
Functions are made up of two parts:
- Arguments — Arguments are input values to functions. Arguments can be numbers, text, logical values like True or False, range of cell reference, or formulas that are enclosed within parenthesis.
- Structure — The Structure of a function defines its basic skeleton, which forms the base of writing general syntax of functions. The structure begins with the equal sign(=), function name and then followed by the list of arguments separated by a comma within the parenthesis.
The syntax of writing a function is as follows:
= FUNCTION NAME (argument1, argument2, argument3… )
Answered By
2 Likes
Related Questions
The other name of cell reference in MS Excel is cell address.
Alphanumeric data cannot be entered in a worksheet.
Can we find the average of more than one range of cells? If yes, what will be the structure of such a function?
What is the significance of COUNT() function? What type of data entries does the COUNT() function recognize?