Question

a) $D6
Answer the following:
What is a Formula? Explain with the help of examples.
What is Cell Reference? Mention its types.​

Answer 1

Answer:

1. A formula is an expression telling the computer what mathematical operation to perform upon a specific value. ... In the picture below is an example of a Microsoft Excel formula =SUM(A$1:A$3), which adds the total of cells A1, A2, and A3. In this formula, SUM is the function of the formula.

2.There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell.

Answer 2

Explanation:

xmadjgdhskgdkhwkhdkhaljdjtwjdnfhs