Question: The attached Excel sheet titled Grade Calculator contains 9 errors. List the errors by cell number and provide a brief description of the error. HOMEWORKS

The attached Excel sheet titled Grade Calculator contains 9 errors. List the errors by cell number and provide a brief description of the error.

The attached Excel sheet titled Grade Calculator

HOMEWORKS AND ETHICS CLASSWORK (24%) LABS (50%) IN (2%) DI SAT (4%) CALC % BEFORE FINAL Grade Before Final FINAL EXAM CALC % AFTER FINAL Grade After Final #3 #6 E1 EQUIZ E2 Total #1 #3 #4 #5 LAB % #1 100 #2 100 #4 100 #5 100 HW % 600 #2 100 #6 100 Total 600 100 100 100 100 100 100 25 50 80 100 100 Pts Avail STUDENT 100 79 99 46 B 105 93 76 80 93 B 110 103 80 34 81 99 66 81 89 71 7 21 25 37 32 64 82 68 A 100 92 100 75 91 59 75 80 90 85 85 91 39 94 66 91 69 95 73 D 0.72 0.82 0.79 0.83 0.86 0.81 61 68.98 85.44 85.31 57.95 66.19 62.18 52 65 96 64 72 59 71 99 73 58 56 83 87 85 76 76 93 72 12 E F G B 92 78 84 68 88 84 80 73 76 77 81 88 80 76 49 26 77 97 64 12. 93 78 94 83 93 25 44 72 73 C H 67 55 64 91 68 79 88 16 48 79 99 84 93 0.71 0.81 0.84 0.77 1 63 84 89 52 71 80 22 16 90 71 J 66 91 89 64 95 69 94 80 18 40 K 58 93 77 77 55 73 67 82 32 72 95 95 50 50 62 98 81 68 69 L 62 93 77 86 66 81 19 25 C M 89 68 83 60.18 62.06 62.67 62.42 58.80 60.96 56.07 60.85 65.99 58.76 60.68 60.09 74 85 45 82 83 83 82 83 519 0.87 577 0.42 1027 2.86 407 ##### 462 ##### 468 0.90 479 0.83 411 0.40 445 0.74 482 1.04 431 0.92 436 0.91 450 1.09 440 0.99 505 1.05 443 1.03 469 1.08 430 0.96 452 1.03 422 0.70 405 0.68 449 0.75 526 0.88 448 0.75 448 0.75 452 0.75 90 76 72 77 82 67 nw88n8%89% N 433 491 476 500 514 485 426 486 502 462 468 480 404 470 489 480 457 460 476 406 473 475 461 477 479 466 64 89 90 74 10 25 93 65 87 79 66 85 26 100 93 80 86 0 98 85 67 24 39 B 95 68 71 54 81 89 73 84 71 86 13 Q 65 58 99 90 100 75 74 72 72 79 24 24 R 57 66 92 50 72 89 63 90 78 75 65 82 66 0.78 0.80 0.67 0.78 0.82 0.80 0.76 0.77 0.79 0.68 0.79 0.79 0.77 0.80 0.80 16 41 90 91 77 85 94 71 83 78 68 76 S 65 88 74 88 93 78 25 36 60 50 73 94 69 66 77 94 T 88 74 54 70 93 23 19 A U 78 80 90 94 77 80 D 63 67 V 64 91 68 62 94 75 83 51 54 50 85 89 w 78 95 67 70 99 93 69 67 77 81 70 99 81 96 100 77 85 62.63 54.07 55.62 60.58 62.42 60.71 60.48 60.43 66 68 75 88 88 66 95 78 76 90 90 19 32 17 80 60 19 5 21 9 16 91 89 OOOO 93 79 68 24 Y z 64 58 93 72 69 78 82 72 88 67 94 0.78 28 HOMEWORKS AND ETHICS CLASSWORK (24%) LABS (50%) IN (2%) DI SAT (4%) CALC % BEFORE FINAL Grade Before Final FINAL EXAM CALC % AFTER FINAL Grade After Final #3 #6 E1 EQUIZ E2 Total #1 #3 #4 #5 LAB % #1 100 #2 100 #4 100 #5 100 HW % 600 #2 100 #6 100 Total 600 100 100 100 100 100 100 25 50 80 100 100 Pts Avail STUDENT 100 79 99 46 B 105 93 76 80 93 B 110 103 80 34 81 99 66 81 89 71 7 21 25 37 32 64 82 68 A 100 92 100 75 91 59 75 80 90 85 85 91 39 94 66 91 69 95 73 D 0.72 0.82 0.79 0.83 0.86 0.81 61 68.98 85.44 85.31 57.95 66.19 62.18 52 65 96 64 72 59 71 99 73 58 56 83 87 85 76 76 93 72 12 E F G B 92 78 84 68 88 84 80 73 76 77 81 88 80 76 49 26 77 97 64 12. 93 78 94 83 93 25 44 72 73 C H 67 55 64 91 68 79 88 16 48 79 99 84 93 0.71 0.81 0.84 0.77 1 63 84 89 52 71 80 22 16 90 71 J 66 91 89 64 95 69 94 80 18 40 K 58 93 77 77 55 73 67 82 32 72 95 95 50 50 62 98 81 68 69 L 62 93 77 86 66 81 19 25 C M 89 68 83 60.18 62.06 62.67 62.42 58.80 60.96 56.07 60.85 65.99 58.76 60.68 60.09 74 85 45 82 83 83 82 83 519 0.87 577 0.42 1027 2.86 407 ##### 462 ##### 468 0.90 479 0.83 411 0.40 445 0.74 482 1.04 431 0.92 436 0.91 450 1.09 440 0.99 505 1.05 443 1.03 469 1.08 430 0.96 452 1.03 422 0.70 405 0.68 449 0.75 526 0.88 448 0.75 448 0.75 452 0.75 90 76 72 77 82 67 nw88n8%89% N 433 491 476 500 514 485 426 486 502 462 468 480 404 470 489 480 457 460 476 406 473 475 461 477 479 466 64 89 90 74 10 25 93 65 87 79 66 85 26 100 93 80 86 0 98 85 67 24 39 B 95 68 71 54 81 89 73 84 71 86 13 Q 65 58 99 90 100 75 74 72 72 79 24 24 R 57 66 92 50 72 89 63 90 78 75 65 82 66 0.78 0.80 0.67 0.78 0.82 0.80 0.76 0.77 0.79 0.68 0.79 0.79 0.77 0.80 0.80 16 41 90 91 77 85 94 71 83 78 68 76 S 65 88 74 88 93 78 25 36 60 50 73 94 69 66 77 94 T 88 74 54 70 93 23 19 A U 78 80 90 94 77 80 D 63 67 V 64 91 68 62 94 75 83 51 54 50 85 89 w 78 95 67 70 99 93 69 67 77 81 70 99 81 96 100 77 85 62.63 54.07 55.62 60.58 62.42 60.71 60.48 60.43 66 68 75 88 88 66 95 78 76 90 90 19 32 17 80 60 19 5 21 9 16 91 89 OOOO 93 79 68 24 Y z 64 58 93 72 69 78 82 72 88 67 94 0.78 28

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!