I Format U Tel Tell me what you General $-% Merge & Center NI For Sort G 1 0 144 SO 315 415 405 331 217 69 20 1 OEN School Name D 2 CIM Mary Street School for treational Studies Norber of est Museenwoor IM University Malborhood High School 31 Exide Community 391 GO 385 49 DIMAS SATELLITE ACADEMY FOREST 183 69 IMSIS Lower East Side Program School 26 10 * CIMS imploration into , Tech and 373 GIMSSO CASCADES ON SOHOOL 42 110 512 314 SU 5 IMGARD HIGH SCHOOL EARLY COLLEGE 35 563 411 401 401 10 MOT AMERICAN SIGN LANG NG DUAL 938 630 608 11 SE FOOD AND FRANCE HIGH SCHOOL 11 30 695 12 MOHON SCHOOL FOR HIST AND COMM 422 412 9 11 9 h School of Hory Management 51 12 BE 14 M2 PACE HIGH SCHOOL 92 191 15 M100 urbanem fchool of Design and Construction 73 4 16 OMSON The facing stary School 446 415 17 OM3 Urban Asembly Academy of Governando s az LOWER STAR ARTS ACADEMY 4 411 400 433 1902MS1 The lane. Baldwin School 35 383 20 M316 Urban Assembly School of Business for Women 423 194 21 M374 GRAMACY ARTS HIGH SCHOOL 391 49 22 MOO HIGHS HSCHOOL INVENMINTL STUDIES 995 376 386 216 23 Mo Institute for Collaborative Ideas 465 40 42 24 M Profesional Performing Artschool 69 465 25 M11 Baruch College Campus High School 499 581 26 OM412 New York City Laboratory School Coll Studies 528 108 561 27 MAI SCHOOL OF THE FUTURE 79 466 28 02414 NEW YORK CITY MUSEUM SCHOOL 654 29 M16 ELEANOR ROOSEVELTHIGHSCHOOL 560 30 Min High School 512 52 31 MIS LANDMARK SCHOOL 30 32 CM HIGH SCHOOL HETH PROFUMAN 250 33 OM HIGH SCHOOL LEADERSHIP PUB WC 74 419 14 OM LEGACYSCH INTEGRATED STUDES 13 256 15 M19 MANHATTAN VLLAGE ACADEMY 470 473 36 021440 Bayard Rush School Humanities 136 387 190 3.79 37 OMLA VANGUARD HIGH SCHOOL 54 167 195 15 OMS MAATAN INTERNATIONAL HIGH SCHOOL 31 418 415 39 DMGO WASHINGTON IRVING HIGH SCHOOL 163 368 804 40 METS STUYVESANT HIGH SCHOOL 66 735 678 41 14 ofico And Finance 147 453 sai 42 OMSOO UNITY HIGH SCHOOL 371 465 43 JMS19 TALENTUM IMITED HIGH SCHOOL 44 OMS 20 MURRY BERGTRAUM HIGH SCHOOL 45 02MS29 queline Kennedy Onassis High School 430 424 398 397 46 OMS 1 NEW YORK CITY PUBS RIP COMP 47 0242 MANHATTAN BRIDGE HIGH SCHOOL 3: 380 Penh Problem 2 Prima 96 EN LES 47 199 31 161 124 207 Copy Paste B I U Will ildl M li $ Format Merge & Center K18 D E G 345 390 404 416 B 47 UZM4Z MANHATTAN BRIDGE HIGH SCHOOL 48 02M543 NEW DESIGN HIGH SCHOOL 49 02MS44 INDEPENDENCE HIGH SCHOOL 50 02M545 Dual Language and Asian Studies High School 51 02M550 Liberty High School Academy for Newcomers 52 021551 New York Harbor High School 53 02MS60 City as School 54 02M565 URBAN ACADEMY 55 02570 Satellite Academy High School 56 02M575 Manhattan Comprehensive Night Day High School 57 02M580 Richard R Green High School of Teaching 58 02M586 HARVEY SCHOOL 59 02M600 HIGH SCHOOL FASHION INDUSTRIES 60 02M605 HUMANITIES PREPARATORY ACADEMY 61 02M615 Chelsea Career and Technical Education High School 62 02M620 NORMAN THOMAS HIGH SCHOOL 63 02M625 HS of Graphic Commnctn And Art 64 02M630 HIGH SCHOOL OF ART AND DESIGN 65 02M655 LIFE SCIENCES SECONDARY SCHOOL 66 02M690 SCHOOL FOR THE PHYSICAL CITY 67 03M283 MANHATTAN THEATRE LAB HIGH SCHOOL 68 03M299 High School For Arts, Imagination And Inquiry 69 03M307 Urban Assembly School For Media Studies 70 03M415 WADLEIGH SECONDARY SCHOOL 71 031470 LOUIS D BRANDEIS HIGH SCHOOL 72 03M479 BEACON SCHOOL 73 03M485 LAGUARDIA HIGH SCH MUSIC ART 74 03M494 Martin Luther King Jr HS Arts and Technology 75 03M505 Edward A. Reynolds West Side High School 76 03M541 MANHATTAN/HUNTER COLL HS SCI 77 03M860 FREDERICK DOUGLAS ACADEMY II 78 04M409 COALITION SCH SOCIAL CHANGE 79 041435 Manhattan Center for Science and Math 80 04M495 PARK EAST HIGH SCHOOL 81 04M55S CENTRAL PARK SECONDARY SCHOOL 82 04M610 YOUNG WOMEN LEADERSHIP SCHOOL 83 04M635 Academy of Environment Science Secondary School 84 04M630 HERITAGE SCHOOL 85 041695 URBAN PEACE ACADEMY 86 O5M285 HARLEM RENAISSANCE HIGH SCHOOL 87 05M304 MOTT HALL HIGH SCHOOL 88 05M369 URBAN ASSEMBLY SCHOOL FOR THE PERFORMIN 89 OSM469 CHOIR ACADEMY OF HARLEM 90 05M499 FREDERICK DOUGLASS ACADEMY 91 05M670 THURGOOD MARSHALL ACADEMY 92 OSM685 Bread & Rose Intergrated Arts High School 93 OSM692 High School For Math Science Engineering City Coll 94 06M462 HIGH SCHOOL FOR INTL BUS/FIN Problem 1 Problem 2 Problem 3 74 16 47 32 54 57 34 16 141 79 11 301 37 61 152 125 212 71 14 23 57 53 68 170 237 594 60 18 80 33 39 312 46 35 48 39 47 23 19 63 34 16 216 52 54 106 55 343 372 468 513 400 355 425 429 419 433 393 378 370 427 399 382 406 364 374 376 357 573 558 407 410 481 414 390 485 360 362 451 380 369 366 402 424 349 420 465 423 364 592 383 380 385 419 612 465 369 441 460 336 475 429 382 420 405 412 387 378 423 389 404 378 378 363 373 357 563 555 425 407 525 410 372 531 374 378 445 385 385 382 394 421 F 325 387 395 419 362 368 434 502 376 339 419 416 413 417 376 370 360 418 383 359 391 357 377 371 345 575 567 397 388 469 406 383 475 362 356 370 470 354 361 362 367 410 363 401 466 404 359 575 379 369 481 378 627 384 + Ready 374 378 445 385 385 382 394 421 370 362 356 470 354 361 360 362 451 380 369 366 402 424 349 420 465 423 362 367 410 369 46 35 48 39 47 23 19 63 34 16 216 52 54 106 56 75 106 28 193 60 60 33 481 434 378 627 80 04M495 PARK EAST HIGH SCHOOL 81 04M555 CENTRAL PARK SECONDARY SCHOOL 82 04M610 YOUNG WOMEN LEADERSHIP SCHOOL 83 04M635 Academy of Environment Science Secondary School 84 04M680 HERITAGE SCHOOL 85 04M695 URBAN PEACE ACADEMY 86 05M285 HARLEM RENAISSANCE HIGH SCHOOL 87 05M304 MOTT HALL HIGH SCHOOL 88 05M369 URBAN ASSEMBLY SCHOOL FOR THE PERFORMIN 89 051469 CHOIR ACADEMY OF HARLEM 90 05M499 FREDERICK DOUGLASS ACADEMY 91 05M670 THURGOOD MARSHALL ACADEMY 92 05M685 Bread & Rose Intergrated Arts High School 93 05M692 High School For Math Science Engineering City Coll 94 06M462 HIGH SCHOOL FOR INTL BUS/FIN 95 06M463 HS for Media and Communications-George Washingto 96 06M467 High School for Law and Public Service 97 06M468 HIGH SCHOOL FOR HLTH CARER/SER 98 06M540 A Philip Randolph Campus High School 99 06M552 GREGORIO LUPERON PREP SCHOOL 100 07X221 SOUTH BRONX PREPARATORY 101 07X334 INTERNATIONAL COMMUNITY HIGH SCHOOL 102 103 104 105 106 107 108 109 110 364 384 592 383 366 388 385 436 342 399 322 363 401 466 404 359 575 379 353 378 373 421 333 382 327 376 388 417 451 384 393 335 112 113 115 116 117 118 119 QUESTION 5 Choose the correct LOOKUP function used for the categorization in Problem 2 O-LOOKUP(G2,(0,1100, 1400, 1600,2500},{"Unsatisfactory", "Satisfactory","Exceeding Expectations","Outstanding" O=LOOKUP(G2,(0,1100,1101,1400, 1401,1600,1601,2500},{"Unsatisfactory","Satisfactory", "Exceeding Expectations", "Outstanding')) O=LOOKUP(G2,{0,1101,1401,1601,2500},{"Unsatisfactory", "Satisfactory", "Exceeding Expectations","Outstanding"> O=LOOKUP(G2,(0,1101,1401,1601).("Unsatisfactory", "Satisfactory":"Exceeding Expectations", "Outstanding")) QUESTION 6 Choose the appropriate COUNTIF function to count schools falling in each Rating O=COUNTIF($H$2:$H$101.[Rating]) =COUNT(H2:H101) IF([Rating]) O=COUNTIF(H2, [Rating) =COUNTIF([Rating], $H$2:$H$101) I Format U Tel Tell me what you General $-% Merge & Center NI For Sort G 1 0 144 SO 315 415 405 331 217 69 20 1 OEN School Name D 2 CIM Mary Street School for treational Studies Norber of est Museenwoor IM University Malborhood High School 31 Exide Community 391 GO 385 49 DIMAS SATELLITE ACADEMY FOREST 183 69 IMSIS Lower East Side Program School 26 10 * CIMS imploration into , Tech and 373 GIMSSO CASCADES ON SOHOOL 42 110 512 314 SU 5 IMGARD HIGH SCHOOL EARLY COLLEGE 35 563 411 401 401 10 MOT AMERICAN SIGN LANG NG DUAL 938 630 608 11 SE FOOD AND FRANCE HIGH SCHOOL 11 30 695 12 MOHON SCHOOL FOR HIST AND COMM 422 412 9 11 9 h School of Hory Management 51 12 BE 14 M2 PACE HIGH SCHOOL 92 191 15 M100 urbanem fchool of Design and Construction 73 4 16 OMSON The facing stary School 446 415 17 OM3 Urban Asembly Academy of Governando s az LOWER STAR ARTS ACADEMY 4 411 400 433 1902MS1 The lane. Baldwin School 35 383 20 M316 Urban Assembly School of Business for Women 423 194 21 M374 GRAMACY ARTS HIGH SCHOOL 391 49 22 MOO HIGHS HSCHOOL INVENMINTL STUDIES 995 376 386 216 23 Mo Institute for Collaborative Ideas 465 40 42 24 M Profesional Performing Artschool 69 465 25 M11 Baruch College Campus High School 499 581 26 OM412 New York City Laboratory School Coll Studies 528 108 561 27 MAI SCHOOL OF THE FUTURE 79 466 28 02414 NEW YORK CITY MUSEUM SCHOOL 654 29 M16 ELEANOR ROOSEVELTHIGHSCHOOL 560 30 Min High School 512 52 31 MIS LANDMARK SCHOOL 30 32 CM HIGH SCHOOL HETH PROFUMAN 250 33 OM HIGH SCHOOL LEADERSHIP PUB WC 74 419 14 OM LEGACYSCH INTEGRATED STUDES 13 256 15 M19 MANHATTAN VLLAGE ACADEMY 470 473 36 021440 Bayard Rush School Humanities 136 387 190 3.79 37 OMLA VANGUARD HIGH SCHOOL 54 167 195 15 OMS MAATAN INTERNATIONAL HIGH SCHOOL 31 418 415 39 DMGO WASHINGTON IRVING HIGH SCHOOL 163 368 804 40 METS STUYVESANT HIGH SCHOOL 66 735 678 41 14 ofico And Finance 147 453 sai 42 OMSOO UNITY HIGH SCHOOL 371 465 43 JMS19 TALENTUM IMITED HIGH SCHOOL 44 OMS 20 MURRY BERGTRAUM HIGH SCHOOL 45 02MS29 queline Kennedy Onassis High School 430 424 398 397 46 OMS 1 NEW YORK CITY PUBS RIP COMP 47 0242 MANHATTAN BRIDGE HIGH SCHOOL 3: 380 Penh Problem 2 Prima 96 EN LES 47 199 31 161 124 207 Copy Paste B I U Will ildl M li $ Format Merge & Center K18 D E G 345 390 404 416 B 47 UZM4Z MANHATTAN BRIDGE HIGH SCHOOL 48 02M543 NEW DESIGN HIGH SCHOOL 49 02MS44 INDEPENDENCE HIGH SCHOOL 50 02M545 Dual Language and Asian Studies High School 51 02M550 Liberty High School Academy for Newcomers 52 021551 New York Harbor High School 53 02MS60 City as School 54 02M565 URBAN ACADEMY 55 02570 Satellite Academy High School 56 02M575 Manhattan Comprehensive Night Day High School 57 02M580 Richard R Green High School of Teaching 58 02M586 HARVEY SCHOOL 59 02M600 HIGH SCHOOL FASHION INDUSTRIES 60 02M605 HUMANITIES PREPARATORY ACADEMY 61 02M615 Chelsea Career and Technical Education High School 62 02M620 NORMAN THOMAS HIGH SCHOOL 63 02M625 HS of Graphic Commnctn And Art 64 02M630 HIGH SCHOOL OF ART AND DESIGN 65 02M655 LIFE SCIENCES SECONDARY SCHOOL 66 02M690 SCHOOL FOR THE PHYSICAL CITY 67 03M283 MANHATTAN THEATRE LAB HIGH SCHOOL 68 03M299 High School For Arts, Imagination And Inquiry 69 03M307 Urban Assembly School For Media Studies 70 03M415 WADLEIGH SECONDARY SCHOOL 71 031470 LOUIS D BRANDEIS HIGH SCHOOL 72 03M479 BEACON SCHOOL 73 03M485 LAGUARDIA HIGH SCH MUSIC ART 74 03M494 Martin Luther King Jr HS Arts and Technology 75 03M505 Edward A. Reynolds West Side High School 76 03M541 MANHATTAN/HUNTER COLL HS SCI 77 03M860 FREDERICK DOUGLAS ACADEMY II 78 04M409 COALITION SCH SOCIAL CHANGE 79 041435 Manhattan Center for Science and Math 80 04M495 PARK EAST HIGH SCHOOL 81 04M55S CENTRAL PARK SECONDARY SCHOOL 82 04M610 YOUNG WOMEN LEADERSHIP SCHOOL 83 04M635 Academy of Environment Science Secondary School 84 04M630 HERITAGE SCHOOL 85 041695 URBAN PEACE ACADEMY 86 O5M285 HARLEM RENAISSANCE HIGH SCHOOL 87 05M304 MOTT HALL HIGH SCHOOL 88 05M369 URBAN ASSEMBLY SCHOOL FOR THE PERFORMIN 89 OSM469 CHOIR ACADEMY OF HARLEM 90 05M499 FREDERICK DOUGLASS ACADEMY 91 05M670 THURGOOD MARSHALL ACADEMY 92 OSM685 Bread & Rose Intergrated Arts High School 93 OSM692 High School For Math Science Engineering City Coll 94 06M462 HIGH SCHOOL FOR INTL BUS/FIN Problem 1 Problem 2 Problem 3 74 16 47 32 54 57 34 16 141 79 11 301 37 61 152 125 212 71 14 23 57 53 68 170 237 594 60 18 80 33 39 312 46 35 48 39 47 23 19 63 34 16 216 52 54 106 55 343 372 468 513 400 355 425 429 419 433 393 378 370 427 399 382 406 364 374 376 357 573 558 407 410 481 414 390 485 360 362 451 380 369 366 402 424 349 420 465 423 364 592 383 380 385 419 612 465 369 441 460 336 475 429 382 420 405 412 387 378 423 389 404 378 378 363 373 357 563 555 425 407 525 410 372 531 374 378 445 385 385 382 394 421 F 325 387 395 419 362 368 434 502 376 339 419 416 413 417 376 370 360 418 383 359 391 357 377 371 345 575 567 397 388 469 406 383 475 362 356 370 470 354 361 362 367 410 363 401 466 404 359 575 379 369 481 378 627 384 + Ready 374 378 445 385 385 382 394 421 370 362 356 470 354 361 360 362 451 380 369 366 402 424 349 420 465 423 362 367 410 369 46 35 48 39 47 23 19 63 34 16 216 52 54 106 56 75 106 28 193 60 60 33 481 434 378 627 80 04M495 PARK EAST HIGH SCHOOL 81 04M555 CENTRAL PARK SECONDARY SCHOOL 82 04M610 YOUNG WOMEN LEADERSHIP SCHOOL 83 04M635 Academy of Environment Science Secondary School 84 04M680 HERITAGE SCHOOL 85 04M695 URBAN PEACE ACADEMY 86 05M285 HARLEM RENAISSANCE HIGH SCHOOL 87 05M304 MOTT HALL HIGH SCHOOL 88 05M369 URBAN ASSEMBLY SCHOOL FOR THE PERFORMIN 89 051469 CHOIR ACADEMY OF HARLEM 90 05M499 FREDERICK DOUGLASS ACADEMY 91 05M670 THURGOOD MARSHALL ACADEMY 92 05M685 Bread & Rose Intergrated Arts High School 93 05M692 High School For Math Science Engineering City Coll 94 06M462 HIGH SCHOOL FOR INTL BUS/FIN 95 06M463 HS for Media and Communications-George Washingto 96 06M467 High School for Law and Public Service 97 06M468 HIGH SCHOOL FOR HLTH CARER/SER 98 06M540 A Philip Randolph Campus High School 99 06M552 GREGORIO LUPERON PREP SCHOOL 100 07X221 SOUTH BRONX PREPARATORY 101 07X334 INTERNATIONAL COMMUNITY HIGH SCHOOL 102 103 104 105 106 107 108 109 110 364 384 592 383 366 388 385 436 342 399 322 363 401 466 404 359 575 379 353 378 373 421 333 382 327 376 388 417 451 384 393 335 112 113 115 116 117 118 119 QUESTION 5 Choose the correct LOOKUP function used for the categorization in Problem 2 O-LOOKUP(G2,(0,1100, 1400, 1600,2500},{"Unsatisfactory", "Satisfactory","Exceeding Expectations","Outstanding" O=LOOKUP(G2,(0,1100,1101,1400, 1401,1600,1601,2500},{"Unsatisfactory","Satisfactory", "Exceeding Expectations", "Outstanding')) O=LOOKUP(G2,{0,1101,1401,1601,2500},{"Unsatisfactory", "Satisfactory", "Exceeding Expectations","Outstanding"> O=LOOKUP(G2,(0,1101,1401,1601).("Unsatisfactory", "Satisfactory":"Exceeding Expectations", "Outstanding")) QUESTION 6 Choose the appropriate COUNTIF function to count schools falling in each Rating O=COUNTIF($H$2:$H$101.[Rating]) =COUNT(H2:H101) IF([Rating]) O=COUNTIF(H2, [Rating) =COUNTIF([Rating], $H$2:$H$101)