Below is the execl table Please HELP a Filter the records so only invoices whose balance is past due are displayed b Sort the filtered data by invoice date (oldest first) c Include a Total row in this table and display sums for columns I through L (Quick Analysis) d Hide columns C, D, F, H, N (Home Format Hide and Unhide) e Remove the filter buttons and gridlines from the table ( Hint Use options on VIEW tab and the TABLE TOOLS DESIGN tab ) Invoice Nbr Company Sales Rep Sales Rep Commission Invoice Date Invoice Amount Days Past Due Current 1 30 days 31 60 days 61 90 days Over 90 days 10269 Coalescent Technologies Corporation Bright $ 50 70 6 2 2016 $ 676 00 0 $ 676 00 N A n a N a N a 10273 Consortium for Ocean Leadership Hamilton $ 128 54 5 28 2016 $ 2,142 40 4 $ $ 2,142 40 n a N a N a 10274 Grow Smart Delaware Hamilton $ 32 32 6 5 2016 $ 538 60 0 $ 538 60 N A n a N a N a 10282 MRSI Group, Inc Bright $ 11 66 6 9 2016 $ 155 40 0 $ 155 40 N A n a N a N a 10283 Natural Environment Research Co Newton $ 56 59 6 12 2016 $ 1,414 80 0 $ 1,414 80 N A n a N a N a 10291 Normandeau Associates Bright $ 41 46 5 17 2016 $ 552 80 15 $ $ 552 80 n a N a N a 10321 Alpharma,Inc Newton $ 5 76 5 5 2016 $ 144 00 27 $ $ 144 00 n a N a N a 10322 Alternatives Res Dev Fdtn Bright $ 8 40 5 7 2016 $ 112 00 25 $ $ 112 00 n a N a N a 10323 Cardio Tech International Inc Bright $ 12 33 5 8 2016 $ 164 40 24 $ $ 164 40 n a N a N a 10327 Citizens for the Protection of Waverly Bay Roberts $ 124 44 6 10 2016 $ 2,262 50 0 $ 2,262 50 N A n a N a N a 10329 Image Acoustics, Inc Newton $ 192 78 6 27 2016 $ 4,819 40 0 $ 4,819 40 N A n a N a N a 10356 New Mexico Regional Turf Foundation Bright $ 82 98 5 29 2016 $ 1,106 40 3 $ $ 1,106 40 n a N a N a 10358 Ocean Dynamics Inc Bright $ 33 90 6 2 2016 $ 452 00 0 $ 452 00 N A n a N a N a 10368 Synergy Innovations, Inc Bright $ 137 57 6 6 2016 $ 1,834 20 0 $ 1,834 20 N A n a N a N a 10370 Materials Sciences Corporation Hamilton $ 70 44 5 5 2016 $ 1,174 00 27 $ $ 1,174 00 n a N a N a 10395 Ekloff Marine Corp Hamilton $ 139 99 1 26 2016 $ 2,333 20 127 $ N A n a N a $ 2,333 20 10400 Hazen Research Inc Bright $ 229 73 6 1 2016 $ 3,063 00 0 $ 3,063 00 N A n a N a N a 10401 I M A Dynamite Group, Inc Bright $ 290 15 6 1 2016 $ 3,868 60 0 $ 3,868 60 N A n a N a N a 10406 Mikel, Inc Hamilton $ 121 09 2 7 2016 $ 2,018 20 115 $ N A n a N a $ 2,018 20 10407 Marine BioConversion, LLC Roberts $ 65 67 2 7 2016 $ 1,194 00 115 $ N A n a N a $ 1,194 00 10410 New Medical Center Bright $ 60 15 5 10 2016 $ 802 00 22 $ $ 802 00 n a N a N a 10413 Advanced Scientific Concepts, Inc Newton $ 84 93 6 16 2016 $ 2,123 20 0 $ 2,123 20 N A n a N a N a 10418 American Heart Association Newton $ 72 59 5 17 2016 $ 1,814 80 15 $ $ 1,814 80 n a N a N a 10430 Foster Corporation Bright $ 434 70 5 2 2016 $ 5,796 00 30 $ $ 5,796 00 n a N a N a 10432 Jet Propulsion Laboratory Bright $ 36 38 5 5 2016 $ 485 00 27 $ $ 485 00 n a N a N a 10436 Lyme Disease Assoc of NJ Bright $ 165 81 5 8 2016 $ 2,210 80 24 $ $ 2,210 80 n a N a N a 10439 Institute for Research Evaluation Bright $ 80 85 5 10 2016 $ 1,078 00 22 $ $ 1,078 00 n a N a N a 10443 Lincoln Institute of Policy Newton $ 21 50 6 15 2016 $ 537 60 0 $ 537 60 N A n a N a N a 10463 Pro Change Behavior Systems Hamilton $ 42 80 6 6 2016 $ 713 30 0 $ 713 30 N A n a N a N a 10471 American Psychology Foundation Newton $ 53 12 6 11 2016 $ 1,328 00 0 $ 1,328 00 N A n a N a N a 10473 Boston Medical Center Roberts $ 12 67 6 15 2016 $ 230 40 0 $ 230 40 N A n a N a N a 10476 CSCS Corp Roberts $ 10 03 6 17 2016 $ 182 40 0 $ 182 40 N A n a N a N a 10480 Promire Gas Company Newton $ 30 24 5 20 2016 $ 756 00 12 $ $ 756 00 n a N a N a 10482 Shire Development Inc Newton $ 5 88 6 21 2016 $ 147 00 0 $ 147 00 N A n a N a N a 10483 Global Environment Technology Foundation Newton $ 28 16 5 26 2016 $ 704 00 6 $ $ 704 00 n a N a N a 10484 Argonne National Laboratories Newton $ 15 45 6 26 2016 $ 386 20 0 $ 386 20 N A n a N a N a 10496 Lake Simco Conservation Authority Newton $ 8 00 5 5 2016 $ 200 00 27 $ $ 200 00 n a N a N a 10500 Perry Institute for Marine Science Bright $ 41 31 5 10 2016 $ 550 80 22 $ $ 550 80 n a N a N a 10502 Save the Lions Hamilton $ 48 98 5 11 2016 $ 816 30 21 $ $ 816 30 n a N a N a 10520 Army Corp Hamilton $ 12 00 4 30 2016 $ 200 00 32 $ N A $ 200 00 N a N a 10527 Cape Cod National Seashore NPS Hamilton $ 100 20 6 5 2016 $ 1,670 00 0 $ 1,670 00 N A n a N a N a 10539 Emitech Newton $ 14 22 6 16 2016 $ 355 50 0 $ 355 50 N A n a N a N a 10551 Genix Therapeutics, Inc Newton $ 73 44 6 28 2016 $ 1,836 00 0 $ 1,836 00 N A n a N a N a 10559 Nationa Park and Recreation Bright $ 41 09 6 6 2016 $ 547 80 0 $ 547 80 N A n a N a N a 10566 NM State Agricultural Experiment Station Newton $ 81 60 6 15 2016 $ 2,040 00 0 $ 2,040 00 N A n a N a N a 10567 Northeast Fisheries Science Center Newton $ 124 36 6 15 2016 $ 3,109 00 0 $ 3,109 00 N A n a N a N a 10571 SAECT Newton $ 25 91 6 18 2016 $ 647 75 0 $ 647 75 N A n a N a N a 10575 Environ Protection Agcy Roberts $ 118 11 6 21 2016 $ 2,147 40 0 $ 2,147 40 N A n a N a N a 10577 Altuna International Research Co Newton $ 22 76 6 26 2016 $ 569 00 0 $ 569 00 N A n a N a N a 10578 Bigelow Laboratory for Mining Newton $ 19 08 6 25 2016 $ 477 00 0 $ 477 00 N A n a N a N a 10586 BoBell Flavors, Inc Hamilton $ 1 68 5 20 2016 $ 28 00 12 $ $ 28 00 n a N a N a 10588 Brossman Engineering Bright $ 292 50 5 28 2016 $ 3,900 00 4 $ $ 3,900 00 n a N a N a 10589 Cadmus Group Hamilton $ 4 32 5 29 2016 $ 72 00 3 $ $ 72 00 n a N a N a 10590 Catalyst Foundation Newton $ 45 60 5 30 2016 $ 1,140 00 2 $ $ 1,140 00 n a N a N a 10622 Evans Hamilton Inc Newton $ 24 20 6 2 2016 $ 605 00 0 $ 605 00 N A n a N a N a 10623 Intervet International B V Hamilton $ 85 79 6 5 2016 $ 1,429 75 0 $ 1,429 75 N A n a N a N a 10625 Laser Fare Advanced Technology Group Newton $ 19 19 6 6 2016 $ 479 75 0 $ 479 75 N A n a N a N a 10629 Medical Tech International, Inc Newton $ 111 00 6 5 2016 $ 2,775 05 0 $ 2,775 05 N A n a N a N a 10640 NOMAD Limited Bright $ 70 88 6 15 2016 $ 945 00 0 $ 945 00 N A n a N a N a 10667 Northeast Regional Aquaculture Center Hamilton $ 115 26 5 25 2016 $ 1,921 00 7 $ $ 1,921 00 n a N a N a 10671 Sensor Tech, Inc Bright $ 69 01 6 8 2016 $ 920 10 0 $ 920 10 N A n a N a N a 10676 Sino Development Corporation Ltd Bright $ 40 11 6 15 2016 $ 534 85 0 $ 534 85 N A n a N a N a 10678 SORICO Bright $ 394 24 6 18 2016 $ 5,256 50 0 $ 5,256 50 N A n a N a N a 10686 Swedish Board of Fisheries SBF Bright $ 122 88 6 16 2016 $ 1,638 45 0 $ 1,638 45 N A n a N a N a 10687 St Jeremy Hospital Roberts $ 341 10 6 19 2016 $ 6,201 90 0 $ 6,201 90 N A n a N a N a 10689 Acquisition Center Bright $ 47 25 5 6 2016 $ 630 00 26 $ $ 630 00 n a N a N a 10702 FM Global Research Bright $ 24 75 6 25 2016 $ 330 00 0 $ 330 00 N A n a N a N a 10707 Lamont Doherty Earth Observatory Roberts $ 93 72 6 29 2016 $ 1,704 00 0 $ 1,704 00 N A n a N a N a 10741 Lemelson Foundation NCIIA Newton $ 11 40 6 30 2016 $ 285 00 0 $ 285 00 N A n a N a N a 10760 Conrad Hamilton $ 198 24 5 21 2016 $ 3,304 00 11 $ $ 3,304 00 n a N a N a 10763 Nalas Engineering Services, Inc Newton $ 24 64 6 5 2016 $ 616 00 0 $ 616 00 N A n a N a N a 10768 Tetra Tech Newton $ 59 08 1 8 2016 $ 1,477 00 145 $ N A n a N a $ 1,477 00 10776 Chemo International Inc Bright $ 523 84 6 15 2016 $ 6,984 50 0 $ 6,984 50 N A n a N a N a 10787 Child Wilfare Institute Bright $ 207 06 1 19 2016 $ 2,760 80 134 $ N A n a N a $ 2,760 80 10790 Ecochlor Roberts $ 46 75 5 22 2016 $ 850 00 10 $ $ 850 00 n a N a N a 10807 Emitech, Inc Hamilton $ 1 10 5 31 2016 $ 18 40 1 $ $ 18 40 n a N a N a 10815 Kent Electric Newton $ 1 60 5 5 2016 $ 40 00 27 $ $ 40 00 n a N a N a 10831 American Cancer Society Bright $ 201 33 6 16 2016 $ 2,684 40 0 $ 2,684 40 N A n a N a N a 10840 DHS Medical Assistance Bright $ 19 80 6 19 2016 $ 264 00 0 $ 264 00 N A n a N a N a 10858 EA Engineering, Science Technology, Inc Hamilton $ 38 94 2 29 2016 $ 649 00 93 $ N A n a N a $ 649 00 10864 KM Scientific Company Hamilton $ 16 92 5 6 2016 $ 282 00 26 $ $ 282 00 n a N a N a 10881 Russell Wisdom Foundation Bright $ 11 25 5 15 2016 $ 150 00 17 $ $ 150 00 n a N a N a 10887 Eknor Apex Company Roberts $ 3 85 5 15 2016 $ 70 00 17 $ $ 70 00 n a N a N a 10907 Maxwell Technologies Bright $ 8 14 5 27 2016 $ 108 50 5 $ $ 108 50 n a N a N a 10926 Memory Pharmaceuticals, Inc Hamilton $ 30 86 6 5 2016 $ 514 40 0 $ 514 40 N A n a N a N a 10935 Alaska Department of Fish Game Bright $ 52 50 6 8 2016 $ 700 00 0 $ 700 00 N A n a N a N a 10946 Ardane Therapeutics Hamilton $ 84 45 6 11 2016 $ 1,407 50 0 $ 1,407 50 N A n a N a N a 10957 Frontier Technology Inc Newton $ 70 51 4 17 2016 $ 1,762 70 45 $ N A $ 1,762 70 N a N a 10960 Institute of Technology Hamilton $ 16 60 6 18 2016 $ 276 60 0 $ 276 60 N A n a N a N a 10962 Merck Sharp Dohme Corp Bright $ 268 80 4 18 2016 $ 3,584 00 44 $ N A $ 3,584 00 N a N a 10963 GreenFins LLC Bright $ 5 10 6 18 2016 $ 68 00 0 $ 68 00 N A n a N a N a 10966 Pam Roddick Housing Authority Newton $ 50 22 6 19 2016 $ 1,255 60 0 $ 1,255 60 N A n a N a N a 10967 The Armore Corporation Bright $ 68 28 6 22 2016 $ 910 40 0 $ 910 40 N A n a N a N a 10982 Hudson River group Hamilton $ 60 84 6 26 2016 $ 1,014 00 0 $ 1,014 00 N A n a N a N a 10996 IODP Management International, Inc Newton $ 22 40 5 2 2016 $ 560 00 30 $ $ 560 00 n a N a N a 10998 IUCN Washington Office Newton $ 27 44 3 5 2016 $ 686 00 88 $ N A n a $ 686 00 N a 11007 Optodot Corporation Bright $ 197 54 5 8 2016 $ 2,633 90 24 $ $ 2,633 90 n a N a N a 11026 Adaptive Methods, Inc Hamilton $ 61 80 3 15 2016 $ 1,030 00 78 $ N A n a $ 1,030 00 N a 11037 Advanced Fuel Research Hamilton $ 3 60 5 21 2016 $ 60 00 11 $ $ 60 00 n a N a N a 11064 BAE Systems Roberts $ 259 73 5 31 2016 $ 4,722 30 1 $ $ 4,722 30 n a N a N a 11068 Baylor Research Institute Bright $ 178 86 6 5 2016 $ 2,384 80 0 $ 2,384 80 N A n a N a N a 11069 CACI Technologies, Inc Bright $ 27 00 3 5 2016 $ 360 00 88 $ N A n a $ 360 00 N a

