What do you mean by cell referencing?
What are the thee different types of referencing ? Explain with example?
What are the different errors that are reported while writing a formula?
Tell difference between formulae and function?
Write and explain all components of chart with diagram?
Write the use of the following functions with example
I. SUM
II. COUNT
III. AVERAGE
IV. MAX
V.
MIN
Answers
Step-by-step explanation:
What do you mean by cell referencing?
A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. In one or several formulas, you can use a cell reference to refer to: ... Data on other worksheets in the same workbook.
What are the thee different types of referencing ? Explain with example?
Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied.
What are the different errors that are reported while writing a formula?
Cells containing formulas that result in an error: A formula does not use the expected syntax, arguments, or data types. Error values include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. Each of these error values have different causes and are resolved in different ways.
Tell difference between formulae and function?
Write and explain all components of chart with diagram?
sorry but i don't know answer of these questions
Write the use of the following functions with example
I. SUM
II. COUNT
III. AVERAGE
IV. MAX
V.
MIN
sorry but i don't know answer of these questions
plzzz mark as brainlist