You are auditing Accounts Receivable of HUSKY Corp. as of December 31, 2013 Using Microsoft Excel. Below are links to videos and other information explaining various ways to audit using Excel. Utilize any method suitable to render results for the requirements of this project.

• Formula Auditing
• Excel Data Analysis - Formula Auditing
• Excel Audits Series: Auditing Function
• Formula Auditing in Excel | Trace Precedents, Trace Dependents & Show Formula
• How to Use Pivot Table for Data Audit

The Accounts Receivable general ledger balance is $4,263,919.52. Access the data files labeled "HUSKY Unpaid Invoices 2013" (the 12/31/2013, unpaid invoices), "HUSKY Shipping File 2013" (contains the shipment numbers and shipment dates for those invoices), and "HUSKY Credit Limit 2013" (contains each customer's credit limit). Sales are made FOB shipping point. The auditor has verified that the last shipment in 2013 is numbered 62050 and that shipping numbers have been used in proper sequence.

3. Age the unpaid invoices as of December 31, 2013, print the aging and graph of the aging, extract (by double-clicking on the over 45 days aging indicator) and indicate a list of invoices over 45 days old that also shows the total of those invoices.

Answer question number 3