Question

define formula and function used in spreadsheet​

Answer 1

Answer:

A formula is an expression telling the computer what mathematical operation to perform upon a specific value. When referring to computer software, formulas are most often used in spreadsheet programs, such as Microsoft Excel.

Answer 2

Answer:

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)

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