你还在为考试焦头烂额?找我们就对了!

我们知道现在是考试月,你正在为了考试复习到焦头烂额。为了让更多留学生在备考与学习季更轻松,我们决定将Gold会员限时免费开放至2025年12月31日!原价£29.99每月,如今登录即享!无门槛领取。

助你高效冲刺备考!

题目

COMM_V 205 101 102 103 2025W1 Assignment B1 (Excel)

多项填空题

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))

查看解析

标准答案

Please login to view

思路分析

We are given a formula-building task in Excel where the goal is to extract the carat weight from the diamond_id stored in A2. The 2nd through 4th characters encode the weight in a three-digit form, and the WSCS rule is to display weights with two decimals. To construct something like 2.54 for an id containing 254, we need to piece together parts of the text with a decimal point in the correct place. Option by option reasoning: - First blank (the outer function name): The correct choice is CONCATENATE. We are joining a single-digit piece (the first digit of the 2nd-4th characters), a decimal p......Login to view full explanation