est Information escription structions Multiple Attempts Not allowed. This test can only be taken once. Force Completion This test can be saved and resumed later. Your answers are saved automatically. Question Completion Status: Moving to another question will save this response. 3:02 PM 5/29/2022 Prt sc F10 home insert delete CE 19 F6 F9 & backspace um 6 O A O R G H K enter shift B N M po ctrlQUIZ 2 HR DATA FILE(1) Search (Alt+Q) CHESHTA SHARMA Layout Formulas Data Review View Help - 11 A A E al Wrap Text ustom AutoSum AP O EEEE Fill Merge & Center $ % 9 08 498 Conditional Format as Cell Insert Delete Format Sort & Find & Formatting * Table Styles Clear Filter * Select Font Alignment Number Styles Cells Editing =VLOOKUP M N O Gross Monthly Deduction Deduction Deduction Deduction Rating Bonus Rate Bonus Rate 2 Bonus Rate 3 Bonus Rate 4 Salary Rate 1 Rate 2 Rate 3 Rate 4 $0.00 20.0% 15.0% 10.0% 17.5% 0.50% 0.35% 0.45% 0.55% 5,000 25.0% 20.0% 15.0% 21.5% 0.75% 0.55% 0.90% 1.00% 7,500 30.0% 25.0% 20.0% 25.5% 1.00% 0.75% 1.35% 1.45% 9,000 35.0% 30.0% 25.0% 29.5% 1.50% 0.95% 1.80% 1.90% 11.000 37.5% 35.0% 30.0% 33.5% 2.00% 1.15% 2.25% 2.35% 15,000 42.5% 10.0% 35.0% 37.5% 2.50% 1.35% 2.70% 2.80% 20,000 47.5% 45.0% 40.0% 41.5% 3.00% 1.55% 3.15% 3.25% 3.50% 1.75% 3.60% 3.70% 4.50% 1.95% 4.05% 4.15% 10 5.00% 2.15% 4.50% 4.60% ANSWERS 87 $ 294 141 POSTAL RATING EDUCATION BILINGUAL GENDER NET RATING EDUCATION DEPARTMENT AME FIRST CITY PROV GROSS MONTHLY CODE MONTHLY DEDUCTION MONTHLY BONUS BONUS BONUS FUNCT NAME SALARY SALARY BON Jennifer North York ON MOR 1VO 10 YES F 16,095 6,438 9,657 =VLOOKUP poks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in an ascending order x VLOOKUP Stouffville ON L2H 1G2 3 NO M 8,781 3,512 5,269 Harold nte Mary Thornhill ON L3J 1X3 NO 4,550 1,820 2,730 wood Margret Gormley ON L4H 1G4 6 YES 4,189 1,676 2,513 ON L5R 3M5 9 5 NO 5,926 2,370 3,556 Paula Oshawa Janet Osgoode ON K6A 2W6 YES 8,600 3.440 5, 160 ON K7A 2N7 NO 8.405 5.043 Vince RR #3 Manotick 3,362 ON YES 12,057 4,823 7,234 Shiela Scarborough M8W 3H8 SET + d to go pres. home end 2 insert delete CE F7 FB F9 J' FZ DIA FS 19% F6 num backspace lock O 6 W C P E R enter K v . D G shift B pg ctri po