# data[].attributes.body
The #VALUE error appears when a value is not the expected type. This can occur when cells are left blank when a function that is expecting a number is given a text value

# data[].attributes.body
#value error occurs when we are calculating any function in the cell and that cell do not contains number.

# data[].attributes.body
The #VALUE! error appears when a value is not the expected type.

# data[].attributes.headline
#VALUE error occurs when we calculate the sum or difference but not with a number but with other type of data like alphabet

# data[].attributes.subject
#VALUE error occurs when we calculate the sum or difference but not with a number but with other type of data like alphabet

# data[].attributes.headline
#value error occurs when we are calculating any function in the cell and that cell do not contains number. 

# data[].attributes.subject
#value error occurs when we are calculating any function in the cell and that cell do not contains number. 

# data[].attributes.headline
#VALUE error comes when we calculate the sum or difference but not with a number but with other type of data like alphabet

# data[].attributes.subject
#VALUE error comes when we calculate the sum or difference but not with a number but with other type of data like alphabet

# data[].attributes.headline
It come when we add Or perform any formula with  other type of data 

# data[].attributes.subject
It come when we add Or perform any formula with  other type of data 

# data[].attributes.headline
#REF! error comes when accidently we have deleted the referred cell

# data[].attributes.subject
#REF! error comes when accidently we have deleted the referred cell

# data[].attributes.headline
#RAF is caused when we accidently delete the reffered cell

# data[].attributes.subject
#RAF is caused when we accidently delete the reffered cell

# data[].attributes.headline
#REF! Is caused when  cell containing the number which is used in a formula is deleted. 

# data[].attributes.subject
#REF! Is caused when  cell containing the number which is used in a formula is deleted. 

# data[].attributes.headline
#REF! error comes when accidently we have deleted the referred cell

# data[].attributes.subject
#REF! error comes when accidently we have deleted the referred cell

# data[].attributes.headline
#REF! error is caused when accidentally we have deleted the referred cell

# data[].attributes.subject
#REF! error is caused when accidentally we have deleted the referred cell

# data[].attributes.body
#NAME error comes when we enter wrong cell add.

# data[].attributes.body
#NAME error comes when there is a spelling mistake in the formula or the formula is written in a wrong way. For example- mx is written instead of max

# data[].attributes.headline
#NAME = this error comes when there is some spelling error like mx should be written max, and mn - min

# data[].attributes.subject
#NAME = this error comes when there is some spelling error like mx should be written max, and mn - min

# data[].attributes.body
#DIV/0 = This type of error comes when we divide  a cell range by 0 or an empty cell
Utkarsh

# data[].attributes.body
#div/0 error occurs when there is a 0 in the cell or there is an empty cell.

# data[].attributes.headline
#div/di is a type of error when a cell is divided by an empty or an 0 cell

# data[].attributes.subject
#div/di is a type of error when a cell is divided by an empty or an 0 cell

# data[].attributes.headline
#DIV/0 error is an error in which we have divided a number by 0 or an empty cell

# data[].attributes.subject
#DIV/0 error is an error in which we have divided a number by 0 or an empty cell

# data[].attributes.headline
Divide/0- it come when we divide empty cell or 0 

# data[].attributes.subject
Divide/0- it come when we divide empty cell or 0 

# data[].attributes.headline
#DIV/0 error comes when there is the cell is being divided by 0 or an empty cell

# data[].attributes.subject
#DIV/0 error comes when there is the cell is being divided by 0 or an empty cell

# data[].attributes.headline
#NAME is a type of error is a error when their is a spelling error in the table like sum to sm and max, mx

# data[].attributes.subject
#NAME is a type of error is a error when their is a spelling error in the table like sum to sm and max, mx

# data[].attributes.headline
#div/di comes when that sell is been divided bay a zero

# data[].attributes.subject
#div/di comes when that sell is been divided bay a zero

# data[].attributes.body
#NAME error is caused when there is a spelling mistake in the formula or the cell address is written wrong.

# data[].attributes.headline
#Name- it come when we write incorrect cell range Or formula like we have written MX

# data[].attributes.subject
#Name- it come when we write incorrect cell range Or formula like we have written MX

