Accounting Expert Answers & Study Resources : Page 225

  1) Auditing activities undertaken during substantive testing of account balances can be described as "auditing through the computer." 2) The external auditor serves the firm's stockbrokers, the government, and the general public. 3) Total audit cost is increased significantly when some audit resources are directed at reviewing and verifying the internal controls.

73) Four records have the record structure: PART (PART_NO, WARHSE). PART (101,1) PART (101,2) PART (103,1) PART (106,1) Which of the following would be appropriate to use as a record key? A) PART B) PART_NO C) WARHSE D) Answers B and C combined would form a record key. 74) To process and locate records in files, it is necessary to.

139) Describe the duties of the database administrator (DBA) regarding the data dictionary. 140) Describe the index, prime area, and overflow area in an ISAM file structure. 141) Describe how list organization and multilist organization work in tree and network databases. Also, distinguish between a list structure and a ring structure in.

100) Information systems application audits differ from information systems audits because application audits A) are divided into four general areas, each of which has three phases. B) involve reviewing input, processing, and output controls. C) are directed at the activities of systems analysts and programmers. D) focus primarily on fact-finding in the areas selected.

61) To cut highlighted text, you must press: A) Ctrl + X. B) Ctrl + C. C) Ctrl + V. D) Ctrl + Z. 62) To copy highlighted text, you must press: A) Ctrl + X. B) Ctrl + C. C) Ctrl + V. D) Ctrl + Z. 63) To Paste highlighted text, you must press: A) Ctrl + X. B) Ctrl.

90) Which of the following information system auditing technologies produces a printed audit trail of computer processing? A) Extended records B) Snapshot C) Sample audit review file D) System control audit review file 91) Tracing of a program's execution provides A) programmed edits for input data items. B) test data for subsequent processing. C) a detailed listing of.

113) Database dictionaries are defined and controlled by A) a DBA. B) a DBMS. C) the SQL DML component. D) the organization's steering committee. 114) Which of the following is an alias? A) A file whose records consist of data item descriptions B) The use of more than one name for the same field C) The user having.

11) ITF is a powerful information system audit technology. 12) Parallel simulation processes test data through real programs. 13) Parallel simulation is appropriate where transactions are sufficiently important to require a 100 percent audit. 14) GAS has a long history of usage because public accounting firms developed it in the 1960s. 15) Some embedded.

11) Home page icons are used to open frequently performed tasks. 12) It is possible to activate any icons on the Home you choose even if the options are not listed in the Preference window. 13) The Home and Center icons are isolated from the Navigation Bar and are displayed by selecting.

60) "Auditing with the computer" A) is only performed by external auditors. B) involves activities related to compliance testing. C) is only performed by internal auditors. D) involves activities related to substantive testing of account balances. 61) "Auditing through the computer" refers to A) substantive tests. B) compliance tests. C) transaction tests. D) application control tests. 62) An interim audit A).

81) The Help window tab that allows you to search for specific terms is named the: A) Search tab. B) Relevant Topics tab. C) Index tab. D) Table of Contents tab. 82) When backing up a company file, you are able to: A) add the date and time of the backup to the file name. B) limit.

130) Presented below is a list of terms relating to accounting information systems, followed by definitions of those terms. Required: Match the letter next to each definition with the appropriate term. Each answer will be used only once. ________ 1. DBA ________ 2. Inheritance ________ 3. Occurrence ________ 4. Branch ________ 5. Database model ________ 6. Record ________.

40) ________ auditors commonly undertake audits that are reviewed and relied upon by ________ auditors. 41) When batch processing was the dominant method used in computerized data processing, the ________ approach provided an adequate audit. 42) A clear and obvious benefit is obtained from the ________ analysis capability provided by information technology. 43).

50) ________ can be effectively used in conjunction with a test data technique. 51) Application controls are divided into ________ general areas. 52) The primary audit technique used in an information systems development audit is the review and testing of related ________. 53) Documentation governing the design, development, and implementation of application systems.

21) Specific documentation showing the nature of application controls in a system is known as control flowcharting. 22) Most information system audits follow a four-phase structure, which is followed by analysis and reporting of results. 23) An audit program is a detailed list of the audit procedures to be applied on a.

133) Listed below are ten examples of file organization. Required: From the following three choices, match the file organization technique with each of the ten examples listed. All techniques will be used more than once. S = Sequential IS = Indexed-sequential D = Direct access ________ 1. A large manufacturing company pays all employees once.

93) The processing time required to maintain a fully inverted file A) is fast since the entire index can be loaded into primary memory. B) is almost instantaneous because long indexes can be factored into subindexes. C) is fast when two processors are used simultaneously to process the data and index files at.

