Question

E. Answer the following questions.
1. Define a formula.
2. What is the result if in a formula any cell has a missing or invalid value?
3. Which symbol is used before column/row to change relative reference to absolute reference?
4. What is cell referencing? Write names of different types of referencing.
5. Explain different components of a chart.​

Answer 1

Answer:

1) a formula is an expression that operates on values in a range of cells or a cell

2) If in a formula, any cell has a missing value or invalid value, the result is shown as #VALUE. This indicates that the formula could not be computed legally.

3) An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row.

4) There are two types of cell references: relative and absolute.

5)1) Chart area: This is the area where the chart is inserted.

2) Data series: This comprises of the various series which are present in a chart i.e., the row and column of numbers present.

3) Axes: There are two axes present in a chart. They are the x- axis and y- axis

MARK ME BRAINLIEST ✌✌✌✌✌✌✌

Answer 2

Explanation:

IT IS THE ANSWER OF THE BOOK ONLY