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

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

助你高效冲刺备考!

题目
题目

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

多项填空题

For a given a diamond, the letter in column B is the diamond’s cut. Jeremy knew that he could have just typed =LEFT(A2,1) in B2. But, he wanted to test his nesting skills in B2. He typed the following formula instead. He has confirmed that he has gotten the same result as =LEFT(A2,1). Please complete the blanks in the formula. =XXX (A2, XXX ( XXX (A2,LEN(A2)-1),A2),LEN(A2)-1,"") You can only use function names. There is no space in the formula below. =[Fill in the blank], (A2, [Fill in the blank], ( [Fill in the blank], (A2,LEN(A2)-1),A2),LEN(A2)-1,"")

查看解析

查看解析

标准答案
Please login to view
思路分析
The question presents a nested formula puzzle and asks you to fill in three blanks with function names, using only function names and no spaces. The goal is to produce a formula that yields the same result as LEFT(A2,1), i.e., the first character of A2. Option evaluation: - The first blank corresponds to the outermost function name. If we want to remove all characters after the first one, a natural choice is REPLACE, since REPLACE allows replacing a portion of a text with something else (including an empty string). Using REPLACE(A2, ..., ..., "") will return the kept portion and drop the rest. - The second blank is used inside the second argument of the outer function. In the intended structure,......Login to view full explanation

登录即可查看完整答案

我们收录了全球超50000道考试原题与详细解析,现在登录,立即获得答案。

类似问题

Question 11: Data Analytics [13 Marks]Figure 3 provides the formula syntax that may assist you in completing your answers. Figure 3  Excel Formula SyntaxPlease read the scenario below and review the corresponding Excel workbook (Figure 4), then answer the questions that follow. You are an accountant at TrailBlaze, an outdoor equipment retailer based in Melbourne. The store uses Excel to track its product sales. Figure 4 provides a snapshot of the sales analysis for August 2025. Complete the analysis by answering the following questions. Figure 4  Sales Analysis for TrailBlaze Outdoor Store Required:[Fill in the blank] Using the data provided in the “Commission Rate Table”, construct a formula in Cell H5 to calculate the commission rate for each transaction. Ensure that the formula can be copied down to Cell H14 without any modification. (7 Marks)[Fill in the blank] In the table titled “Sales Analysis – Summary by Product Type”, construct a formula in Cell B24 to calculate the total sales for the product type listed in Cell A24. Ensure the formula can be copied down to Cell B27 to calculate the total sales for the product types listed in Cells A25 to A27, without requiring any modification. (6 Marks)[Fill in the blank]

Consider a fictional (and artificial) language called Nonia. Nonia and English share many similarities. Every English word that contains "ia" (whether at the beginning, middle, or end) translates to "istan" in Nonia. For example, the English word "liar" becomes "listanr" in Nonia. This rule applies to country names as well. You are given a table listing country names containing "ia" and your task is to translate each one into Nonia (i.e., complete column B, cells B2:B39). A portion of the table is omitted. Note that no country name begins with "ia". Type your formula in cell B2, and then drag it down to cell B39. A B 1 English Nonia 2 Albania Albanistan 3 Algeria Algeristan 4 Australia Australistan XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 37 Tunisia Tunisistan 38 Tanzania Tanzanistan 39 Zambia Zambistan   The (partially redacted) formula is: =XXX(A2, XXX("XXX",A2),2,"XXX")   Complete the following formula for cell B2: Note: Unless absolutely necessary, do NOT include spaces or extra brackets ( ) in your formula either. =[Fill in the blank] (A2,[Fill in the blank] ("[Fill in the blank] ",A2),2,"[Fill in the blank] ")  

Create a new column, better than its region's average, in column N of the same worksheet. It should indicate whether a country's air quality index (i.e., AIR in column M) is greater than the average AIR for all countries in the same region (the region is in column D). The following formula is entered in N2 and dragged all the way down to N181. Parts of the formula are redacted.  =IF(M2*COUNTIFS(XXX,XXX)>SUMIFS($M$2:$M$181,XXX,XXX),"YES","NO") Examples: Argentina (row 8):  Region = Latin America & Caribbean (D8). N8 = YES because M8 is greater than the region's average AIR.  Albania (row 3): Region = Eastern Europe (D3). N3 = NO because M3 is less than the region's average AIR. Please complete the formula in N2 by selecting right options from drop-downs. =IF(M2*COUNTIFS( [ Select ] D$2:D$181 D2:D181 $D$2:D181 D2:$D$181 $D2:$D181 , [ Select ] N2 B2 M2 D2 )>SUMIFS($M$2:$M$181, [ Select ] D2:D181 D2:$D$181 $D$2:D181 $D2:$D181 $D$2:$D$181 , [ Select ] $D$2 D$2 M$2 $D2 $M2 $M$2 ),"YES","NO")  

Suppose B1 contains the text Lake Havasu There is no space in B1, except a single space between two words Lake and Havasu.  Now, in cell B2, you executed the following formula  =IF(B1<>TRIM(B1),SUBSTITUTE(B1,RIGHT(B1,LEN(B1)-SEARCH(" ",B1)),"Havasu"),"Caspien") What is the output returned in B2. There is a single space in the formula which is in the first argument of SEARCH (i.e., " ") in the formula.

更多留学生实用工具

为了让更多留学生在备考与学习季更轻松,我们决定将Gold 会员限时免费开放至2025年12月31日!