Problem 13.13 Excel Problem

Required: Download the spreadsheet for this problem from the course website and perform the following tasks:

1. Explore Excels 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. 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. Use AutoFilter to display all purchases from suppliers in Zipcode 85110. What is displayed in cells D79 and D80? Why? 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

Duplicate invoice numbers from the same supplier