# data[].attributes.headline
#NAME error comes when we enter wrong cell address or there is spelling mistake in the formula.

# data[].attributes.subject
#NAME error comes when we enter wrong cell address or there is spelling mistake in the formula.

# data[].attributes.headline
#NAME error is a error is which we have a written a wrong spelling Like we have written mx in place of max

# data[].attributes.subject
#NAME error is a error is which we have a written a wrong spelling Like we have written mx in place of max

# data[].attributes.body
Agrima Misra

Absolute reference maintains the values of a row and/or column. No changes to the referenced cells are made when a formula is copied from one cell to another.
Ex. The absolute value in cell A1 is written as A$1 in the formula. When the formula in cell = A$1*B1 is copied to C2 and C3, C2 and C3 will have the formula $A1*B2 and $A$1*B3 respectively. The value= A1= 3.14 remains unchanged.
Mixed cell reference combines absolute and relative referencing. In this type of reference, either the column or the row in a cell address is fixed.
Ex.
The formula in cell d2(B2*C$2)/100 has a mixed reference, i.e. a relative reference to column B and an absolute reference to row 2 of Column C. Column D calculates the discount(10%) of the prices of products in column A

# data[].attributes.headline
Function is a pre defined formula . A formula can be customise

# data[].attributes.subject
Function is a pre defined formula . A formula can be customise

# data[].attributes.body
A formula is an equation that makes calculations based on the data in your spreadsheet. For example, =A1+A2+A3,
A function is a predefined formula that performs calculations using specific values in a particular order. FOR EXAMPLE
=SUM(A1:A3)

# data[].attributes.headline
If we have to add two numbers and subtract it by another two numbers in a single go we cannot do that in function but we can do it in formula

# data[].attributes.subject
If we have to add two numbers and subtract it by another two numbers in a single go we cannot do that in function but we can do it in formula

# data[].attributes.body
A function is a predefined formula. Ex. Sum(). A formula is something which we can customise. Ex. +, /, %

# data[].attributes.headline
The difference between function and formula is that function is pre -defined while formula we can customize it

# data[].attributes.subject
The difference between function and formula is that function is pre -defined while formula we can customize it

# data[].attributes.headline
In a formula we can customize but in the Function we cannot

# data[].attributes.subject
In a formula we can customize but in the Function we cannot

# data[].attributes.headline
A function is a piece of code that executes a predefined calculation ex. Sum, while a formula is something you create yourself. ex. Ex. +, /, %

# data[].attributes.subject
A function is a piece of code that executes a predefined calculation ex. Sum, while a formula is something you create yourself. ex. Ex. +, /, %

# data[].attributes.body
This is a column chart

# data[].attributes.body
The autosum feature adds a range of numbers automatically.

# data[].attributes.body
The autofill feature generates series automatically.

# data[].attributes.body
It shows mixed cell referencing because it is fixing the rows.

# data[].attributes.body
This is a column chart.

# data[].attributes.body
Chart area- it is the entire area that includes all the chart elements.
Plot area- it is the area that includes the data plotted on the chart.

# data[].attributes.body
It is used to find the number of values in a cell range.

# data[].attributes.body
A. :
B. ^
C. *
D. +
E. >

# data[].attributes.body
Aryan

# data[].attributes.body
Aryan

# data[].attributes.body
Aryan

# data[].attributes.headline
It is mixed referencing because it is fixing either the row or column.

# data[].attributes.subject
It is mixed referencing because it is fixing either the row or column.

# data[].attributes.body
Aryan

# data[].attributes.body
Aryan

# data[].attributes.headline
Chart Area is the entire area that include all the chart element.Plot area is the area that include the data plotted on the chart.

# data[].attributes.subject
Chart Area is the entire area that include all the chart element.Plot area is the area that include the data plotted on the chart.

# data[].attributes.body
Aryan

# data[].attributes.headline
Count is generally a function used to count the number of cells in  Excel. There are two different ways to use COUNT in Excel.

# data[].attributes.subject
Count is generally a function used to count the number of cells in  Excel. There are two different ways to use COUNT in Excel.

# data[].attributes.body
Aryan

# data[].attributes.body
Aryan

