Question

How many function categories and functions are there in Excel? What do you understand by automatic recalculation feature of a spreadsheet?

Answer 1

Explanation:

• A collection of pre written formulas can be defined as functions. These functions are special programs which accept the data and return a value after processing the data.
• There are 12 categories of functions includes compatibility, cube, Data and Time, Database, Financial, Engineering, Information, Logical, Lookup & reference, Statistics, mathematical and text.
• Some of the functions used in Excel are SUM(), Average(), MAX(), MIN(), COUNT(), COUNTA(), COUNTIF().
• One of the most powerful features in spreadsheet is that it recalculates automatically the result, when the source data got changed.
• This means, whenever a cell value is changed, it will automatically recalculates the value of any formula and displays in relevant cell.