Working with cell addressesThe address of a cell in Google sheets can be specified in two ways: either as a letter-number pair like C5, or as a pair of numbers like "row 5, column 3". Some formulas may be easier to specify on one way or the other, so it's useful to know how to convert from one form to the other and back.ROW() and COLUMN() take addresses in A1 format and return the number of the row and column respectively.ADDRESS() takes numeric row and column inputs and returns the address in A1 format. It also has an option argument to specify the relativity of the addresses: 1 (the default) returns absolute addresses; 2, 3, and 4 return row absolute, column absolute, and relative addresses respectively.In this chapter you'll be working with Indian butterfly data from Singh and Pandey.InstructionsIn column H, get the row numbers of the Locality column.In column I, get the column numbers of that column.In column J, convert columns H and I back to addresses in $A$1 absolute format.In column K, convert columns H and I back to addresses in A1 relative format.AreaLocalitySkipperSwallowtailWhite-yellowBlueBrush-footedRowColumnAbsoluteRelativeIndian SubcontinentIndian Subcontinent307949945848222 Western HimalayaWestern Himalaya63314212915232 Western HimalayaKangra Hills252337568742 Western HimalayaShimla Hills4121348811552 Western HimalayaDehradun Valley221119425462 Western HimalayaMussoorie Hills5423328812672 Western HimalayaMussoorie Town141013446582 Western HimalayaKumaon Hills52263710914792 Central HimalayaCentral Himalaya1254349185221102 North East India + North MyanmarNorth East India + North Myanmar2116957284342112 North East India + North MyanmarNorth East India1896252258292122 North East India + North MyanmarSikkim1595551162263132 North East India + North MyanmarDarjeeling27293248126142 North East India + North MyanmarNaga Hills673830110178152 North East India + North MyanmarManipur11918112657162 North East India + North MyanmarKhasia Hills984236128207172 North East India + North MyanmarKhasia + Jaintia Hills1324940166209182 North East India + North MyanmarMizoram Hills59132677101192 Other parts of IndiaKolkata3210195749202 Other parts of IndiaSouth Bihar189124639212 Other parts of IndiaNorth Bihar1910233861222 Other parts of IndiaLucknow157193335232 Other parts of IndiaDehli114202220242 Other parts of IndiaMhow124293134252 Other parts of IndiaJodhpur146212017262 Other parts of IndiaKathiawar115192221272 Other parts of IndiaNorth Gujarat45181715282 Other parts of IndiaSouth Gujarat2210254642292 Other parts of IndiaPune1910504144302 Other parts of IndiaKonkan2311193542312 Other parts of IndiaKarwar5416216666322 Other parts of IndiaCoorg6018318089332 Other parts of IndiaBangalore209255036342 Other parts of IndiaTravancore3715265884352 Other parts of IndiaPalani Hills4615308375362 Other parts of IndiaNilgiri Hills6423358290372 Other parts of IndiaEastern Ghats2312213130382 Other parts of IndiaSikanderabad75142024392 Other parts of IndiaAndaman Nikobar4213206874402 Sri LankaSri Lanka4815298268412 North MyanmarChindwin District65242681124422 North MyanmarArakan coast2115214260432 North MyanmarShan States2816256495442 South MyanmarSouth Myanmar1895040272237452

Question

Working with cell addressesThe address of a cell in Google sheets can be specified in two ways: either as a letter-number pair like C5, or as a pair of numbers like &#34;row 5, column 3&#34;. Some formulas may be easier to specify on one way or the other, so it's useful to know how to convert from one form to the other and back.ROW() and COLUMN() take addresses in A1 format and return the number of the row and column respectively.ADDRESS() takes numeric row and column inputs and returns the address in A1 format. It also has an option argument to specify the relativity of the addresses: 1 (the default) returns absolute addresses; 2, 3, and 4 return row absolute, column absolute, and relative addresses respectively.In this chapter you'll be working with Indian butterfly data from Singh and Pandey.InstructionsIn column H, get the row numbers of the Locality column.In column I, get the column numbers of that column.In column J, convert columns H and I back to addresses in $A$1 absolute format.In column K, convert columns H and I back to addresses in A1 relative format.AreaLocalitySkipperSwallowtailWhite-yellowBlueBrush-footedRowColumnAbsoluteRelativeIndian SubcontinentIndian Subcontinent307949945848222  Western HimalayaWestern Himalaya63314212915232  Western HimalayaKangra Hills252337568742  Western HimalayaShimla Hills4121348811552  Western HimalayaDehradun Valley221119425462  Western HimalayaMussoorie Hills5423328812672  Western HimalayaMussoorie Town141013446582  Western HimalayaKumaon Hills52263710914792  Central HimalayaCentral Himalaya1254349185221102  North East India + North MyanmarNorth East India + North Myanmar2116957284342112  North East India + North MyanmarNorth East India1896252258292122  North East India + North MyanmarSikkim1595551162263132  North East India + North MyanmarDarjeeling27293248126142  North East India + North MyanmarNaga Hills673830110178152  North East India + North MyanmarManipur11918112657162  North East India + North MyanmarKhasia Hills984236128207172  North East India + North MyanmarKhasia + Jaintia Hills1324940166209182  North East India + North MyanmarMizoram Hills59132677101192  Other parts of IndiaKolkata3210195749202  Other parts of IndiaSouth Bihar189124639212  Other parts of IndiaNorth Bihar1910233861222  Other parts of IndiaLucknow157193335232  Other parts of IndiaDehli114202220242  Other parts of IndiaMhow124293134252  Other parts of IndiaJodhpur146212017262  Other parts of IndiaKathiawar115192221272  Other parts of IndiaNorth Gujarat45181715282  Other parts of IndiaSouth Gujarat2210254642292  Other parts of IndiaPune1910504144302  Other parts of IndiaKonkan2311193542312  Other parts of IndiaKarwar5416216666322  Other parts of IndiaCoorg6018318089332  Other parts of IndiaBangalore209255036342  Other parts of IndiaTravancore3715265884352  Other parts of IndiaPalani Hills4615308375362  Other parts of IndiaNilgiri Hills6423358290372  Other parts of IndiaEastern Ghats2312213130382  Other parts of IndiaSikanderabad75142024392  Other parts of IndiaAndaman Nikobar4213206874402  Sri LankaSri Lanka4815298268412  North MyanmarChindwin District65242681124422  North MyanmarArakan coast2115214260432  North MyanmarShan States2816256495442  South MyanmarSouth Myanmar1895040272237452

