ICSE Class 8 Computer Studies
Question 5 of 6
Spreadsheet - Formulas and Functions — Question 5
Back to all questions 5
Question Question 5
What do you mean by a Function? Name some of the Functions.
Functions are the pre-designed formulas in Excel to perform both simple and complex calculations. Functions begin with the equal to (=) sign followed by the function name and then the list of arguments separated by comma within the parenthesis. For example, =Function name (argument1, argument2....). Some of the commonly used functions are:
- SUM(range)
- AVERAGE(range)
- MAX(range)
- MIN(range)
- SQRT(number)