QUESTION 6 Choose the appropriate COUNTIF function to count schools falling in each Rating =COUNTIF(H2,[Rating]) O =COUNTIF($H$2:$A$101,[Rating]) O =COUNTIF([Rating], $H$2:$H$101) O =COUNT(H2:H101) IF([Rating]) Calibri (Body) 12 A A 6 Wrap Text General Paste B I U- Merge & Center $ % Conditional Format Formatting as Table L5 M N Ratings No. of Schools Unsatisfactory Satisfactory Exceeding Expectations Outstanding D H 1 1 st Takers Critical Reading Mean Mathematics Mean Writing Mean Total Score Rating 2 31 391 425 385 1201 Satisfactory 3 60 394 419 387 1200 Satisfactory 4 69 418 431 402 1251 Satisfactory 5 26 385 370 378 1133 Satisfactory 6 154 314 532 314 1160 Satisfactory 7 47 568 583 568 1719 Outstanding 8 35 411 401 401 1213 Satisfactory 9 138 630 608 630 1868 Outstanding 10 11 405 415 385 1205 Satisfactory 11 50 422 412 407 1241 Satisfactory 12 51 382 364 366 1112 Satisfactory 13 43 397 415 391 1203 Satisfactory 14 71 424 448 423 1295 Satisfactory 15 49 405 446 415 1266 Satisfactory 16 1131 Satisfactory 59 373 381 377 411 17 411 406 1228 Satisfactory 48 412 18 381 1202 Satisfactory 409 35 19 1234 Satisfactory 419 394 421 45 409 401 391 1201 Satisfactory 20 52 1157 Satisfactory 386 376 21 395 49 480 1393 Satisfactory 448 465 22 216 478 472 1434 Exceeding Expectations 23 42 465 499 1459 Exceeding Expectations 24 69 495 528 1634 Outstanding 25 583 96 523 567 597 1725 Outstanding 26 561 108 466 488 1429 Exceeding Expectations 475 79 27 43 1937 ani Sheet2 + Problem 3 Problem 2 Problem 1 484