I require assistance preparing for an exam.
I have been given some practise questions that I would need your help solving and guiding me to the correct solution.
The questions involve:
- Manipulation of CSV files into pivot tables using a variety of different methods
- “Brainteaser” type of questions (E.g. Which factor below would influence "X" least if you consider “Y”, if you want to improve X, which solution below will be most effective, etc.)
- questions about different parameters like predicted estimated time of arrival), actual estimated time of arrival etc.
Must be extremely confident in the above areas. I am an advanced excel user but dont want to risk failure with time limitations.
The test has 32 questions
You have 2 hours to finish this test
You will be asked to access datasets via Dropbox links you must download these via "Direct Download" in order to view and be able to manipulate the data in a CSV file
If you are accessing this exercise and are based in China, please note you will need to ensure you use VPN in order to access this test
The test must be finished in one sitting. You cannot save and finish later
You will see the full list of questions upon beginning the exam and will have the opportunity to click on any of the 32 questions. You should start with question #1 and work forward as some questions have a dataset component included which can be accessed via the first question
You can navigate forward and backwards and change your answers until you submit the exam