The Answer is in the image, click to view ...

Question: Below is the execl table Please HELP! a. Filter the records so only invoices whose balance is past due are displayed. b. Sort the filtered

Below is the execl table Please HELP!

a. Filter the records so only invoices whose balance is past due are displayed.

b. Sort the filtered data by invoice date (oldest first).

c. Include a Total row in this table and display sums for columns I through L. (Quick Analysis)

d. Hide columns C, D, F, H, N (Home Format Hide and Unhide)

e. Remove the filter buttons and gridlines from the table. (Hint: Use options on VIEW tab and the TABLE TOOLS DESIGN tab.)

Invoice Nbr	Company	Sales Rep	Sales Rep Commission	Invoice Date	Invoice Amount	Days Past Due	Current	1-30 days	31-60 days	61-90 days	Over 90 days
10269	Coalescent Technologies Corporation	Bright	$ 50.70	6/2/2016	$ 676.00	0	$ 676.00	N/A	n/a	N/a	N/a
10273	Consortium for Ocean Leadership	Hamilton	$ 128.54	5/28/2016	$ 2,142.40	4	$ -	$ 2,142.40	n/a	N/a	N/a
10274	Grow Smart Delaware	Hamilton	$ 32.32	6/5/2016	$ 538.60	0	$ 538.60	N/A	n/a	N/a	N/a
10282	MRSI Group, Inc	Bright	$ 11.66	6/9/2016	$ 155.40	0	$ 155.40	N/A	n/a	N/a	N/a
10283	Natural Environment Research Co	Newton	$ 56.59	6/12/2016	$ 1,414.80	0	$ 1,414.80	N/A	n/a	N/a	N/a
10291	Normandeau & Associates	Bright	$ 41.46	5/17/2016	$ 552.80	15	$ -	$ 552.80	n/a	N/a	N/a
10321	Alpharma,Inc	Newton	$ 5.76	5/5/2016	$ 144.00	27	$ -	$ 144.00	n/a	N/a	N/a
10322	Alternatives Res & Dev Fdtn	Bright	$ 8.40	5/7/2016	$ 112.00	25	$ -	$ 112.00	n/a	N/a	N/a
10323	Cardio Tech International Inc.	Bright	$ 12.33	5/8/2016	$ 164.40	24	$ -	$ 164.40	n/a	N/a	N/a
10327	Citizens for the Protection of Waverly Bay	Roberts	$ 124.44	6/10/2016	$ 2,262.50	0	$ 2,262.50	N/A	n/a	N/a	N/a
10329	Image Acoustics, Inc.	Newton	$ 192.78	6/27/2016	$ 4,819.40	0	$ 4,819.40	N/A	n/a	N/a	N/a
10356	New Mexico Regional Turf Foundation	Bright	$ 82.98	5/29/2016	$ 1,106.40	3	$ -	$ 1,106.40	n/a	N/a	N/a
10358	Ocean Dynamics Inc.	Bright	$ 33.90	6/2/2016	$ 452.00	0	$ 452.00	N/A	n/a	N/a	N/a
10368	Synergy Innovations, Inc.	Bright	$ 137.57	6/6/2016	$ 1,834.20	0	$ 1,834.20	N/A	n/a	N/a	N/a
10370	Materials Sciences Corporation	Hamilton	$ 70.44	5/5/2016	$ 1,174.00	27	$ -	$ 1,174.00	n/a	N/a	N/a
10395	Ekloff Marine Corp.	Hamilton	$ 139.99	1/26/2016	$ 2,333.20	127	$ -	N/A	n/a	N/a	$ 2,333.20
10400	Hazen Research Inc.	Bright	$ 229.73	6/1/2016	$ 3,063.00	0	$ 3,063.00	N/A	n/a	N/a	N/a
10401	I. M. A. Dynamite Group, Inc.	Bright	$ 290.15	6/1/2016	$ 3,868.60	0	$ 3,868.60	N/A	n/a	N/a	N/a
10406	Mikel, Inc.	Hamilton	$ 121.09	2/7/2016	$ 2,018.20	115	$ -	N/A	n/a	N/a	$ 2,018.20
10407	Marine BioConversion, LLC	Roberts	$ 65.67	2/7/2016	$ 1,194.00	115	$ -	N/A	n/a	N/a	$ 1,194.00
10410	New Medical Center	Bright	$ 60.15	5/10/2016	$ 802.00	22	$ -	$ 802.00	n/a	N/a	N/a
10413	Advanced Scientific Concepts, Inc.	Newton	$ 84.93	6/16/2016	$ 2,123.20	0	$ 2,123.20	N/A	n/a	N/a	N/a
10418	American Heart Association	Newton	$ 72.59	5/17/2016	$ 1,814.80	15	$ -	$ 1,814.80	n/a	N/a	N/a
10430	Foster Corporation	Bright	$ 434.70	5/2/2016	$ 5,796.00	30	$ -	$ 5,796.00	n/a	N/a	N/a
10432	Jet Propulsion Laboratory	Bright	$ 36.38	5/5/2016	$ 485.00	27	$ -	$ 485.00	n/a	N/a	N/a
10436	Lyme Disease Assoc of NJ	Bright	$ 165.81	5/8/2016	$ 2,210.80	24	$ -	$ 2,210.80	n/a	N/a	N/a
10439	Institute for Research & Evaluation	Bright	$ 80.85	5/10/2016	$ 1,078.00	22	$ -	$ 1,078.00	n/a	N/a	N/a
10443	Lincoln Institute of Policy	Newton	$ 21.50	6/15/2016	$ 537.60	0	$ 537.60	N/A	n/a	N/a	N/a
10463	Pro Change Behavior Systems	Hamilton	$ 42.80	6/6/2016	$ 713.30	0	$ 713.30	N/A	n/a	N/a	N/a
10471	American Psychology Foundation	Newton	$ 53.12	6/11/2016	$ 1,328.00	0	$ 1,328.00	N/A	n/a	N/a	N/a
10473	Boston Medical Center	Roberts	$ 12.67	6/15/2016	$ 230.40	0	$ 230.40	N/A	n/a	N/a	N/a
10476	CSCS Corp.	Roberts	$ 10.03	6/17/2016	$ 182.40	0	$ 182.40	N/A	n/a	N/a	N/a
10480	Promire Gas Company	Newton	$ 30.24	5/20/2016	$ 756.00	12	$ -	$ 756.00	n/a	N/a	N/a
10482	Shire Development Inc.	Newton	$ 5.88	6/21/2016	$ 147.00	0	$ 147.00	N/A	n/a	N/a	N/a
10483	Global Environment & Technology Foundation	Newton	$ 28.16	5/26/2016	$ 704.00	6	$ -	$ 704.00	n/a	N/a	N/a
10484	Argonne National Laboratories	Newton	$ 15.45	6/26/2016	$ 386.20	0	$ 386.20	N/A	n/a	N/a	N/a
10496	Lake Simco Conservation Authority	Newton	$ 8.00	5/5/2016	$ 200.00	27	$ -	$ 200.00	n/a	N/a	N/a
10500	Perry Institute for Marine Science	Bright	$ 41.31	5/10/2016	$ 550.80	22	$ -	$ 550.80	n/a	N/a	N/a
10502	Save the Lions	Hamilton	$ 48.98	5/11/2016	$ 816.30	21	$ -	$ 816.30	n/a	N/a	N/a
10520	Army Corp	Hamilton	$ 12.00	4/30/2016	$ 200.00	32	$ -	N/A	$ 200.00	N/a	N/a
10527	Cape Cod National Seashore NPS	Hamilton	$ 100.20	6/5/2016	$ 1,670.00	0	$ 1,670.00	N/A	n/a	N/a	N/a
10539	Emitech	Newton	$ 14.22	6/16/2016	$ 355.50	0	$ 355.50	N/A	n/a	N/a	N/a
10551	Genix Therapeutics, Inc.	Newton	$ 73.44	6/28/2016	$ 1,836.00	0	$ 1,836.00	N/A	n/a	N/a	N/a
10559	Nationa Park and Recreation	Bright	$ 41.09	6/6/2016	$ 547.80	0	$ 547.80	N/A	n/a	N/a	N/a
10566	NM State Agricultural Experiment Station	Newton	$ 81.60	6/15/2016	$ 2,040.00	0	$ 2,040.00	N/A	n/a	N/a	N/a
10567	Northeast Fisheries Science Center	Newton	$ 124.36	6/15/2016	$ 3,109.00	0	$ 3,109.00	N/A	n/a	N/a	N/a
10571	SAECT	Newton	$ 25.91	6/18/2016	$ 647.75	0	$ 647.75	N/A	n/a	N/a	N/a
10575	Environ Protection Agcy	Roberts	$ 118.11	6/21/2016	$ 2,147.40	0	$ 2,147.40	N/A	n/a	N/a	N/a
10577	Altuna International Research Co.	Newton	$ 22.76	6/26/2016	$ 569.00	0	$ 569.00	N/A	n/a	N/a	N/a
10578	Bigelow Laboratory for Mining	Newton	$ 19.08	6/25/2016	$ 477.00	0	$ 477.00	N/A	n/a	N/a	N/a
10586	BoBell Flavors, Inc	Hamilton	$ 1.68	5/20/2016	$ 28.00	12	$ -	$ 28.00	n/a	N/a	N/a
10588	Brossman Engineering	Bright	$ 292.50	5/28/2016	$ 3,900.00	4	$ -	$ 3,900.00	n/a	N/a	N/a
10589	Cadmus Group	Hamilton	$ 4.32	5/29/2016	$ 72.00	3	$ -	$ 72.00	n/a	N/a	N/a
10590	Catalyst Foundation	Newton	$ 45.60	5/30/2016	$ 1,140.00	2	$ -	$ 1,140.00	n/a	N/a	N/a
10622	Evans Hamilton Inc.	Newton	$ 24.20	6/2/2016	$ 605.00	0	$ 605.00	N/A	n/a	N/a	N/a
10623	Intervet International B.V.	Hamilton	$ 85.79	6/5/2016	$ 1,429.75	0	$ 1,429.75	N/A	n/a	N/a	N/a
10625	Laser Fare Advanced Technology Group	Newton	$ 19.19	6/6/2016	$ 479.75	0	$ 479.75	N/A	n/a	N/a	N/a
10629	Medical Tech International, Inc	Newton	$ 111.00	6/5/2016	$ 2,775.05	0	$ 2,775.05	N/A	n/a	N/a	N/a
10640	NOMAD Limited	Bright	$ 70.88	6/15/2016	$ 945.00	0	$ 945.00	N/A	n/a	N/a	N/a
10667	Northeast Regional Aquaculture Center	Hamilton	$ 115.26	5/25/2016	$ 1,921.00	7	$ -	$ 1,921.00	n/a	N/a	N/a
10671	Sensor Tech, Inc.	Bright	$ 69.01	6/8/2016	$ 920.10	0	$ 920.10	N/A	n/a	N/a	N/a
10676	Sino Development Corporation Ltd.	Bright	$ 40.11	6/15/2016	$ 534.85	0	$ 534.85	N/A	n/a	N/a	N/a
10678	SORICO	Bright	$ 394.24	6/18/2016	$ 5,256.50	0	$ 5,256.50	N/A	n/a	N/a	N/a
10686	Swedish Board of Fisheries SBF	Bright	$ 122.88	6/16/2016	$ 1,638.45	0	$ 1,638.45	N/A	n/a	N/a	N/a
10687	St Jeremy Hospital	Roberts	$ 341.10	6/19/2016	$ 6,201.90	0	$ 6,201.90	N/A	n/a	N/a	N/a
10689	Acquisition Center	Bright	$ 47.25	5/6/2016	$ 630.00	26	$ -	$ 630.00	n/a	N/a	N/a
10702	FM Global Research	Bright	$ 24.75	6/25/2016	$ 330.00	0	$ 330.00	N/A	n/a	N/a	N/a
10707	Lamont-Doherty Earth Observatory	Roberts	$ 93.72	6/29/2016	$ 1,704.00	0	$ 1,704.00	N/A	n/a	N/a	N/a
10741	Lemelson Foundation - NCIIA	Newton	$ 11.40	6/30/2016	$ 285.00	0	$ 285.00	N/A	n/a	N/a	N/a
10760	Conrad	Hamilton	$ 198.24	5/21/2016	$ 3,304.00	11	$ -	$ 3,304.00	n/a	N/a	N/a
10763	Nalas Engineering Services, Inc.	Newton	$ 24.64	6/5/2016	$ 616.00	0	$ 616.00	N/A	n/a	N/a	N/a
10768	Tetra Tech	Newton	$ 59.08	1/8/2016	$ 1,477.00	145	$ -	N/A	n/a	N/a	$ 1,477.00
10776	Chemo International Inc.	Bright	$ 523.84	6/15/2016	$ 6,984.50	0	$ 6,984.50	N/A	n/a	N/a	N/a
10787	Child Wilfare Institute	Bright	$ 207.06	1/19/2016	$ 2,760.80	134	$ -	N/A	n/a	N/a	$ 2,760.80
10790	Ecochlor	Roberts	$ 46.75	5/22/2016	$ 850.00	10	$ -	$ 850.00	n/a	N/a	N/a
10807	Emitech, Inc	Hamilton	$ 1.10	5/31/2016	$ 18.40	1	$ -	$ 18.40	n/a	N/a	N/a
10815	Kent Electric	Newton	$ 1.60	5/5/2016	$ 40.00	27	$ -	$ 40.00	n/a	N/a	N/a
10831	American Cancer Society	Bright	$ 201.33	6/16/2016	$ 2,684.40	0	$ 2,684.40	N/A	n/a	N/a	N/a
10840	DHS Medical Assistance	Bright	$ 19.80	6/19/2016	$ 264.00	0	$ 264.00	N/A	n/a	N/a	N/a
10858	EA Engineering, Science & Technology, Inc.	Hamilton	$ 38.94	2/29/2016	$ 649.00	93	$ -	N/A	n/a	N/a	$ 649.00
10864	KM Scientific Company	Hamilton	$ 16.92	5/6/2016	$ 282.00	26	$ -	$ 282.00	n/a	N/a	N/a
10881	Russell Wisdom Foundation	Bright	$ 11.25	5/15/2016	$ 150.00	17	$ -	$ 150.00	n/a	N/a	N/a
10887	Eknor Apex Company	Roberts	$ 3.85	5/15/2016	$ 70.00	17	$ -	$ 70.00	n/a	N/a	N/a
10907	Maxwell Technologies	Bright	$ 8.14	5/27/2016	$ 108.50	5	$ -	$ 108.50	n/a	N/a	N/a
10926	Memory Pharmaceuticals, Inc	Hamilton	$ 30.86	6/5/2016	$ 514.40	0	$ 514.40	N/A	n/a	N/a	N/a
10935	Alaska Department of Fish & Game	Bright	$ 52.50	6/8/2016	$ 700.00	0	$ 700.00	N/A	n/a	N/a	N/a
10946	Ardane Therapeutics	Hamilton	$ 84.45	6/11/2016	$ 1,407.50	0	$ 1,407.50	N/A	n/a	N/a	N/a
10957	Frontier Technology. Inc.	Newton	$ 70.51	4/17/2016	$ 1,762.70	45	$ -	N/A	$ 1,762.70	N/a	N/a
10960	Institute of Technology	Hamilton	$ 16.60	6/18/2016	$ 276.60	0	$ 276.60	N/A	n/a	N/a	N/a
10962	Merck Sharp & Dohme Corp.	Bright	$ 268.80	4/18/2016	$ 3,584.00	44	$ -	N/A	$ 3,584.00	N/a	N/a
10963	GreenFins LLC	Bright	$ 5.10	6/18/2016	$ 68.00	0	$ 68.00	N/A	n/a	N/a	N/a
10966	Pam Roddick Housing Authority	Newton	$ 50.22	6/19/2016	$ 1,255.60	0	$ 1,255.60	N/A	n/a	N/a	N/a
10967	The Armore Corporation	Bright	$ 68.28	6/22/2016	$ 910.40	0	$ 910.40	N/A	n/a	N/a	N/a
10982	Hudson River group	Hamilton	$ 60.84	6/26/2016	$ 1,014.00	0	$ 1,014.00	N/A	n/a	N/a	N/a
10996	IODP Management International, Inc	Newton	$ 22.40	5/2/2016	$ 560.00	30	$ -	$ 560.00	n/a	N/a	N/a
10998	IUCN-Washington Office	Newton	$ 27.44	3/5/2016	$ 686.00	88	$ -	N/A	n/a	$ 686.00	N/a
11007	Optodot Corporation	Bright	$ 197.54	5/8/2016	$ 2,633.90	24	$ -	$ 2,633.90	n/a	N/a	N/a
11026	Adaptive Methods, Inc.	Hamilton	$ 61.80	3/15/2016	$ 1,030.00	78	$ -	N/A	n/a	$ 1,030.00	N/a
11037	Advanced Fuel Research	Hamilton	$ 3.60	5/21/2016	$ 60.00	11	$ -	$ 60.00	n/a	N/a	N/a
11064	BAE Systems	Roberts	$ 259.73	5/31/2016	$ 4,722.30	1	$ -	$ 4,722.30	n/a	N/a	N/a
11068	Baylor Research Institute	Bright	$ 178.86	6/5/2016	$ 2,384.80	0	$ 2,384.80	N/A	n/a	N/a	N/a
11069	CACI Technologies, Inc.	Bright	$ 27.00	3/5/2016	$ 360.00	88	$ -	N/A	n/a	$ 360.00	N/a

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 Databases Questions!

