Accounting > STUDY GUIDE > University of Missouri ACCOUNTANCY 2258 Exam 3 Study Guide Fall 2016 (All)

University of Missouri ACCOUNTANCY 2258 Exam 3 Study Guide Fall 2016

Document Content and Description Below

Accountancy 2258 Exam 3 Study Guide Exam 3 may consist of multiple-choice, matching, true/false, fill-in-the-blank, and problems. Exam questions will come from the information discussed in class in... conjunction with our Macro Notes and the macro summary files listed below. In the problems, you will be asked to write out the Visual Basic code for all or part of a macro or explain what the Visual Basic code presented means. Please make sure you go back and review all of the files we have worked through in class since Exam 2. The following is a summary of the information you will be expected to know for Exam 3. Macros and Visual Basic The following files should be helpful to review as you prepare for the exam: File Name Location File Type Purpose Macro Notes for Macro Sessions 1-6 Course DocumentsMacro Files-Macro Notes Word Summarizes class exercises and provides notes to review for exam preparation Macro Review Materials Course DocumentsMacro Files Word Discusses macros, defines macro terminology, provides detailed explanations of Visual Basic code structures along with examples VBA Syntax Summary Course DocumentsMacro Files Word Summarizes VBA code structures 1. Macros a. Be familiar with ALL terminology defined in the Macro Review Materials.doc file. b. Understand how to use ActiveX Controls – combo box, spin button, scroll bar, option buttons, and check boxes – and know why/when each of these would be used. Know what properties have to be changed for each ActiveX Control.  Combo box: origin and destination (distance) o Linked cell, bound column, column count, list fill range  Spin button: for the tax filing category (two arrows and two boxes) o Linked cell, max, min  Scroll bar: to help the user specify taxable income o Linked cell, small change (arrow), large change (space between), max, min  Option button: to allow the user to specify disposition of refund o Linked cell, caption o Will only allow you to select one of the available Option Buttons [Show More]

Last updated: 2 years ago

Preview 1 out of 7 pages

Buy Now

Instant download

We Accept: