For a given a diamond, the value in column C is the diamond’s carat weight. Jeremy typed the following formula in C2 to extract the diamond's carat weight from A2. And he copied it downward until the 10000th row. Please complete the formula. = XXX(XXX(A2,2, XXX), "XXX", XXX(A2,3,2)) Remember each diamond’s diamond_id contains information about carat weight of that diamond. In particular, the 2nd - 4th characters of diamond_id represent the weight (i.e. carat weight) and that every diamond sold by CSDS is under 10 carats. If the three-digit number (i.e., the three characters from the 2nd character to the 4thcharacter in the diamond_id) is 012, the weight recorded in column C is 0.12 carat. If it is 254, the weight is 2.54 carats. If it is 110, the weight is 1.10 carats. CSDS records the weights with exactly two decimals.   You may only use a function name or a single alpha-numeric character (i.e., A-Z, 0-9, !, ?, *, ., and @) in each space below. =[Fill in the blank], ([Fill in the blank], (A2,2,[Fill in the blank], ),"[Fill in the blank], ",[Fill in the blank], (A2,3,2)) 多项填空题