AutoSave OFF A A E ? C ... ACC 693 Activity 6 3 Student Template.xisx ~ Home Insert Draw Page Layout Formulas Data Review View Automate Acrobat ? Tell me MS Sans Serif 10 A A ag General Conditional Formatting Insert v Z Format as Table v max Delete v A Sort & Find & Analyze Paste B I UV $ ~ % " Cell Styles Format v Filter Select Data E5 X v fx B C D E F G H K L A Columns F-I can be filled in by Columns A-D are Use formula to calculate days outstanding using the IF formula/function, IN based on the year ended date of 3/31/19 such as IF E3 90 days >7 invoices Duplicates + Ready IT Accessibility: Good to goHome Insert Draw Page Layout Formulas Data Review View Automate Acrobat Q@ Tellme YT R S\\ e [l conditional Formatting v &3 Insert v = @ Format as Table v E Delete v B I 7KL R =T TR 3/31119 INVOICE_NO INVOICE_DATE INVOICE_AMOUNT DAYS_0OS Hint: Use conditional formatting Duplicates ACC 693 Module Six Activity Guidelines and Rubric Overview This assignment will demonstrate another use of Microsoft Excel to perform similar commands as Audit Command Language (ACL). You will use accounts payable files to identify anomalies. Prompt For this assignment, in the sample data files of the ACL software, find the data sets from two accounts payable tables, Veltronics_Unpaid_lnvoices and Veltronics_Master_File, and export them to Excel. An Excel template is provided to assist in the completion of this assignment. Your final product should demonstrate how Excel can be used to determine that all vendors included on the unpaid invoices are included in the accounts payable master list. Specifically, the following critical elements must be addressed: Onthe Aging Schedule tab of the template, create an aging accounts payable schedule that includes O to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days. e Onthe >90 days tab, prepare a table of all unpaid vendors' invoices more than 90 days old, including the vendors' names, invoice numbers, invoice dates, and invoice amounts. Onthe >7 invoices tab, prepare a table that indicates vendors with seven or more outstanding invoices. e Onthe Duplicates tab, explain how the duplicates can be found in the Trans table. What to Submit Your activity must be subp element. All com Criteria Module Six Activity Gul dS d 0SO idelines and Rubric.html e O EXCEl. Module Six Activity Rubric Proficient (100%) Needs Improvement (75%) xcel spreadsheet. Different tabs should be created in the Excel workbook for each critical Not Evident (0%) Aging Accounts Creates an aging accounts payable schedule that includes O to 30 days, 31 to 60days, 61 to 90 days, and over 90 days Creates an aging accounts payable schedule that includes Oto 30days, 31 to 60 days, 61 to 90 days, and over 90 days, but payable schedule is incomplete or contains errors Does not create an aging 23 accounts payable schedule that includes O to 30 days, 31to 60days, 61 to 90 days, and over 90 days Unpaid Vendors' Table Prepares a table of all unpaid vendors' invoices more than 90 days old, including the vendors' names, invoice numbers, invoice dates, and invoice amounts Prepares a table of all unpaid vendors' invoices more than 90 days old, including the vendors' names, invoice numbers, invoice dates, and invoice amounts, but table does not include all the requirements Does not prepare a table of 23 all unpaid vendors' invoices more than 90 days old Outstanding Invoices Table Prepares a table that indicates vendors with seven or more outstanding invoices Prepares a table that indicates vendors with seven or more outstanding invoices, but table is missing information Does not prepare a table that indicates vendors with seven or more outstanding 22 Duplicates Explains how the duplicates can be found in the Trans table Explains how the duplicates can be found in the Trans table, but explanationis unclear or miscalculated Does not explain how the duplicates can be found in the Trans table 22 Articulation of Response Submission has no major errors related to citations, grammar, spelling, syntax, or organization Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas 10 Total: 100%