Question

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​

Answer 1

Answer:

1)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.

2)There are several different styles of referencing:

APA.

MLA.

Oxford.

Harvard.

Chicago.

3)Excel displays the #VALUE! error when it finds spaces, characters, or text in a formula where it is expecting a number. Excel requires formulas to contain numbers only and won't respond to formulas associated with numbers, so it will show you an error is if you've included anything else.

4)A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.

5) chart area:

The chart area contains all chart components.

Chart title:

The chart title is often a descriptive text of what the chart displays.

Plot area:

The plot area refers to the location of the chart that shows the actual data represented by lines, bars, columns, dots etc.

Axis titles:

The x-axis and y-axis titles are easy to format and customize,

Chart series:

To change the looks of a data series simply double-click with left mouse button on the data series. If you want to only select a data point in the data series simply click again on the data point.

Legend:

You can easily customize the font, font size, font color etc of the chart legend:

Tick marks:

The image above shows tick mars in a line chart, there are two types of tick marks, major and minor tick marks. The chart above shows only major tick marks and the chart below displays both major and minor tick marks on both the x-axis and y-axis.

Final words

There is a really quick way to add chart elements, simply select the chart.

Click the "plus" sign and all chart elements show up. Select or deselect the elements you want