Microsoft Excel 2010 - I — Question 1

Functions are pre-designed formulas to perform simple and complex calculations.

Functions are made up of two parts:

1. 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.
2. 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... )