Question

How many types of cell refrences explain? in 50-80 words​

Answer 1

Explanation:

$\setlength{\unitlength}{1cm}\begin{picture}(20,15)\thicklines\put(1,0){\framebox(4,0.7){Shatakshi}}\put (1,0.7){\framebox (4,0.7)}\put(1,1.4){\framebox (4,0.7)}\put (1,2.1){\framebox (4,0.7)}\put (1,2.8){\framebox (4,0.7)}\put (1,3.5){\framebox (4,0.7)}\put (1,4.2){\framebox (4,0.7)}\put (1,4.9){\framebox(4,0.7){@rian}}\put (1,5.6){\framebox (4,0.7){shiva}}\put(1,6.3){\framebox(4,0.7){@shraddha}}\put (1,7){\framebox(4,0.7){@Shashi+@Aditya}}\qbezier(5,7.5)(5,7.5)(8,7.5)\qbezier (8,7.5)(8,7.5)(8,7)\put (5.5,6.5){\framebox (4,0.5){Brainly\:Headquarters}}\qbezier(-1,0)(-1,0)(1,0)\qbezier (0,0)(0,0)(0,7.7)\qbezier (0,7.7)(0,7.7)(1,7.7)\qbezier(0.5,7.7)(0.5,7.7)(0.5,5)\put (0.2,4){\framebox (0.6,1)}\put (1,7.8){\framebox (4,1){\huge Welcome}}\qbezier (6,4)(6,4)(9,4)\qbezier(7.5,4)(7.5,4)(7.5,6.5)\qbezier (6,4)(6,4)(6,2)\qbezier (9,4)(9,4)(9,2)\qbezier (6,2)(6,2)(9,2)\qbezier (6.5,3.5)(6.5,3.5)(6.5,2.5)\qbezier(8.5,3.5)(8.5,3.5)(8.5,2.5)\qbezier(6,2.5)(6,2.5)(9,2.5)\qbezier (6.5,3.5)(6.7,3.4)(7.5,4)\qbezier (8.5,3.5)(8.3,3.4)(7.5,4)\qbezier (6.7,2.5)(6.7,2.5)(6.7,2.7)\qbezier (8.3,2.5)(8.3,2.5)(8.3,2.7)\qbezier (6.6,2.7)(6.6,2.7)(8.4,2.7)\qbezier (6.6,2.7)(6.6,2.7)(6.6,3.1)\qbezier (8.4,2.7)(8.4,2.7)(8.4,2.9)\qbezier (6.6,2.9)(6.6,2.9)(8.4,2.9)\put (6,2.1){\sf Shatakshi\:&\:Shraddha}\put(6,1.2){\sf Special\:sweet}\end{picture}$

Answer 2

Answer:

two types

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell.