Excel Problem

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

  • CreatedDecember 19, 2014
  • Files Included
Post your question