MS Excel (Fact)

MS excel  Row & Column.

1. 1,048,576 rows by 16,384 columns

2.Column width - 255

Character.

3.Row height : 409 point 

4. Zoom range : 10 % to 400%

5.Example Comment

=A1 -----Complete relative reference

=$A1 -----The column is absolute; the row is relative

=A$1 -----The column is relative; the row is absolute

=$A$1------- Complete absolute reference

* Column Size 0 - Min   & 255 - Maximum   & Default 8.43

* Row Size 0 - Min   & 409 - Maximum   & Default 15

6. Error

#DIV/0!------- Trying to divide by 0. जब हम लोग किसी संख्या को 0 से Divide करते हैं तब इस तरह का इरादा है)

#N/A! -------A formula or a function inside a formula cannot find the referenced data(जब कोई वैल्यू वहां पर एग्जिट ही नहीं करती तब ऐसी आती है)

#NAME? ---------Text in the formula is not recognized गलत Furmula use करने पर. (= Sum ( A1:A4) in place = Sums(A1:A4)

#NULL! ---------A space was used in formulas that reference multiple ranges; a

comma separates range references

अगर आप दो नंबर को जोड़ना चाहते हैं कुछ जगह पर आपने "+" का साइन ना लगा कर "  "(Intersect operator) uSe किया .

(=A1+A2 )की जगह आपने( =A1  A2)

#NUM! --------A formula has invalid numeric data for the type of operation. जब गलत नंबर enter किया जाएगा तब ex = Sqrt(5) but we use =sqrt(-5)  का square root नहीं होता

#REF! --------A reference is invalid ( 

Like VLookup formula total column is 4 and you will try to find tha value of 8 Column which is not exist.)

#VALUE! -----The wrong type of operand or function argument is use

Ex  = 4 * 6 इसकी जगह आपने 4 * A

6.Types of Chart

1. Column Chart - vertical bars is useused for comparing the information.

2.Line chart :-  the ups and downs in your data over time. In this chart, data points are connected with lines.

3.horizontal bars that work like column charts.but opposite.

4.Unlike the line charts, gaps are filled with color in area charts. Area charts are easy to analyze the growth in business as its shows ups and downs through line.

5.pie chart is a rounded shape graph that is divided into slices of pie.campare portion

Note:- Pie chart is also known as Doughnut chart. 

7.Surface chart is actually a 3D chart that helps to represent the data into a 3D landscape