Question

d.
What is the use of cell reference and cell range in formuls?
What are functions? How they are helpful?
e.​

Answer 1

Answer:

When you create a simple formula or a formula by that uses a function, you can refer to data in worksheet cells by including cell references in the formula arguments. For example, when you enter or select the cell reference A2, the formula uses the value of that cell to calculate the result.