Skills Workshops |
|
Place Value and Order |
|
xix | |
Rounding Whole Numbers and Decimals |
|
xx | |
Add and Subtract Whole Numbers and Decimals |
|
xxi | |
Multiply Whole Numbers and Decimals |
|
xxii | |
Divide Whole Numbers and Decimals |
|
xxiii | |
Average a Group of Numbers |
|
xxiv | |
Multiply and Divide Fractions |
|
xxv | |
Add Fractions |
|
xxvi | |
Subtract Fractions |
|
xxvii | |
Fractions, Decimals, and Percents |
|
xxviii | |
Percent |
|
xxix | |
Estimation Skills |
|
xxx | |
Elapsed Time |
|
xxxi | |
Problem Solving: 4-Step Plan |
|
xxxii | |
Metric Measures |
|
xxxiii | |
|
|
2 | (36) |
|
|
2 | (1) |
|
|
3 | (1) |
|
|
|
|
4 | (4) |
|
|
8 | (6) |
|
|
14 | (6) |
|
|
20 | (6) |
|
|
26 | (12) |
|
|
|
|
31 | (1) |
|
|
31 | |
|
|
25 | (6) |
|
Integrating Your Knowledge |
|
|
31 | |
|
|
13 | (18) |
|
|
31 | (2) |
|
|
33 | (4) |
|
|
37 | |
|
|
36 | |
|
|
|
|
29 | |
|
|
23 | (13) |
|
|
36 | |
|
|
17 | |
|
|
6 | (28) |
|
|
|
|
34 | (1) |
|
Sales Commission Spreadsheet |
|
|
35 | (3) |
|
|
38 | (44) |
|
|
38 | (1) |
|
|
39 | (1) |
|
|
|
Deductions from Gross Pay |
|
|
40 | (7) |
|
Benefits and Job Expenses |
|
|
47 | (6) |
|
|
53 | (7) |
|
State and City Income Taxes |
|
|
60 | (4) |
|
Cash Receipts and Payments Records |
|
|
64 | (5) |
|
|
69 | (13) |
|
|
|
|
73 | |
|
|
51 | (22) |
|
|
73 | (1) |
|
|
73 | |
|
Integrating Your Knowledge |
|
|
63 | (10) |
|
|
73 | (1) |
|
|
73 | (2) |
|
|
75 | (4) |
|
|
79 | |
|
|
78 | (3) |
|
|
81 | |
|
|
|
|
72 | (6) |
|
|
78 | |
|
|
67 | |
|
|
50 | (26) |
|
|
|
Payroll Deduction Template |
|
|
76 | (1) |
|
|
77 | (5) |
|
|
82 | (48) |
|
|
82 | (1) |
|
|
83 | (1) |
|
|
|
|
84 | (6) |
|
|
90 | (4) |
|
|
94 | (5) |
|
Check Register Reconciliation |
|
|
99 | (6) |
|
Other Reconciliation Problems |
|
|
105 | (6) |
|
|
111 | (7) |
|
Money Market and CD Accounts |
|
|
118 | (12) |
|
|
|
|
123 | (1) |
|
|
123 | (1) |
|
|
123 | |
|
Integrating Your Knowledge |
|
|
89 | (27) |
|
|
116 | (7) |
|
|
123 | (2) |
|
|
125 | (4) |
|
|
129 | |
|
|
128 | |
|
|
|
|
115 | (7) |
|
|
122 | (6) |
|
|
128 | |
|
|
97 | (6) |
|
|
103 | (23) |
|
|
|
|
126 | (1) |
|
Bank Reconciliation Spreadsheet |
|
|
127 | (3) |
|
|
130 | (58) |
|
|
130 | (1) |
|
|
131 | (1) |
|
|
|
|
132 | (7) |
|
Discounted Promissory Notes |
|
|
139 | (5) |
|
|
144 | (6) |
|
|
150 | (6) |
|
|
156 | (5) |
|
|
161 | (4) |
|
|
165 | (7) |
|
Credit Card Finance Charges |
|
|
172 | (16) |
|
|
|
|
179 | |
|
|
160 | (11) |
|
|
171 | (7) |
|
|
178 | (1) |
|
Integrating Your Knowledge |
|
|
178 | |
|
|
171 | (8) |
|
|
179 | (2) |
|
|
181 | (4) |
|
|
185 | |
|
|
184 | (3) |
|
|
187 | |
|
|
|
|
163 | |
|
|
148 | (36) |
|
|
184 | |
|
|
177 | |
|
|
169 | (13) |
|
|
|
|
182 | (1) |
|
|
183 | (5) |
|
|
188 | (32) |
|
|
188 | (1) |
|
|
189 | (1) |
|
|
|
|
190 | (4) |
|
|
194 | (5) |
|
|
199 | (3) |
|
|
202 | (6) |
|
|
208 | (12) |
|
|
|
|
212 | (1) |
|
|
212 | |
|
|
193 | (19) |
|
|
212 | |
|
|
207 | (6) |
|
|
213 | (2) |
|
|
215 | (4) |
|
|
219 | |
|
|
218 | |
|
|
|
|
211 | (7) |
|
|
218 | |
|
|
205 | |
|
|
192 | (24) |
|
|
|
Rent or Buy Comparison Template |
|
|
216 | (1) |
|
Sales Tax Calculator Spreadsheet |
|
|
217 | (3) |
|
|
220 | (60) |
|
|
220 | (1) |
|
|
221 | (1) |
|
|
|
|
222 | (7) |
|
|
229 | (7) |
|
|
236 | (6) |
|
|
242 | (7) |
|
|
249 | (7) |
|
|
256 | (4) |
|
|
260 | (4) |
|
|
264 | (16) |
|
|
|
|
269 | (1) |
|
|
269 | (1) |
|
|
269 | |
|
Integrating Your Knowledge |
|
|
241 | (18) |
|
|
259 | (11) |
|
|
270 | (3) |
|
|
273 | (4) |
|
|
277 | |
|
|
276 | (3) |
|
|
279 | |
|
|
|
|
268 | (8) |
|
|
276 | |
|
|
262 | (12) |
|
|
|
Mortgage Payment Template |
|
|
274 | (1) |
|
Insurance Loss Spreadsheet |
|
|
275 | (5) |
|
Insurance and Investments |
|
|
280 | (64) |
|
|
280 | (1) |
|
|
281 | (1) |
|
|
|
|
282 | (7) |
|
|
289 | (6) |
|
|
295 | (5) |
|
|
300 | (5) |
|
|
305 | (5) |
|
|
310 | (8) |
|
|
318 | (6) |
|
|
324 | (7) |
|
|
331 | (13) |
|
|
|
|
336 | |
|
|
330 | (6) |
|
|
336 | |
|
Integrating Your Knowledge |
|
|
316 | (20) |
|
|
336 | (1) |
|
|
336 | (3) |
|
|
339 | (4) |
|
|
343 | |
|
|
342 | |
|
|
|
|
328 | (14) |
|
|
342 | |
|
|
321 | (14) |
|
|
335 | (5) |
|
|
|
|
340 | (1) |
|
Major Medical Spreadsheet |
|
|
341 | (3) |
|
|
344 | (40) |
|
|
344 | (1) |
|
|
345 | (1) |
|
|
|
Measures of Central Tendency |
|
|
346 | (5) |
|
|
351 | (6) |
|
|
357 | (7) |
|
Circle and Rectangle Graphs |
|
|
364 | (5) |
|
|
369 | (15) |
|
|
|
|
374 | (1) |
|
|
374 | (1) |
|
Integrating Your Knowledge |
|
|
374 | (1) |
|
|
374 | (1) |
|
|
375 | (2) |
|
|
377 | (4) |
|
|
381 | |
|
|
380 | (3) |
|
|
383 | |
|
|
|
|
367 | (6) |
|
|
373 | (7) |
|
|
380 | |
|
|
360 | |
|
|
354 | (24) |
|
|
|
Inflation Indicator Template |
|
|
378 | (1) |
|
Spreadsheet to Graph Sales Data |
|
|
379 | (5) |
|
|
384 | (38) |
|
|
384 | (1) |
|
|
385 | (1) |
|
|
|
Computer Hardware and Storage |
|
|
386 | (8) |
|
|
394 | (5) |
|
|
399 | (5) |
|
|
404 | (6) |
|
|
410 | (12) |
|
|
|
|
415 | |
|
|
409 | (6) |
|
|
415 | (1) |
|
Integrating Your Knowledge |
|
|
415 | |
|
|
402 | (13) |
|
|
415 | (2) |
|
|
417 | (4) |
|
|
421 | |
|
|
420 | |
|
|
|
|
407 | (13) |
|
|
420 | |
|
|
414 | |
|
|
401 | (17) |
|
|
|
Technical Support Template |
|
|
418 | (1) |
|
Byte Conversion Spreadsheet |
|
|
419 | (3) |
|
Manage People and Inventory |
|
|
422 | (42) |
|
|
422 | (1) |
|
|
423 | (1) |
|
|
|
Employee Recruitment Costs |
|
|
424 | (6) |
|
Wage and Salary Increases |
|
|
430 | (5) |
|
|
435 | (5) |
|
Tracking and Reordering Inventory |
|
|
440 | (5) |
|
|
445 | (6) |
|
Ordering and Carrying Inventory |
|
|
451 | (13) |
|
|
|
|
455 | (1) |
|
|
455 | |
|
|
439 | (11) |
|
Integrating Your Knowledge |
|
|
450 | (5) |
|
|
455 | (1) |
|
|
455 | (2) |
|
|
457 | (4) |
|
|
461 | |
|
|
460 | (3) |
|
|
463 | |
|
|
|
|
454 | (6) |
|
|
460 | |
|
|
443 | (15) |
|
|
|
|
458 | (1) |
|
Ending Inventory Spreadsheet |
|
|
459 | (5) |
|
|
464 | (36) |
|
|
464 | (1) |
|
|
465 | (1) |
|
|
|
|
466 | (5) |
|
|
471 | (4) |
|
|
475 | (5) |
|
|
480 | (6) |
|
|
486 | (4) |
|
|
490 | (10) |
|
|
|
|
493 | |
|
|
479 | (14) |
|
|
493 | (1) |
|
Integrating Your Knowledge |
|
|
493 | |
|
|
489 | (4) |
|
|
493 | (2) |
|
|
495 | (4) |
|
|
499 | |
|
|
498 | |
|
|
484 | |
|
|
|
|
478 | (20) |
|
|
498 | |
|
|
488 | (4) |
|
|
492 | (4) |
|
|
|
|
496 | (1) |
|
Break-Even Point Spreadsheet |
|
|
497 | (3) |
|
|
500 | (54) |
|
|
500 | (1) |
|
|
501 | (1) |
|
|
|
Cash Sales and Sales on Account |
|
|
502 | (7) |
|
|
509 | (7) |
|
|
516 | (6) |
|
|
522 | (6) |
|
|
528 | (4) |
|
|
532 | (4) |
|
|
536 | (4) |
|
|
540 | (14) |
|
|
|
|
545 | |
|
|
520 | (19) |
|
|
539 | (1) |
|
|
539 | (6) |
|
Integrating Your Knowledge |
|
|
545 | |
|
|
515 | (30) |
|
|
545 | (2) |
|
|
547 | (4) |
|
|
551 | |
|
|
550 | (3) |
|
|
553 | |
|
|
|
|
534 | (3) |
|
|
537 | (13) |
|
|
550 | |
|
|
543 | (5) |
|
|
|
Forecasting Sales Template |
|
|
548 | (1) |
|
Series Discount Spreadsheet |
|
|
549 | (5) |
|
|
554 | (36) |
|
|
554 | (1) |
|
|
555 | (1) |
|
|
|
Preparing Income Statements |
|
|
556 | (6) |
|
Analyzing Income Statements |
|
|
562 | (4) |
|
|
566 | (5) |
|
|
571 | (5) |
|
|
576 | (5) |
|
|
581 | (9) |
|
|
|
|
583 | (1) |
|
|
583 | |
|
Integrating Your Knowledge |
|
|
580 | (3) |
|
|
583 | (2) |
|
|
585 | (4) |
|
|
589 | |
|
|
588 | |
|
|
|
|
573 | (9) |
|
|
582 | (6) |
|
|
588 | |
|
|
564 | (15) |
|
|
579 | (7) |
|
|
|
Balance Sheet Analyzer Template |
|
|
586 | (1) |
|
Income Statement Spreadsheet |
|
|
587 | (3) |
|
|
590 | (38) |
|
|
590 | (1) |
|
|
591 | (1) |
|
|
|
Production, Trade, and Finance |
|
|
592 | (5) |
|
International Time and Temperature |
|
|
597 | (5) |
|
International Measures of Length |
|
|
602 | (6) |
|
International Measures of Area |
|
|
608 | (6) |
|
International Measures of Capacity and Weight |
|
|
614 | (14) |
|
|
|
|
619 | |
|
|
596 | (23) |
|
|
619 | |
|
|
613 | (1) |
|
Integrating Your Knowledge |
|
|
613 | (6) |
|
|
619 | (2) |
|
|
621 | (4) |
|
|
625 | |
|
|
624 | (3) |
|
|
627 | |
|
|
|
|
612 | (6) |
|
|
618 | (6) |
|
|
624 | |
|
|
606 | (16) |
|
|
|
Currency Exchange Template |
|
|
622 | (1) |
|
Temperature Conversion Spreadsheet |
|
|
623 | (5) |
Selected Answers |
|
628 | (10) |
Glossary |
|
638 | (6) |
Index |
|
644 | (12) |
Credits |
|
656 | |