Question: Question 2 2 pts Given: table[[ Delta ,A,B, C ,D, E , F ,1],[1,,Weight (g) Over,Mail Format,Local Postage,Air Postage,,],[2,,1,Small Letter,12,25,,],[3,,20,Small Letter,18,35,,],[4,,50,Large Letter,25,45,,],[5,,100,Large Letter,35,60,,],[6,,500,Packet,45,120,,],[7],[8,,Sender,Weight (g),Mail Format,Local

Question 2\ 2 pts\ Given:\ \\\\table[[

\\\\Delta

,A,B,

C

,D,

E

F

,1],[1,,Weight (g) Over,Mail Format,Local Postage,Air Postage,,],[2,,1,Small Letter,12,25,,],[3,,20,Small Letter,18,35,,],[4,,50,Large Letter,25,45,,],[5,,100,Large Letter,35,60,,],[6,,500,Packet,45,120,,],[7],[8,,Sender,Weight (g),Mail Format,Local or Air?,Postage,],[9,,Simon,8.6,,Local,,],[10,,Tony,100.5,,Air,,],[11,,Kitty,48.7,,Local,,],[12,,Chloe,420.3,,Air,,]]\ Which of the following function can find out the Postage of Kitty?\

=IF(E11

)

=

(

Local, VLOOKUP(C11, B2:E6, 4, TRUE), VLOOKUP(C11, B2:E6, 3, TRUE)) \ =IF(E11

)

=

(

Local, VLOOKUP(C11, B2:E6, 4, TRUE), VLOOKUP(C11, B2:E6, 5, TRUE)) \ =VLOOKUP(C11, B2:E6, IF(E11

))

=

((

Air, 3, 4), TRUE) \ =VLOOKUP(C11, B2:E6, IF(E11

))

=

((

Local, 3, 4), TRUE) \ =V(L)/(O)O KUP(C11,C2:E6,IF(E11

))

=

((

Air,3,4),FALSE)

$Question 2\ 2 pts\ Given:\ \\\\table[[ \\\\Delta ,A,B, C,D, E, F,1],[1,,Weight$

Given: Which of the following function can find out the Postage of Kitty? =IF(E11="Local", VLOOKUP(C11, B2:E6, 4, TRUE), VLOOKUP(C11, B2:E6, 3, TRUE)) =IF(E11="Local", VLOOKUP(C11, B2:E6, 4, TRUE), VLOOKUP(C11, B2:E6, 5, TRUE)) =VLOOKUP(C11, B2:E6, IF(E11="Air", 3, 4), TRUE) =VLOOKUP(C11, B2:E6, IF(E11="Local", 3, 4), TRUE) =VLOOKUP(C11, C2:E6, IF(E11="Air", 3, 4), FALSE)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To find out the postage for Kitty we need to look at her weight and whether ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

Supply the answers to the incorrect answers. Please write the question # and the question part (ex. 1a, 1b, 2a, 2b, etc...). 1. The Dow Jones Industrial Average (DJIA) and the Standard & Poor's 500...

Hi, can you look over my assignment and let me know if it meets all the requirements? Here is the case study:: Exhibit 1 (continued) Panel B: Additional information from Hopkins's box of notes,...

Q1-Explain how the EBIT Chart works (inputs determining the outputs-the two lines on the chart Case Leahy Bread Company (LBC) in Cohen Finance Workbook, page 111( a 'caselette') SEE THE IS/BS MODEL &...

Math\t107-6381\t-\tQuiz\t#4\t-\tSchultz\t-\tDue\tFebruary\t21,\t2016\t-\tpage\t1\tof 3 Follow\tthese\tdirections\tcarefully. This\tquiz\tis\tdue\tby\t11:59\tEastern\ttime\ton\tFebruary\t21,\t2016. o...

complete excel spreadsheet using data in case study 4 A 8 c D E F G Calculations Lifetime Value Tuscan Lifestyles: Initial order $50 1 2 3 4 5 6 7 Timeo Year 1 Year 2 Year 3 Year 4 Year 5 2.30%...

Healthcare Budget Project. Please see attached instructions BUSI 523 BUDGET PROJECT GRADING RUBRIC Criteria Part 1: Financial Statement Analysis Part 1: Financial Statement Analysis Part 2: Budget...

I need help with this budget assignment, I have attached the instructions BUSI 523 BUDGET PROPOSAL INSTRUCTIONS Instructions: Complete each part of the following Case Study. You will need to use...

Consider the following LP:Maximize2 1 4 2 3 3 3 4z = x + x + x + xSubject to x1 + x2 + x3 = 4 x1 + 4x2 4x4 = 8 x1, x2, x3 0, x4 0(a) Convert the LP given above to the standard form in which the...

Let the degrees of the polynomials P(z) = a0 + a1z + a2z2 +· · ·+ anzn (an 0) And Q(z) = b0 + b1z + b2z2 +· · ·+ bmzm (bm 0) Be such that m ¥ n + 2. Use...

A trader places a stop order to sell at $ 2 . What best describes the action that the stop order will take when the $ 2 price is reached? A stop order to sell at $ 2 guarantees the position will be...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...