This is to be done in Excel. The class in for accounting information system.

Go to the Entry Form worksheet. The Admissions staff will use this worksheet to enter tuition payments and summarize tuition information. Tarif wants to make it easy to record the payments and avoid errors. In cell C3, add a data validation list that accepts only the values in the range I3:I203.

97% [4] Fri 10:18 PM Fri 10:18 PM E Q Search Sheet 9+ Share Excel File Edit View Insert Format Tools Data Window Help 5 NP_EX19_EOM12-1_RochiBorbon_1 (1) Home Insert Page Layout Formulas Data Review View X Cut Century Go... 11 A- A+ 5 Wrap Text General Copy Paste U. A Format Merge & Center $ % ) K1 x foc 1 , X AutoSum Fill - 49 H 7 7 +.0 .00 .00 0 Insert Delete Conditional Format Formatting as Table Cell Styles Format Clear Sort & Filter A B D E F F G H 1 J L N o 0 R S T U v W Payment Entry Form Abernathy Academy 2 3 REGISTERED STUDENTS TOTAL TUITION BILLED Account ID Date Amount paid 4 Account IDs AC-1031 AC-1032 AC-1034 AC-1031 10/7/21 $1,000 5 6 AC-1036 7 STUDENTS - PAYMENTS TOTAL PAID TUITION Total due this account Total paid to date Total owed $10.432 $5,432 AC-1046 AC-1050 8 189 $4,000 STUDENTS - NO PAYMENTS TOTAL TUITION DUE Enter Payment Clear Entries 12 $0 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 AC-1054 AC-1059 AC-1066 AC-1072 AC-1079 AC-1010 AC-1087 AC-1088 AC-1092 AC-1095 AC-1096 AC-1100 AC-1101 AC-1106 AC-1111 AC-1112 AC-1115 AC-1117 AC-1118 AC-1122 AC-1125 AC-1126 AC-1134 AC-1137 AC-1139 AC-1145 AC 1146 AC-1154 AC-1162 AC-1167 AC-1174 AC 1180 AC.1183 Documentation Payments Entry Form Payment Summary + Ready u + 100% 99% O Sat 7:17 AM a 5 Q Search Sheet NP_EX19_EOM12-1_RochiBorbon_1 (1) 9+ Share Excel File Edit View Insert Format Tools Data Window Help D. = Home Insert Page Layout Formulas Data Review View X Cut Century Go... 11 | A- A+ Copy Paste B I U Format L1 x fx AutoSum Wrap Text General 29 Fill Merge & Center $ % > 2.0 .00 .00 >.0 Insert Delete Format Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A B D E F G H 1 J L M N O Q R S T U Abernathy Academy 1 Accounts Table Late Payments Table Account ID AC-1066 Payment Date 10/7/21 Amount Pald $2.500 Total Due $10,432 $10.236 $7.508 $10.432 $7.508 $9.891 $5,600 $9,891 $10.332 $7,508 $7.508 $9.953 $9.953 $10,432 $10.332 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 12 Account ID Code AC-1031 F F AC-1032 F AC-1034 S AC-1036 F AC-1046 S AC-1050 G AC-1054 S AC-1059 F AC-1066 F AC-1072 S AC-1079 S AC-1080 F AC-1087 F AC-1088 F AC-1092 F AC-1095 F AC-1096 F F AC-1100 S AC-1101 S AC-1106 G AC-1111 S AC-1112 F AC-1115 F AC-1117 S AC-1118 S. AC-1122 F AC-1125 F AC-1126 F AC-1134 F AC-1137 F AC-1139 S AC-1145 G AC-1146 S AC-1154 F AC-1162 F AC-1167 F AC-1174 F AC-1180 F AC-1183 G ACIAS F Documentation $10.153 $9.891 $7.238 $5,600 $7.238 $7.508 $9.953 $9.891 $7.238 $5,600 $9,891 $10,432 $9.891 $9.891 $10.236 $7.508 $9.237 $7.508 $9,891 $9.891 $10.332 $10.432 $10,153 $9.237 ein 152 Payments Payment Date 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/2 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 011/01 Entry Form Amount Pald $5,432 $3,236 $5,406 $5,432 $5,000 $4,800 $5,600 $3,000 $5,332 $7,500 $7,508 $4,200 $10,432 $4,000 $5,000 $3,500 $9.891 $7.238 $5,600 $7,238 $7,508 $3,700 $2,891 $5.000 $5,600 $4,800 $5,432 $3,000 $3,800 $5,236 $7.508 $9.237 $7.508 $9,891 $9.891 $5,300 $10,432 $5,000 $4,000 C1 152 Payment Summary + Ready a + 100% 99% O Sat 7:17 AM a 5 Q- Search Sheet + Share Excel File Edit View Insert Format Tools Data Window Help HD 5 NP_EX19_EOM12-1_RochiBorbon_1 (1) Home Insert Page Layout Formulas Data Review View X Cut Century Go... 11 A- A to Wrap Text General Copy Paste BIU U- , Merge & Center Format $ - % % ) G1 X fox 1 AutoSum , , X 49 Fill 7 . .00 .00 0 Insert Delete Conditional Format Formatting as Table Cell Styles Format Clear Sort & Filter B D E F G H 1 1 J L M N o Q R S T U V w Payments by Date Abernathy Academy 1 2 Payment Date Registered Students Total Billed Total Pald Amount Due 3 9/1/21 51 $462.985 $312,645 $150,340 4 9/8/21 36 $342, 177 $247.939 $94.238 5 9/15/21 48 $456,100 $313,200 $142,900 6 9/22/21 27 $248,946 $188,232 $60,714 7 9/29/21 12 $110,162 $75,302 $34,860 8 10/6/21 27 $267.471 $110,395 $157,076 9 Grand Total 201 $1,887,841 $1,247.713 $640,128 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 14 Documentation Payments Entry Form Payment Summary + Ready a + 100% 97% [4] Fri 10:18 PM Fri 10:18 PM E Q Search Sheet 9+ Share Excel File Edit View Insert Format Tools Data Window Help 5 NP_EX19_EOM12-1_RochiBorbon_1 (1) Home Insert Page Layout Formulas Data Review View X Cut Century Go... 11 A- A+ 5 Wrap Text General Copy Paste U. A Format Merge & Center $ % ) K1 x foc 1 , X AutoSum Fill - 49 H 7 7 +.0 .00 .00 0 Insert Delete Conditional Format Formatting as Table Cell Styles Format Clear Sort & Filter A B D E F F G H 1 J L N o 0 R S T U v W Payment Entry Form Abernathy Academy 2 3 REGISTERED STUDENTS TOTAL TUITION BILLED Account ID Date Amount paid 4 Account IDs AC-1031 AC-1032 AC-1034 AC-1031 10/7/21 $1,000 5 6 AC-1036 7 STUDENTS - PAYMENTS TOTAL PAID TUITION Total due this account Total paid to date Total owed $10.432 $5,432 AC-1046 AC-1050 8 189 $4,000 STUDENTS - NO PAYMENTS TOTAL TUITION DUE Enter Payment Clear Entries 12 $0 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 AC-1054 AC-1059 AC-1066 AC-1072 AC-1079 AC-1010 AC-1087 AC-1088 AC-1092 AC-1095 AC-1096 AC-1100 AC-1101 AC-1106 AC-1111 AC-1112 AC-1115 AC-1117 AC-1118 AC-1122 AC-1125 AC-1126 AC-1134 AC-1137 AC-1139 AC-1145 AC 1146 AC-1154 AC-1162 AC-1167 AC-1174 AC 1180 AC.1183 Documentation Payments Entry Form Payment Summary + Ready u + 100% 99% O Sat 7:17 AM a 5 Q Search Sheet NP_EX19_EOM12-1_RochiBorbon_1 (1) 9+ Share Excel File Edit View Insert Format Tools Data Window Help D. = Home Insert Page Layout Formulas Data Review View X Cut Century Go... 11 | A- A+ Copy Paste B I U Format L1 x fx AutoSum Wrap Text General 29 Fill Merge & Center $ % > 2.0 .00 .00 >.0 Insert Delete Format Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A B D E F G H 1 J L M N O Q R S T U Abernathy Academy 1 Accounts Table Late Payments Table Account ID AC-1066 Payment Date 10/7/21 Amount Pald $2.500 Total Due $10,432 $10.236 $7.508 $10.432 $7.508 $9.891 $5,600 $9,891 $10.332 $7,508 $7.508 $9.953 $9.953 $10,432 $10.332 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 12 Account ID Code AC-1031 F F AC-1032 F AC-1034 S AC-1036 F AC-1046 S AC-1050 G AC-1054 S AC-1059 F AC-1066 F AC-1072 S AC-1079 S AC-1080 F AC-1087 F AC-1088 F AC-1092 F AC-1095 F AC-1096 F F AC-1100 S AC-1101 S AC-1106 G AC-1111 S AC-1112 F AC-1115 F AC-1117 S AC-1118 S. AC-1122 F AC-1125 F AC-1126 F AC-1134 F AC-1137 F AC-1139 S AC-1145 G AC-1146 S AC-1154 F AC-1162 F AC-1167 F AC-1174 F AC-1180 F AC-1183 G ACIAS F Documentation $10.153 $9.891 $7.238 $5,600 $7.238 $7.508 $9.953 $9.891 $7.238 $5,600 $9,891 $10,432 $9.891 $9.891 $10.236 $7.508 $9.237 $7.508 $9,891 $9.891 $10.332 $10.432 $10,153 $9.237 ein 152 Payments Payment Date 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/2 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 9/1/21 011/01 Entry Form Amount Pald $5,432 $3,236 $5,406 $5,432 $5,000 $4,800 $5,600 $3,000 $5,332 $7,500 $7,508 $4,200 $10,432 $4,000 $5,000 $3,500 $9.891 $7.238 $5,600 $7,238 $7,508 $3,700 $2,891 $5.000 $5,600 $4,800 $5,432 $3,000 $3,800 $5,236 $7.508 $9.237 $7.508 $9,891 $9.891 $5,300 $10,432 $5,000 $4,000 C1 152 Payment Summary + Ready a + 100% 99% O Sat 7:17 AM a 5 Q- Search Sheet + Share Excel File Edit View Insert Format Tools Data Window Help HD 5 NP_EX19_EOM12-1_RochiBorbon_1 (1) Home Insert Page Layout Formulas Data Review View X Cut Century Go... 11 A- A to Wrap Text General Copy Paste BIU U- , Merge & Center Format $ - % % ) G1 X fox 1 AutoSum , , X 49 Fill 7 . .00 .00 0 Insert Delete Conditional Format Formatting as Table Cell Styles Format Clear Sort & Filter B D E F G H 1 1 J L M N o Q R S T U V w Payments by Date Abernathy Academy 1 2 Payment Date Registered Students Total Billed Total Pald Amount Due 3 9/1/21 51 $462.985 $312,645 $150,340 4 9/8/21 36 $342, 177 $247.939 $94.238 5 9/15/21 48 $456,100 $313,200 $142,900 6 9/22/21 27 $248,946 $188,232 $60,714 7 9/29/21 12 $110,162 $75,302 $34,860 8 10/6/21 27 $267.471 $110,395 $157,076 9 Grand Total 201 $1,887,841 $1,247.713 $640,128 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 14 Documentation Payments Entry Form Payment Summary + Ready a + 100%