Please finish the following excel file in 2 hours.
The problem sets instructions are listed in text boxes.
Knowledge Point:
- Essential Excel Functions: ADDRESS, DATEIF, Boolean, MOD, ISFORMULA, MATCH, INDEX, INDIRECT, OFFSET, Text Functions(LEFT, RIGHT, TRIM, LEN, etc), create dynamic charts, and so on)
- VBA: please see the attached 2 xlsm files (I will send you later, after confirm the tutor process) to get the details of the VBA code model. Try to finish this exam based on those VBA code model, you can make some changes on it. The main functions you will use are loop and macro recorders.
Please also consider the following:
⁃ Professional format and presentation are always important.
⁃ You should not include modules that do not have any code in it.
⁃ Do not include subroutines that are not relevant to the assignment (delete any subroutines you have used for testing).
⁃ Also, make sure to name your module/s and subroutines appropriately.
⁃ Make sure that all your subroutines are located in dedicated module/s. Do not delete or add additional modules.
⁃ The efficiency of your VBA code will be taken into consideration. Make sure you apply the efficiency methods we have learned in class. Make sure that your code is ‘clean’ (clear and well-organized), and properly indented.
⁃ Do not delete/add or rename the sheets in the midterm final excel file submission.
– Make sure to double-check your work for any errors before submission.
0 comments