Question

Define function and formula in spreadsheet. ​

Answer 1

Answer:

Function:-

A function is a predefined formula. They are present in the function library group in formulas tab, under autosum option.

Some of the options available under autosum option are as follows:- Sum, Max, Min, Average, etc.

Example:- = SUM (A1:A10)

Formula:-

A formula is to be created by the user using the mathematical operations.

There are two types of formula:- Simple and Compound.

A Simple formula is made using one mathematical operator.

Example:- = (A1-B1)

A compound compound formula is made using more than one mathematical operator.

Example:- = (A1+B1)/100

Answer 2

Answer:

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.

Hope it helps you....✔✔✔