Local addresses The "A1" address system has coordinates that exist over the whole worksheet. If you have a block of data specified somewhere within that worksheet, it can be useful to be able to specify the addresses relative to that block. This can be done with INDEX(), which takes 3 arguments. The first argument is a rectangular range of data, for example A2:E8. The second and third arguments are numbers specifying an offset down then right from the top left of that data range. Unlike OFFSET(), the numbering starts at 1, so INDEX(A2:E8, 4, 2) refers to cell B5. Instructions Use the block of data for North East India + North Myanmar, from A11 to G19 as the reference. In cell I1, use INDEX() to get the number of Blues in Sikkim. In cell I2, get the number of White-yellows in Mizoram Hills. please show the formulas in excel thank you :)    Area Locality Skipper Swallowtail White-yellow Blue Brush-footed Blues in Sikkim   Indian Subcontinent Indian Subcontinent 307 94 99 458 482 White-yellows in Mizoram Hills   Western Himalaya Western Himalaya 63 31 42 129 152     Western Himalaya Kangra Hills 25 23 37 56 87     Western Himalaya Shimla Hills 41 21 34 88 115     Western Himalaya Dehradun Valley 22 11 19 42 54     Western Himalaya Mussoorie Hills 54 23 32 88 126     Western Himalaya Mussoorie Town 14 10 13 44 65     Western Himalaya Kumaon Hills 52 26 37 109 147     Central Himalaya Central Himalaya 125 43 49 185 221     North East India + North Myanmar North East India + North Myanmar 211 69 57 284 342     North East India + North Myanmar North East India 189 62 52 258 292     North East India + North Myanmar Sikkim 159 55 51 162 263     North East India + North Myanmar Darjeeling 27 29 32 48 126     North East India + North Myanmar Naga Hills 67 38 30 110 178     North East India + North Myanmar Manipur 119 18 1 126 57     North East India + North Myanmar Khasia Hills 98 42 36 128 207     North East India + North Myanmar Khasia + Jaintia Hills 132 49 40 166 209     North East India + North Myanmar Mizoram Hills 59 13 26 77 101     Other parts of India Kolkata 32 10 19 57 49     Other parts of India South Bihar 18 9 12 46 39     Other parts of India North Bihar 19 10 23 38 61     Other parts of India Lucknow 15 7 19 33 35     Other parts of India Dehli 11 4 20 22 20     Other parts of India Mhow 12 4 29 31 34     Other parts of India Jodhpur 14 6 21 20 17     Other parts of India Kathiawar 11 5 19 22 21     Other parts of India North Gujarat 4 5 18 17 15     Other parts of India South Gujarat 22 10 25 46 42     Other parts of India Pune 19 10 50 41 44     Other parts of India Konkan 23 11 19 35 42     Other parts of India Karwar 54 16 21 66 66     Other parts of India Coorg 60 18 31 80 89     Other parts of India Bangalore 20 9 25 50 36     Other parts of India Travancore 37 15 26 58 84     Other parts of India Palani Hills 46 15 30 83 75     Other parts of India Nilgiri Hills 64 23 35 82 90     Other parts of India Eastern Ghats 23 12 21 31 30     Other parts of India Sikanderabad 7 5 14 20 24     Other parts of India Andaman Nikobar 42 13 20 68 74     Sri Lanka Sri Lanka 48 15 29 82 68     North Myanmar Chindwin District 65 24 26 81 124     North Myanmar Arakan coast 21 15 21 42 60     North Myanmar Shan States 28 16 25 64 95     South Myanmar South Myanmar 189 50 40 272 237

@Build ER diagram

A pointer variable is O the same thing as an array subscript dereferences a pointer and allows access to the value of the variable the pointer points to an operator that returns the memory address of a variable a variable that holds an address

T The information in DNA is stored as a code made up of four chemical bases which are represented by four upper case letters A, T, G, C. An example DNA sequence could be: ATGAG An interesting phenomena here is that when two DNA sequences are attempted to combine, A can only pair with T whereas G can only pair with C. Two DNA sequences for example ATGC and TACG are considered 'fully complementary' because the bases (letters) in every index position can be paired to each other (see the image). ATGC ATGC ATGC XX TACG Fully Complementary TACC SNP TTCA CA Non Complementary Two DNA sequences for example ATGC and TACC are considered 'SNP type' because there is exactly one index position (last position in this case) in which the bases(letters) can not be paired. Two DNA sequences for example ATGC and TTCA are considered "non complementary' because there are more than one index position (second and fourth in this case) in which the bases can not be paired. Write a program that will ask the user…

Game of Hunt in C++ language   Create the 'Game of Hunt'.  The computer ‘hides’ the treasure at a random location in a 10x10 matrix. The user guesses the location by entering a row and column values. The game ends when the user locates the treasure or the treasure value is less than or equal to zero. Guesses in the wrong location will provide clues such as a compass direction or number of squares horizontally or vertically to the treasure. Using the random number generator, display one of the following in the board where the player made their guess: U#  Treasure is up ‘#’ on the vertical axis (where # represents an integer number). D# Treasure is down ‘#’ on the vertical axis (where # represents an integer number) || Treasure is in this row, not up or down from the guess location. -> Treasure is to the right. <- Treasure is to the left. -- Treasure is in the same column, not left or right. +$ Adds $50 to treasure and no $50 turn loss. -$ Subtracts…