Excel Instructions CAUTION: Read Appendix A for specific instructions relating to these templates. 1. Enter the appropriate numbers/ formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 2. A formula begins with an equals sign) and can consist of any of the following elements: Operators such as + (for addition), - (for subtraction), * (for multiplication), and / (for division). Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. To enter a formula manually, follow these steps: Move the cell pointer to the cell that you want to hold the formula. Type an equals sign) to signal the fact that the cell contains a formula. Type the formula, then press Enter. 4. Rounding: These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example, 17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's rounding function. 5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time. You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name. To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar. It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter_7_long_version_Your_Name.xlsx To save under a different name, follow these steps: Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx) Select the folder in which to store the workbook. Enter the new filename in the File name box. Click Save. A B D E F L M 1 JOURNAL Page 41 CREDIT 12,315.64 958.33 224.14 859.00 474.55 9.25 599.86 16.00 12,315.64 POST. 3 DATE DESCRIPTION REF DEBIT 4 20- 5 Oct. 9 Payroll Cash 12 12,315.64 6 Cash 11 7 8 9 Administrative Salaries 51 2,307.69 9 Office Salaries 52 4,651.08 10 Sales Salaries 53 3,600.00 11 Plant Wages 54 4,898.00 12 FICA Taxes Payable - OASDI 20.1 13 FICA Taxes Payable - HI 20.2 14 Employees FIT Payable 24 15 Employees SIT Payable 25 16 Employees SUTA Payable 25.1 17 Employees CIT Payable 26 18 Union Dues Payable 28 19 Payroll Cash 12 20 21 9 Payroll Taxes 56 1,381.61 22 FICA Taxes Payable - OASDI 20.1 23 FICA Taxes Payable - HI 20.2 24 FUTA Taxes Payable 21 25 SUTA Taxes Payable - Employer 22 26 27 28 29 30 31 32 33 393 394 Total debits and credits (calculated automatically): 29,154.02 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 397| 59,171.29 October 31, 20- December 31, 20- 398 November 30, 20-- January 31, 20- 399 400 958.32 224.12 22.91 176.26 395 Checkpoint for Dec. 31, 20- Enter the total debit amount here after recording all of the journal entries for the month of December. (See cell E394 in yellow above.) Do not use copy and paste feature. A B D E F L M 40 41 42 JOURNAL Page 42 POST REF DESCRIPTION DEBIT CREDIT DATE 20-- 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 893 394 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 397 59,171.29 October 31, 20-- December 31, 20- 398 November 30, 20- January 31, 20- 399 400 Checkpoint for Dec. 31, 20- Enter the total debit amount here after recording all of the journal entries for the month of December. (See cell E394 in yellow above.) Do not use copy and paste feature. A B D E F M 71 72 73 JOURNAL Page 43 4 CREDIT POST 75 DATE DESCRIPTION REF. DEBIT 76 20-- 77 78 79 BO B1 82 B3 34 85 36 37 38 B9 30 31 232 33 94 35 36 97 98 39 00 01 02 03 93 94 Total debits and credits (calculated automatically): 29,154.02 95 Your debits and credits should be equal after each journal entry is complete -96 Cumulative Journal Checkpoint Through Month Ending 97159,171.29 October 31, 20- December 31, 20- -98 November 30, 20- January 31, 20- -99 -00 Checkpoint for Dec. 31, 20- Enter the total debit amount here after recording all of the journal entries for the month of December. (See cell E394 in yellow above.) Do not use copy and paste feature. A B D E F L M 104 103 JOURNAL Page 44 CREDIT POST. 106 DATE DESCRIPTION REF DEBIT 107 20-- 108 109 110 111 112 113 114 1115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 393 394 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 397 59,171.29 October 31, 20- December 31, 20- 398 November 30, 20- January 31, 20- 899 100 Checkpoint for Dec. 31, 20- Enter the total debit amount here after recording all of the journal entries for the month of December. (See cell E394 in yellow above.) Do not use copy and paste feature. C136 fx D E F 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 3 JOURNAL Page 45 POST. REF. DESCRIPTION DEBIT CREDIT DATE 20- 56 57 58 59 60 61 62 63 64 65 66 67 68 69 93 94 95 96 97 98 99 00 29,154.02 Total debits and credits (calculated automatically): 29, 154.02 Your debits and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 59,171.29 October 31, 20- December 31, 20- November 30, 20- January 31, 20- A B D E F 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 IOU JOURNAL Page 46 POST REF DESCRIPTION DEBIT CREDIT DATE 20- 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 29,154.02 393 394 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 896 Cumulative Journal Checkpoint Through Month Ending 397 59,171.29 October 31, 20- December 31, 20- 398 November 30, 20- January 31, 20- 399 400 C202 > fx A D F m 203 204 205 206 207 208 209 210 11 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 Page 47 29, 154.02 234 JOURNAL E35 POST 393 394 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 397 59, 171.29 October 31, 20- December 31, 20- 898 November 30, 20- January 31, 20- 399 100 B D E F 234 23 JOURNAL Page 47 DESCRIPTION POST. REF DEBIT CREDIT DATE 20- 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 29,154.02 393 394 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 397 59,171.29 October 31, 20- December 31, 20- November 30, 20-- January 31, 20- 399 398 400 B D E F 267 268 269 270 271 272 273 274 JOURNAL Page 48 POST. REF. DESCRIPTION DEBIT CREDIT DATE 20-- 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 29,154.02 396 393 394 Total debits and credits (calculated automatically): 29,154.02 95 Your debits and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 897 59,171.29 October 31, 20- December 31, 20- 398 November 30, 20- January 31, 20- 399 100 C299 fx A C D E F 00 :01 -02 -03 04 05 06 07 -08 09 10 11 12 13 14 13 JOURNAL Page 49 POST. REF. DESCRIPTION DEBIT CREDIT DATE 20-- 16 17 18 19 -20 21 22 23 24 -25 26 27 28 -29 30 31 -32 A B D E F 366 367 368 369 370 371 372 873 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 397 59,171.29 October 31, 20- December 31, 20- 398 November 30, 20- January 31, 20- 399 29,154.02 29,154.02 393 394 395 396 397 398 399 Total debits and credits (calculated automatically): 29,154.02 Your debits and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 59,171.29 October 31, 20- December 31, 20- November 30, 20-- January 31, 20- A B D E F 333 334 35 36 337 38 39 340 841 342 343 344 845 346 347 348 349 350 351 352 53 354 55 JOURNAL Page 50 POST REF. DESCRIPTION DEBIT CREDIT DATE 20-- 56 357 358 359 360 361 62 363 364 65 29,154.02 393 94 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 97 59,171.29 October 31, 20- December 31, 20- 98 November 30, 20-- January 31, 20- 399 inn Excel Instructions CAUTION: Read Appendix A for specific instructions relating to these templates. 1. Enter the appropriate numbers/ formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 2. A formula begins with an equals sign) and can consist of any of the following elements: Operators such as + (for addition), - (for subtraction), * (for multiplication), and / (for division). Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. To enter a formula manually, follow these steps: Move the cell pointer to the cell that you want to hold the formula. Type an equals sign) to signal the fact that the cell contains a formula. Type the formula, then press Enter. 4. Rounding: These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example, 17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's rounding function. 5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time. You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name. To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar. It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter_7_long_version_Your_Name.xlsx To save under a different name, follow these steps: Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx) Select the folder in which to store the workbook. Enter the new filename in the File name box. Click Save. A B D E F L M 1 JOURNAL Page 41 CREDIT 12,315.64 958.33 224.14 859.00 474.55 9.25 599.86 16.00 12,315.64 POST. 3 DATE DESCRIPTION REF DEBIT 4 20- 5 Oct. 9 Payroll Cash 12 12,315.64 6 Cash 11 7 8 9 Administrative Salaries 51 2,307.69 9 Office Salaries 52 4,651.08 10 Sales Salaries 53 3,600.00 11 Plant Wages 54 4,898.00 12 FICA Taxes Payable - OASDI 20.1 13 FICA Taxes Payable - HI 20.2 14 Employees FIT Payable 24 15 Employees SIT Payable 25 16 Employees SUTA Payable 25.1 17 Employees CIT Payable 26 18 Union Dues Payable 28 19 Payroll Cash 12 20 21 9 Payroll Taxes 56 1,381.61 22 FICA Taxes Payable - OASDI 20.1 23 FICA Taxes Payable - HI 20.2 24 FUTA Taxes Payable 21 25 SUTA Taxes Payable - Employer 22 26 27 28 29 30 31 32 33 393 394 Total debits and credits (calculated automatically): 29,154.02 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 397| 59,171.29 October 31, 20- December 31, 20- 398 November 30, 20-- January 31, 20- 399 400 958.32 224.12 22.91 176.26 395 Checkpoint for Dec. 31, 20- Enter the total debit amount here after recording all of the journal entries for the month of December. (See cell E394 in yellow above.) Do not use copy and paste feature. A B D E F L M 40 41 42 JOURNAL Page 42 POST REF DESCRIPTION DEBIT CREDIT DATE 20-- 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 893 394 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 397 59,171.29 October 31, 20-- December 31, 20- 398 November 30, 20- January 31, 20- 399 400 Checkpoint for Dec. 31, 20- Enter the total debit amount here after recording all of the journal entries for the month of December. (See cell E394 in yellow above.) Do not use copy and paste feature. A B D E F M 71 72 73 JOURNAL Page 43 4 CREDIT POST 75 DATE DESCRIPTION REF. DEBIT 76 20-- 77 78 79 BO B1 82 B3 34 85 36 37 38 B9 30 31 232 33 94 35 36 97 98 39 00 01 02 03 93 94 Total debits and credits (calculated automatically): 29,154.02 95 Your debits and credits should be equal after each journal entry is complete -96 Cumulative Journal Checkpoint Through Month Ending 97159,171.29 October 31, 20- December 31, 20- -98 November 30, 20- January 31, 20- -99 -00 Checkpoint for Dec. 31, 20- Enter the total debit amount here after recording all of the journal entries for the month of December. (See cell E394 in yellow above.) Do not use copy and paste feature. A B D E F L M 104 103 JOURNAL Page 44 CREDIT POST. 106 DATE DESCRIPTION REF DEBIT 107 20-- 108 109 110 111 112 113 114 1115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 393 394 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 397 59,171.29 October 31, 20- December 31, 20- 398 November 30, 20- January 31, 20- 899 100 Checkpoint for Dec. 31, 20- Enter the total debit amount here after recording all of the journal entries for the month of December. (See cell E394 in yellow above.) Do not use copy and paste feature. C136 fx D E F 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 3 JOURNAL Page 45 POST. REF. DESCRIPTION DEBIT CREDIT DATE 20- 56 57 58 59 60 61 62 63 64 65 66 67 68 69 93 94 95 96 97 98 99 00 29,154.02 Total debits and credits (calculated automatically): 29, 154.02 Your debits and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 59,171.29 October 31, 20- December 31, 20- November 30, 20- January 31, 20- A B D E F 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 IOU JOURNAL Page 46 POST REF DESCRIPTION DEBIT CREDIT DATE 20- 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 29,154.02 393 394 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 896 Cumulative Journal Checkpoint Through Month Ending 397 59,171.29 October 31, 20- December 31, 20- 398 November 30, 20- January 31, 20- 399 400 C202 > fx A D F m 203 204 205 206 207 208 209 210 11 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 Page 47 29, 154.02 234 JOURNAL E35 POST 393 394 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 397 59, 171.29 October 31, 20- December 31, 20- 898 November 30, 20- January 31, 20- 399 100 B D E F 234 23 JOURNAL Page 47 DESCRIPTION POST. REF DEBIT CREDIT DATE 20- 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 29,154.02 393 394 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 397 59,171.29 October 31, 20- December 31, 20- November 30, 20-- January 31, 20- 399 398 400 B D E F 267 268 269 270 271 272 273 274 JOURNAL Page 48 POST. REF. DESCRIPTION DEBIT CREDIT DATE 20-- 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 29,154.02 396 393 394 Total debits and credits (calculated automatically): 29,154.02 95 Your debits and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 897 59,171.29 October 31, 20- December 31, 20- 398 November 30, 20- January 31, 20- 399 100 C299 fx A C D E F 00 :01 -02 -03 04 05 06 07 -08 09 10 11 12 13 14 13 JOURNAL Page 49 POST. REF. DESCRIPTION DEBIT CREDIT DATE 20-- 16 17 18 19 -20 21 22 23 24 -25 26 27 28 -29 30 31 -32 A B D E F 366 367 368 369 370 371 372 873 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 397 59,171.29 October 31, 20- December 31, 20- 398 November 30, 20- January 31, 20- 399 29,154.02 29,154.02 393 394 395 396 397 398 399 Total debits and credits (calculated automatically): 29,154.02 Your debits and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 59,171.29 October 31, 20- December 31, 20- November 30, 20-- January 31, 20- A B D E F 333 334 35 36 337 38 39 340 841 342 343 344 845 346 347 348 349 350 351 352 53 354 55 JOURNAL Page 50 POST REF. DESCRIPTION DEBIT CREDIT DATE 20-- 56 357 358 359 360 361 62 363 364 65 29,154.02 393 94 Total debits and credits (calculated automatically): 29,154.02 395 Your debits and credits should be equal after each journal entry is complete 396 Cumulative Journal Checkpoint Through Month Ending 97 59,171.29 October 31, 20- December 31, 20- 98 November 30, 20-- January 31, 20- 399 inn