Question

How do formula work in a spreadsheet.

Answer 1

Answer:

Explanation:

Example

A Table having b3 :e4

So we can write =sum b3:e4

Answer 2

Answer:

• Formulas. In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.
• Functions. Functions are predefined formulas in Excel.