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) 
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Modern Database Management
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
12th edition
133544613, 978-0133544619
