Visual Basic for Application(VBA)

All your code, data inputs and outputs should be in the same worksheet. Each question will marked out of 100 marks and 10 marks are reserved for good presentation ie. efficiency, elegance and
clarity of the code. Therefore please remember to choose your data variable names carefully, indent
your code, comment extensively to explain your code. When there are multiple ways of doing the
same thing, use more efficient commands and richer data structures to achieve the same result.
There are two questions:
(i) Create a workbook with a macro that creates three or more additional excel windows from the
same workbook to analyse financial data. Explain how your VBA macro works.
(ii) Create a workbook containing a macro with VBA code that finds the average of a range of
numbers. The macro should also calculate other statistical parameters e.g descriptive statistics
Discuss how your macro functions