31) Audits of computer service centers do not require as high a degree of technical expertise as do audits of computerized applications. 32) Risk-based auditing provides assurances relating to the effectiveness of an organization's enterprise risk management process. 33) In RBA, the subject of the audit is how well the management prevents.

131) Presented below is a list of terms relating to accounting information systems, followed by definitions of those terms. Required: Match the letter next to each definition with the appropriate term. Each answer will be used only once. ________ 1. Ring structure ________ 2. Alias ________ 3. ISAM ________ 4. Relational algebra ________ 5. Tuple ________ 6..

21) Computerized accounting does the following EXCEPT: A) minimizes posting errors. B) protects the validity of data. C) coordinates posting, reporting, and the audit trail. D) makes it difficult to monitor transactions and analyze financial performance. 22) Computer hardware includes all the following EXCEPT: A) QuickBooks. B) Monitor. C) CD-Rom. D) Mouse. 23) The system software that translates user instructions.

124) Briefly describe the three phases of an information systems audit. 125) Describe three areas that an auditor could examine in an audit of a computer service center. .

1) The "where and when" of transaction posting is determined by the accountants. 2) The chart of accounts can be opened under the List icon. 3) Printing a COA report gives you a report to refer to when posting transactions. 4) Understanding a company's general ledger account framework helps to select the correct.

91) On the Home page you are able to select Customers to create ________, receive payments, create sales receipts, view and print statements and charges and enter refunds and credits. 92) On the Home page you are able to select Banking to record ________, reconcile, write checks, print checks, and review.

103) The cost of processing per transaction in a high-activity environment is the lowest in which of the following file organization techniques? A) Indexed B) Sequential C) Direct D) Indexed-sequential 104) Response time is affected by A) disk access time. B) how data records are physically distributed on the disk. C) the database management system but not the.

41) The commands used to open a list of customers, vendors, sales taxes, inventory, or chart of accounts are found under the: A) File menu. B) Edit menu. C) Lists menu. D) Company menu. 42) To access menus that allow you to enter company identifying information, close an accounting period, establish a budget, and set.

61) In the Report center, the Balance Sheet report that shows only the value of company assets, liabilities, and equity by account type is called the: A) Standard. B) Detail. C) Summary. D) Income and Expense Graph. 62) In the Report center, the reporting area that focuses on account activity and income tax preparation is.

31) To use a QuickBooks backup file, select: A) File>>Open>>Restore an Existing Company>>Open a company file. B) File>>Open>>Restore an Existing Company>>Restore a backup copy. C) File>>Open>>Restore an Existing Company>>Restore a portable file. D) File>Restore an Existing Company>>. 32) To Open a portable company file created with QuickBooks select: A) File>>Open>>Restore an Existing Company>>Open a company file. B).

120) Why are most audits now performed by auditing through and with the computer? 121) Explain why external auditors perform compliance testing when a main objective of a financial statement audit is to express an opinion regarding the fairness of the monetary balances in a company's financial statements. 122) How have personal.

117) Below are listed four procedures typically performed during an audit of accounts payable: Audit procedures: a. Test the mathematical accuracy of the accounts payable subsidiary ledger. b. Select samples of vouchers to examine in detail. c. Determine whether cash discounts were properly applied. d. Stratify accounts by value. Required: Briefly state a generalized audit software.

31) The two tabs within the Preferences window are: A) My Preferences and Company Preferences. B) Customer Preferences and Vendor Preferences. C) Receivables Preferences and Payable Preferences. D) Reports Preferences and Graphs Preferences. 32) The tab in the Preferences window that affects all users is the: A) My Preferences. B) Report Preferences. C) Company Preferences. D) Graphs Preferences. 33) The.

132) Presented below is a list of terms relating to accounting information systems, followed by definitions of those terms. Required: Match the letter next to each definition with the appropriate term. Each answer will be used only once. ________ 1. Logical data structure ________ 2. Key ________ 3. Node ________ 4. DQL ________ 5. Element ________ 6..

1) Accounting software eliminates tedious processes such as typing documents, manually posting and calculating transactions, and documenting the audit trail. 2) Application software does not have to match the computer operating system software. 3) When loading QuickBooks, the welcome screen has an overview tutorial that allows you to learn about how QuickBooks.

123) ________ is a multidimensional generalization of the 2-dimensional relational table which provides incredibly fast response times. A) OLAP B) UML C) RUP D) RAD 124) OLAP uses complicated multidimensional "indexes" called A) data mining. B) aggregations. C) drivers. D) transformers. 125) What defines an entire database being loaded into computer-internal high-speed random access memory or other high-speed electronic storage.