Accepted Answer

A worksheet is a single sheet that contains its own set of cells to help you organize your data.…

Area	Locality	Skipper	Swallowtail	White-yellow	Blue	Brush-footed	Row	Column	Absolute	Relative
Indian Subcontinent	Indian Subcontinent	307	94	99	458	482	2	2
Western Himalaya	Western Himalaya	63	31	42	129	152	3	2
Western Himalaya	Kangra Hills	25	23	37	56	87	4	2
Western Himalaya	Shimla Hills	41	21	34	88	115	5	2
Western Himalaya	Dehradun Valley	22	11	19	42	54	6	2
Western Himalaya	Mussoorie Hills	54	23	32	88	126	7	2
Western Himalaya	Mussoorie Town	14	10	13	44	65	8	2
Western Himalaya	Kumaon Hills	52	26	37	109	147	9	2
Central Himalaya	Central Himalaya	125	43	49	185	221	10	2
North East India + North Myanmar	North East India + North Myanmar	211	69	57	284	342	11	2
North East India + North Myanmar	North East India	189	62	52	258	292	12	2
North East India + North Myanmar	Sikkim	159	55	51	162	263	13	2
North East India + North Myanmar	Darjeeling	27	29	32	48	126	14	2
North East India + North Myanmar	Naga Hills	67	38	30	110	178	15	2
North East India + North Myanmar	Manipur	119	18	1	126	57	16	2
North East India + North Myanmar	Khasia Hills	98	42	36	128	207	17	2
North East India + North Myanmar	Khasia + Jaintia Hills	132	49	40	166	209	18	2
North East India + North Myanmar	Mizoram Hills	59	13	26	77	101	19	2
Other parts of India	Kolkata	32	10	19	57	49	20	2
Other parts of India	South Bihar	18	9	12	46	39	21	2
Other parts of India	North Bihar	19	10	23	38	61	22	2
Other parts of India	Lucknow	15	7	19	33	35	23	2
Other parts of India	Dehli	11	4	20	22	20	24	2
Other parts of India	Mhow	12	4	29	31	34	25	2
Other parts of India	Jodhpur	14	6	21	20	17	26	2
Other parts of India	Kathiawar	11	5	19	22	21	27	2
Other parts of India	North Gujarat	4	5	18	17	15	28	2
Other parts of India	South Gujarat	22	10	25	46	42	29	2
Other parts of India	Pune	19	10	50	41	44	30	2
Other parts of India	Konkan	23	11	19	35	42	31	2
Other parts of India	Karwar	54	16	21	66	66	32	2
Other parts of India	Coorg	60	18	31	80	89	33	2
Other parts of India	Bangalore	20	9	25	50	36	34	2
Other parts of India	Travancore	37	15	26	58	84	35	2
Other parts of India	Palani Hills	46	15	30	83	75	36	2
Other parts of India	Nilgiri Hills	64	23	35	82	90	37	2
Other parts of India	Eastern Ghats	23	12	21	31	30	38	2
Other parts of India	Sikanderabad	7	5	14	20	24	39	2
Other parts of India	Andaman Nikobar	42	13	20	68	74	40	2
Sri Lanka	Sri Lanka	48	15	29	82	68	41	2
North Myanmar	Chindwin District	65	24	26	81	124	42	2
North Myanmar	Arakan coast	21	15	21	42	60	43	2
North Myanmar	Shan States	28	16	25	64	95	44	2
South Myanmar	South Myanmar	189	50	40	272	237	45	2