Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Can somebody complete this excel worksheet for me, i am willing to pay the right price. Attached is the excel workbook and the problem. 13.13.

Can somebody complete this excel worksheet for me, i am willing to pay the right price. Attached is the excel workbook and the problem.

image text in transcribed
13.13. Excel Problem required Download the spreadsheet for this problem from the course website and perform the following tasks: 1. Explore Excel's AutoFilter function. a. At the bottom of the table, in cell C79 enter the words \"Total (sum)\" and in cell D79 enter the SUM function to total all amounts in column D. b. At the bottom of the table, in cell C80 enter the words \"Total (subtotal)\"and in cell D80 enter \"SUBTOTAL\" function to sum all the amounts in column D. c. Use AutoFilter to display all purchases from suppliers in Zipcode 85110. What is displayed in cells D79 and D80? Why? d. Repeat step 3 for Zipcodes 85111 and 85116. What is the value of using the AutoFilter function? 2. Use the AutoFilter and Sort functions to identify the following warning signs of potentially fraudulent supplier invoices: a. Suppliers that have only initials for the name b. Different suppliers with the same PO Box for an address c. Suppliers who submit sequentially numbered invoices d. Invoices just below a threshold requiring approval; for example, invoices below $1,000 e. Duplicate invoice numbers from the same supplier Date Invoice# Supplier (Payee) Amount Address 2-Jan 7455 AAA Hardware 3,965.89 1422 Third Ave. 2-Jan 1744 Z Best Office Supplies 2,984.05 678 Quinto St. 2-Jan 1933 DFR, Inc. 950.00 PO Box 174583 3-Jan 2043 City Electric 1,144.97 PO Box 876543 3-Jan 7688 AAA Hardware 2,757.95 1422 Third Ave. 4-Jan 7701 AAA Hardware 1,499.00 1422 Third Ave. 4-Jan 1921 Office Supply Headquarters 2,255.63 936 First Ave. 4-Jan 21999 True Blue Supplies 1,984.48 PO Box 3345 4-Jan 45218 Quick Supply, Inc 2,001.04 666 Scary Lane 5-Jan 33456 Jones Office Supplies 2,015.25 77 Sunset Strip 5-Jan 1288 L&J 995.99 PO Box 174583 8-Jan 1455 Easy Green Supplies 888.45 444 My Way 8-Jan 23976 True Blue Supplies 599.75 PO Box 3345 8-Jan 18357 Great Western Supplies 1,825.12 PO Box 22445 8-Jan 1288 Midwest Copiers 1,944.50 246 Eighth Street 9-Jan 1945 Z Best Office Supplies 4,733.55 678 Quinto St. 9-Jan 7899 AAA Hardware 2,184.37 1422 Third Ave. 9-Jan 33852 Jones Office Supplies 1,789.22 77 Sunset Strip 9-Jan 45892 Quick Supply, Inc 3,145.69 666 Scary Lane 10-Jan 6429 Xanadu Supplies 845.77 8080 Fourth St. 10-Jan 2378 Office Supply Headquarters 1,035.67 936 First Ave. 10-Jan 22846 Quality Paper 2,000.00 PO Box 99334 10-Jan 1573 Easy Green Supplies 4,275.14 444 My Way 10-Jan 18933 Great Western Supplies 3,358.95 PO Box 22445 11-Jan 1934 DFR, Inc. 984.96 PO Box 174583 11-Jan 47001 Quick Supply, Inc 2,345.82 666 Scary Lane 12-Jan 27456 True Blue Supplies 1,862.65 PO Box 3345 12-Jan 47035 Quick Supply, Inc 1,914.18 666 Scary Lane 12-Jan 1935 D.F.R. Inc 979.95 PO Box 174583 12-Jan 1622 Easy Green Supplies 566.50 444 My Way 12-Jan 6803 Xanadu Supplies 759.95 8080 Fourth St. 12-Jan 975 Orange Cleaning 1,833.55 111 West Apple Rd. 16-Jan 1414 Midwest Copiers 2,468.95 246 Eighth Street 16-Jan 1234 Hard copy masters 1,776.83 1010 Heard St. 16-Jan E Z Does It 1,583.95 55 Easy Street 16-Jan 2110 Z Best Office Supplies 2,488.95 678 Quinto St. 17-Jan 34468 Jones Office Supplies 1,635.95 77 Sunset Strip 18-Jan 47987 Quick Supply, Inc 1,718.95 666 Scary Lane 18-Jan 47987 Quick Supply, Inc 1,718.95 666 Scary Lane 18-Jan 1984 Fred's Toner 3,250.95 55 S. Van Buren 19-Jan 1847 Easy Green Supplies 2,846.50 444 My Way 19-Jan 31002 True Blue Supplies 4,193.77 PO Box 3345 19-Jan 19-Jan 19-Jan 22-Jan 22-Jan 22-Jan 22-Jan 23-Jan 23-Jan 23-Jan 23-Jan 23-Jan 24-Jan 24-Jan 25-Jan 25-Jan 25-Jan 26-Jan 26-Jan 26-Jan 26-Jan 26-Jan 29-Jan 29-Jan 29-Jan 30-Jan 30-Jan 30-Jan 31-Jan 31-Jan 31-Jan 31-Jan 31-Jan 31-Jan 31-Jan 1936 White shipping 1357 Hard copy masters 1936 D.F.R. 3188 Office Supply Headquarters 49246 Quick Supply, Inc 6999 Xanadu Supplies 34765 True Blue Supplies 2255 Z Best Office Supplies 1975 White shipping 35859 True Blue Supplies 49842 Quick Supply, Inc 1583 Hard copy masters 1977 Easy Green Supplies 7135 Xanadu Supplies 37132 Jones Office Supplies 23591 Quality Paper 1699 Hard copy masters 51022 Quick Supply, Inc 37899 True Blue Supplies 1025 Orange Cleaning 19955 Great Western Supplies 38809 True Blue Supplies 2084 White shipping 8422 AAA Hardware 2133 Hard copy masters 2198 Hard copy masters 2788 Z Best Office Supplies 7403 Xanadu Supplies 1289 L&J 20066 Great Western Supplies 2055 Easy Green Supplies 38994 Jones Office Supplies 54599 Quick Supply, Inc 38809 True Blue Supplies 1937 DFR 2,255.50 PO Box 85287 1,156.76 1010 Heard St. 999.95 PO Box 174583 4,321.55 936 First Ave. 1,234.56 666 Scary Lane 2,844.77 8080 Fourth St. 3,328.44 PO Box 3345 4,172.65 678 Quinto St. 1,357.95 PO Box 85287 2,064.55 PO Box 3345 3,175.33 666 Scary Lane 4,442.95 1010 Heard St. 2,367.41 444 My Way 1,963.55 8080 Fourth St. 3,799.50 77 Sunset Strip 2,244.56 PO Box 99334 3,847.66 1010 Heard St. 3,122.85 666 Scary Lane 1,499.55 PO Box 3345 1,833.55 111 West Apple Rd. 2,863.55 PO Box 22445 3,172.99 PO Box 3345 4,295.25 PO Box 85287 1,933.50 1422 Third Ave. 4,125.77 1010 Heard St. 190.95 1010 Heard St. 3,524.68 678 Quinto St. 1,965.29 8080 Fourth St. 997.55 PO Box 174583 2,504.55 PO Box 22445 1,155.75 444 My Way 955.00 77 Sunset Strip 1,433.85 666 Scary Lane 3,172.99 PO Box 3345 989.99 PO Box 174583 City Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson State AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ Zip 85110 85116 85123 85111 85110 85110 85110 85120 85116 85110 85123 85114 85111 85111 85120 85116 85110 85110 85116 85110 85110 85111 85114 85111 85123 85116 85111 85116 85123 85114 85110 85114 85120 85122 85122 85116 85110 85116 85116 85122 85114 85111 Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson Tucson AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ AZ 85111 85122 85123 85110 85116 85110 85111 85116 85111 85111 85116 85122 85114 85110 85110 85111 85122 85116 85111 85114 85111 85111 85111 85110 85122 85122 85116 85110 85123 85111 85114 85110 85116 85120 85123

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Econometrics

Authors: R Carter Hill, William E Griffiths, Guay C Lim

5th Edition

9781118452271

Students also viewed these Accounting questions