134) A database contains the following data: Student Schedule (Student#, Student_name, Major, Course#1, ClassTime1, Location1, Course#2, ClassTime2, Location2, Course#3, ClassTime3, Location3) Required: Normalize this relation through the third normal form. 135) Assume that the customer master file and the transaction file consist of the record numbers shown in the following sequence: Master file3, 7,.

21) On general ledger accounts, the optional ________ can be used to provide additional text describing the account. A) Description field B) Notes field C) Routing Number field D) Change Opening Balance button 22) For general ledger accounts assigned to the Account type of Bank, the ________ is used to store the bank account number. A).

80) Which of the following should be developed when the related application system is developed? A) Test data approach B) Integrated test facility C) Parallel simulation approach D) Artificial intelligence software 81) Which of the following processes real data through a test program? A) Test data approach B) Integrated test facility C) Parallel simulation approach D) Artificial intelligence software 82).

81) ________ determine where an account is placed on financial statements. 82) A field that toggles the account from active to inactive is called the ________ field. QBP will deny transaction posting to inactive accounts. 83) The ________ is a unique name to describe the account. The name is concise, properly spelled,.

71) When exporting reports, you can export Excel features such as: A) AutoFit. B) Freeze panes. C) Show Gridlines. D) all the above. 72) When exporting reports, you can export one as a/an: A) Excel workbook or Excel Macro-Enabled workbook. B) Excel Binary workbook. C) Excel 97-2003 workbook. D) Excel 3 workbook. 73) You can export a report to Excel.

51) In the Report center, to view an income statement that shows how much income or loss is being made on a job, select: A) By Job. B) By Class. C) Unclassed. D) Prev. Year Job. 52) In the Report center, to view an income statement that shows how much income or loss is being.

83) In the object-oriented modeling technique, an object class has the following structure: PAPER_INVENTORY (SUPPLIER_NO, DISCOUNT) What is the structure of the subclass COPY having the unique attributes QUANTITY and TYPE? A) COPY (QUANTITY, TYPE) B) COPY (SUPPLIER_NO, QUANTITY, TYPE) C) COPY (SUPPLIER_NO, DISCOUNT, QUANTITY, TYPE) D) COPY (PAPER_INVENTORY, QUANTITY, TYPE) 84) Network, tree, and relational models.

53) A database ________ is a collection of all data item names in a database, along with a description of the standardized representation form of the data items. 54) An invaluable benefit of DBMSs is their ability to provide ________ for databases. 55) One primary objective of a data dictionary is to.

115) Presented below is a list of terms relating to accounting information systems, followed by definitions of those terms. Required: Match the letter next to each definition with the appropriate term. Each answer will be used only once. ________ 1. Mapping ________ 2. Compliance testing ________ 3. Extended records ________ 4. Substantive testing ________ 5. Interim.

51) The menu command used to open a task window when performing multiple tasks is found under the: A) Reports menu. B) Windows menu. C) Help menu. D) Banking menu. 52) The Home page for QBP is divided into five main sections called: A) Clients, Expenses, Employees, Company, Help. B) Customers, Payables, Employees, Payroll, Banking. C) Receivables, Vendors,.

11) One of the QBP features that offer significant advantages over a manual accounting system is the ability to drilldown on a report to view underlying transactions. 12) The drilldown feature is available on all reports. 13) Accounting transactions should only be posted to the current accounting period. 14) In the real world,.

41) The preference on the My Preferences tab that sets the default account used when writing checks is the: A) Open the Write Checks. B) Open the Pay Bills with Checks. C) Open the Check Payments. D) Open the Make Payments. 42) The preference on the My Preferences tab that selects the default accounts for.

70) Information technology is used to perform some audit work that otherwise would be done manually. The use of information technology by auditors is A) essential. B) mandatory under AICPA Statements of Auditing Standards. C) optional. D) at the sole discretion of the manager in charge of the audit. 71) An external auditor conducts an.

71) To Find a transaction, you can press: A) Shift + F. B) Ctrl + Shift + F. C) Alt + F. D) Ctrl + F. 72) To create a new transaction, you can press: A) Shift + N. B) Ctrl + N. C) Alt + N. D) Ctrl + Shift + N. 73) To open a transaction journal, you.

43) The smallest block of data that can be stored and retrieved in an information system is a(n) ________. data item attribute element 44) ________ are one of the fundamental building blocks used to construct databases. 45) The term ________ ________ order applies to a field on which the file is not sorted. 46).

63) Fields associated with other fields in a logical grouping are known as A) elements. B) records. C) data items. D) attributes. 64) In the CUSTOMER record, the field NAME contains the word "Jones" along with 20 spaces after the last character. This is an example of a A) variable-length record. B) data item. C) fixed-length record. D) trailer. 65).

116) Presented below is a list of terms relating to accounting information systems, followed by definitions of those terms. Required: Match the letter next to each definition with the appropriate term. Each answer will be used only once. ________ 1. Audit program ________ 2. System control audit review file ________ 3. Auditing around-the-computer ________ 4..