LKE Distribution in North Platte, Nebr aska, sells everything needed to outfit an office from basic office supplies to high - end office equipment and technology to furniture. Laura Easterling...

7. Copy the Invoices worksheet, and then rename the copied worksheet as Overdue Accounts. In the Overdue Accounts worksheet, do the following: a. Filter the records so only invoices whose balance is...

Copy the Invoices worksheet, and then rename the copied worksheet as Overdue Accounts. In the Overdue Accounts worksheet, do the following: a . Filter the records so only invoices whose balance is...

7. a. Filter the records so only invoices whose balance is past due are displayed. Theses are all records with an amount in 1-30 days (column I), 31-60 days (column J), 61-90 days (column K), or Over...

Problem 3 How does computing the amount paid in commissions to Metaphor agents in Problem 2 help an auditor verify the management assertion of completeness? Chapter 3 ACL Exercises and Problems...

B. Sort the filtered data by invoice date (oldest first). How do I accomplish this? ' ss401 . i Formatting , Table. Shy Clipboard Font Alignment Styles 32 XDays Past Due Sales Invoice Days Past 2...

Lab 2-2 Accounts Receivable Summary by Customer (Tableau) Skip to question [The following information applies to the questions displayed below.] NOTE: Throughout this lab, every time a screenshot is...

Hi how are you? Do you think you can help me answer these questions? ACC 693 Chapter 8 Quiz Note: The material contained within these pages is taken directly from your textbook, Computerized Auditing...

An example of the three parties in an assurance engagement would be: O a. audit client, employee, customer. O b. auditor, shareholder, general public. OC. audit client, supplier, auditor. O d....

From the perspective of Australia, the demand for the Israeli shekel by Australian residents is primarily derived from: a) Exports to Israel. b) Imports from and exports to Israel. c) Imports from...

GIVEN ABOUT THE MARKET: T - bill return is 2 . 8 % annually. The expected annual return on the market portfolio equals 1 0 % .

Scenario: A Multi-national Corporation called The Globe has created a subsidiary called Thirst in an under-developed country called non-potable waters. This hosting country suffers from a severe...

Teamwork. Sit back-to-back with another student in the class so that neither of you can use nonverbal cues to complete this exercise. Take turns saying the following sentence aloud three times: Why...

While developing an oral report for a marketing class, Sara, one of your team members, locates an article that fits perfectly with your topic. Sara suggests that the group take several paragraphs...

Practice keeping your jaw, tongue, and lips flexible by saying the following sentences aloud three or more times each: (Objective 1) a. Loose lips sink ships. b. Which wristwatches are Swiss...