Download Accounting Course Quizzes: Excel 2007 Macro-Enabled Instructions (Berg, ETSU) - Prof. Gary and more Quizzes Accounting in PDF only on Docsity! Use of help desk on this quiz is not allowed Acct 2020(Berg) Quizzes 6-8 Due as indicated in item 6 1. You Must Download the Excel spreadsheet files that you will use for these quizzes. The files are available for download on my class website at http://bergg.etsu.edu. Failure to use these files or failure to follow the directions will result in a grade of zero. Highlight the file link and right click on mouse button, Select Save target As option to download the file. Save the file to your hard drive or the storage source of your choice. 2. The files are Excel 2007 macro enabled files. You must make sure that you enable the macro. In Excel 2007 i. Launch Excel ii. Open the file iii. Select options on the Security warning “macros have been disabled” iv. Select enable this content and click on ok (failure to enable will result in grade of Zero) v. In the pop-up window, enter your first name and last name and click on OK (failure to do so will result in grade of zero) vi. See Illustrations below Select options Use of help desk on this quiz is not allowed vii. Complete the quizzes These files cannot be opened in earlier versions of Excel (2003 and earlier)) i. You need to come by my office to see me about possible work arounds if you use an earlier version of Excel 3. This assignment is not a group project. Students should work independently. Copying/plagiarism will result in a grade of 0 for all parties involved 4. The files should be renamed 2020 + your last name+quiz6.xlsm, 2020 + your last name+quiz7.xlsm & 2020 + your last name+quiz8.xlsm (i.e. 2020 Jones Quiz6.xlsm, 2020 Jones Quiz7.xlsm, etc). Failure to Rename file will result in grade of Zero 5. Send me the completed Excel file via the ETSU drop box at https://www.etsu.edu/oit/helpdesk/dropbox/. (Hardcopy printout will not be accepted for this quiz.) I have also placed a link to the drop box on my class web site. On the drop box page, browse to the location of your file. Select the file and upload the file. The next screen will indicate if the upload to the server was successful. In the From Field, enter your email address. (this should be the email address that you check on a regular basis) In the To Field, enter my email address Acct2020@bergg.etsu.edu, (Make sure you enter it correctly). Files not received because of typos in email To field or files sent to wrong email account will receive a grade of 0) Click on the send e-mail button You should get a screen indicating message was sent. If for some reason you cannot authenticate when using the drop box, send assignment as an email attachment to ACCT2020@bergg.etsu.edu Files not received in Excel format will receive a grade of 0. 6. Due on February23rd, 6:00 p.m. (missing this deadline will result in grade of zero) As I received notice from the drop box server that your file is available, I will download it and I will send you an email confirmation of receipt. Select enable this content and click on Ok Enter your name and click on Ok