# data[].attributes.body
Chart Area is the Entire Area that include all the chart element.
Ptol area is the area that include the data Plotted on the chart.

# data[].attributes.headline
Legend is the box that include the identification of the data plotted. The box contains colours or patterns assigned to the data.

# data[].attributes.subject
Legend is the box that include the identification of the data plotted. The box contains colours or patterns assigned to the data.

# data[].attributes.body
Chart area is the area that that includes all the chart Elements plot area is the area that includes the data plotted on the chart

# data[].attributes.headline
Chart area  is the entire area that includes all the chart elements and plot area is the area that includes the data plotted on the chart

# data[].attributes.subject
Chart area  is the entire area that includes all the chart elements and plot area is the area that includes the data plotted on the chart

# data[].attributes.body
Absolute cell reference

# data[].attributes.headline
CHART AREA IS THE ENTIRE AREA THAT INCLUDES ALL THE CHART ELEMENTSPLOT AREA IS THE AREA THAT INCLUDES THE DATA PLOTTED ON THE CHART.

# data[].attributes.subject
CHART AREA IS THE ENTIRE AREA THAT INCLUDES ALL THE CHART ELEMENTSPLOT AREA IS THE AREA THAT INCLUDES THE DATA PLOTTED ON THE CHART.

# data[].attributes.headline
CHART AREA IS THE ENTIRE AREA THAT INCLUDES ALL THE CHART ELEMENTSPLOT AREA IS THE AREA THAT INCLUDES THE DATA PLOTTED ON THE CHART

# data[].attributes.subject
CHART AREA IS THE ENTIRE AREA THAT INCLUDES ALL THE CHART ELEMENTSPLOT AREA IS THE AREA THAT INCLUDES THE DATA PLOTTED ON THE CHART

# data[].attributes.body
HE SHOULD CREATE COLUMN CHART

# data[].attributes.body
CHART AREA IS THE ENTIRE AREA THAT INCLUDES ALL THE CHART ELEMENTS
PLOT AREA IS THE AREA THAT INCLUDES THE DATA PLOTTED ON THE CHART

# data[].attributes.body
Count is generally a function used to count the number of cells in Excel.There are two different ways to use count in excel.

# data[].attributes.body
Column Chart

# data[].attributes.body
Absolute cell referencing

# data[].attributes.body
Pie chart

# data[].attributes.body
The plot area

# data[].attributes.body
Column chart

# data[].attributes.body
Absolute cell reference

# data[].attributes.body
Equal(=)

# data[].attributes.headline
The plot is the area on chart that displays data

# data[].attributes.subject
The plot is the area on chart that displays data

# data[].attributes.body
Absolute cell reference

# data[].attributes.body
The plot area

# data[].attributes.body
It is a mixed refrencing.It is so,because either the row or column is fixed.

# data[].attributes.body
Count is generally a function used to count the number of cells in Excel. There are two different ways to use Count in Excel.

# data[].attributes.body
The plot area

# data[].attributes.body
Absolute cell reference

# data[].attributes.body
IT IS A CIRCULAR CHART REPRESENTING A WHOLE

# data[].attributes.body
Control key

# data[].attributes.body
The control key

# data[].attributes.headline
COUNT is generally a function used to count the number of cells in Excel. There are two different ways to use COUNT in Excel.

# data[].attributes.subject
COUNT is generally a function used to count the number of cells in Excel. There are two different ways to use COUNT in Excel.

# data[].attributes.body
Absolute cell refrence

# data[].attributes.body
pie charts show the size of items in one data series, proportional to the sum of the items

# data[].attributes.headline
COUNT is generally a function used to count the number of cells in Excel. There are two different ways to use COUNT in Excel.

# data[].attributes.subject
COUNT is generally a function used to count the number of cells in Excel. There are two different ways to use COUNT in Excel.

# data[].attributes.body
The control key

# data[].attributes.body
Absolute reference

# data[].attributes.body
Column chart

# data[].attributes.headline
A$1+b$1 shows mixed referencing because it is fixing either the row or column

# data[].attributes.subject
A$1+b$1 shows mixed referencing because it is fixing either the row or column

# data[].attributes.body
Shaurya

# data[].attributes.body
Pie chart