Question 18 1 Point ... + 1 2 Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name VET HOLD LOLLY Watch Calculation Function Used Time Reference Trig Fy ET Calcula Function Arguments Function Library ? X Calculation HLOOKUP HLOOKUP X fx =HLOOKUP() Lookup value A - any A B C D E Table_array = number 1 RAMLI TRADING Row_index_num - number Cate- Commission Commission Range_lookup - logical 3 gory Name Total Sales Rate Amount 4 4 D Ahmed 35,000 =HLOOKUP() Looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify. 5 F Khalid 41,000 6 A Hend 37,000 Lookup_value is the value to be found in the first row of the table and can be a value, a reference, or a 7 7 E Fatima 43,000 text string 8 B Abdul 39,000 9 D Waleed 45,000 Formula result = 10 A Hajjar 11 TOTALS Helpon this function Cancel 12 22 23 Rate of Commission Table 24 Sales 39,000 43,000 37,000 41,000 45,000 35,000 25 Commission Rate 6.50% 7.00% 6.25% 6.75% 7.50% 6.00% 26 27 35,000 OK To find the commission rate from rate of commission table the range_lookup box should left empty A True B) False Question 19 1 Point in lookup value we can add false if the table is not sorted instead of zero A) True B False