题目
题目

COMM_V 205 101 102 103 2025W1 In-class Exercise (ICE) 3

多项填空题

Alex wants to calculate the income tax payable in British Columbia (federal + provincial combined) using the table below. Alex enters the taxable income in cell B15 and needs to calculate the tax payable in cell B16 using a VLOOKUP-based formula. The formula combines: Example: If Alex’s income is $100,000, it falls in the bracket starting at $98,560 with a 32.79% marginal rate. Tax =  ( Income − Bracket start ) × Marginal rate percentage + Base tax ($24,712)         =  (100,000 − 98,560) × 32.79% + $24,712        = $25,184.176 In cell B16, Alex enters the following formula: =VLOOKUP(B15,A3:C12,___) * (B15-VLOOKUP(B15,A3:C12,___)) / ___ + VLOOKUP(B15,A3:C12,___) Please fill the blanks to complete Alex's formula.   =VLOOKUP(B15,A3:C12,[Fill in the blank], ) * (B15-VLOOKUP(B15,A3:C12,[Fill in the blank], )) / [Fill in the blank], + VLOOKUP(B15,A3:C12,[Fill in the blank], )

题目图片
查看解析

查看解析

标准答案
Please login to view
思路分析
To approach this problem, we must map each blank in the VLOOKUP-based tax formula to the correct component from the BC tax table provided (Cut-offs, Marginal Tax, Base Tax). Option by option analysis: - First blank (in =VLOOKUP(B15,A3:C12,___)): what should this return? The intended value is the bracket start (the budget threshold at which the marginal rate applies). In the table, the bracket start values are in the first column (Cut-offs, column A). To retrieve a value from the first column using VLOOKUP, you specify the column index as 1. If you use 2, you would be retrieving the Marginal Tax value from the second column instead, which does not represent the bracket start. Therefore, choosing 2 would yield the wrong bracket-start value and break the calculation. - Second blank (in (B15-VLOOKUP(B15,A3:C12,......Login to view full explanation

登录即可查看完整答案

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

类似问题

P Q R 2 Target ISO Code Better than the Target 3 85 BEL FALSE Ruijing wants to check whether the country whose ISO code is entered in Q3 has better air quality than the target  in P3.  She entered a formula in R3. R3 should return logical: TRUE if the country's AIR value (i.e., its air quality index reported in the appropriate cell in column M) is greater than the target in P3. FALSE otherwise. Note: The screenshot shows Q3 is BEL (i.e., Belgium). But, Q3 can be any ISO code; R3 should always  evaluate based on the code in Q3 and the target in P3. Complete the formula in R3 by filling the blanks below. =XXX(XXX,B2:M181,12,XXX)XXXP3 (no $ signs and no blank spaces in your formula) In each blank, you may use only one of the following: a function name, a cell reference, a value (logical, text, or number), or a logical comparison operator. =[Fill in the blank] ([Fill in the blank] ,B2:M181,12,[Fill in the blank] )[Fill in the blank] P3    

T/F To answer the above question, one can also use the following formula. =VLOOKUP(A26,A2:C23,2,FALSE)&" "&"won the cup in"&" "&A26&"." Note: The " " instances represent strings consisting of a single blank space.  

In an attempt to impress his goggles-wearing doctor supervisor, Ryan created an inventory look-up tool on the Excel datasheet, called GoggleDoc (which stands for Goggles Doctor, not to be confused with GoogleDoc!). If one types the item number into cell B2, the tool will automatically return the area of the item in cell B4, and whether it is a sterile environment in cell B5. Select the correct pair(s) of formulas for cells B4 and B5. There is AT LEAST ONE correct option, but you MUST SELECT ALL correct options. [Note that the number of marks allocated to this question does NOT necessarily correspond to the correct number of options.]

In an attempt to impress his goggles-wearing doctor supervisor, Ryan created an inventory look-up tool on the Excel datasheet, called GoggleDoc (which stands for Goggles Doctor, not to be confused with GoogleDoc!). If one types the item number into cell B2, the tool will automatically return the area of the item in cell B4, and whether it is a sterile environment in cell B5. Select the correct pair(s) of formulas for cells B4 and B5. There is AT LEAST ONE correct option, but you MUST SELECT ALL correct options. [Note that the number of marks allocated to this question does NOT necessarily correspond to the correct number of options.]

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！