​Real WFP written test for Senior Admin Assistant G5 - G6

INSTRUCTIONS FOR THE CANDIDATE

Many thanks for your interest in this WFP position. As part of the selection process, you are invited to undertake the following written test.

Instructions:

1. Please do not write your name or reveal your identity anywhere on the test paper or in the answers. All the tests will be scored anonymously.
2. Please answer ALL the questions in English.
3. Use this same document and an excel sheet to answer the questions and create as many pages/tabs as you may require.
4. You can use your phone or internet resources or any other reference material when answering this test paper.
5. You have 60 minutes to complete the test. Please return the question sheet and the excel files (Annex 3) to the test administrator via email at the end of your test.
6. Your test answers must be sent back to Steven Grey at s.grey@uncareer.org

Test Summary:

• Question 1 (20 points) – Prioritizing Tasks
• Question 2 (20 points) – Online survey research
• Question 3 (20 points) – Excel expenditure report

TEST QUESTIONS

Question 1

As a Snr Admin Assistant in the Supporter Engagement Team you will be presented with numerous tasks and enquiries throughout your day. Prioritizing your work will be a necessity. For this task, imagine the current date is Monday, the 9th April, 9.30 am. Please read through the below 8 tasks. Kindly list them in your preferred order and explain in short your grounds for your prioritization under each task.

1. Your Manager has requested an overview of the status of the section’s budget, expenditure and remaining balance for a meeting in which she/he is to present tomorrow morning.

There is less than one day of preparation and the report requires a secondary action on the part of the manager; read it, analyze it and provide feedback if necessary.

2. Preparing a Requisition on the system for the procurement of core services which are urgent.

It can be done in the system the same Monday, it can be done while the manager is reviewing the first report.

3. Team meeting Monday 9th April: action points and minutes need to be prepared and circulated.

It can be done at the end of the day and sent the next day as a reminder of the action items to all attendees.

4. You are supporting a team member preparing extensive and complex procurement documentation and there is still a lot of work to be done on the documents. There is a meeting with the procurement team on the Wednesday 11th April to review documentation. uncareer.org

Prioritized in this way according to the given deadline.

5. A new member of the team starts on Wednesday 18th April. You will need to arrange induction meetings, meet and great, and ensure that the new staff member has all the necessary computer equipment, access to systems, and seating arrangements. You may also wish to arrange a welcome lunch.

Prioritized in this way according to the given deadline.

6. You prepare monthly team work project status reports. The March team status report is not yet complete and should have been submitted on Friday 5th March.

Prioritized in this way according to the given deadline.

7. A team member has given you an invoice (‘Net 30’) from one of the section’s suppliers to process the payment. The invoice date is 23rd March.

Prioritized in this way according to the given deadline.

8. Filing and archiving documents.

It is a continuous process that, depending on the type of document, can be done right after finishing the main task.

uncareer.org

Question 2 (20 points)

The Supporter Engagement Management team wishes to procure a new online survey function software. Below are some of the requirements gathered:

Please do some research online and find 3 online services that you think would be suitable. List why you have chosen to put forward these suppliers and list the costs involved.

All options in the table meet the minimum requirements listed, including integration with SharePoint or Salesforce. The software was considered for having ratings on the GetApp website above 4 out of 5 points. Each supplier should be contacted to confirm corporate pricing:

# SOFTWARE NAME REASON TO CHOOSE PRICING

1 SurveyMonkey Easy drag-and drop interface and large collection of templates Starting at 32 $USD

2 QualtricsXM Survey Tool Tool with a focus on research. Very useful to take advantage of the gathered data. It used to be a bit hard to use, but User Interface has improved a lot. Request has been sent. Waiting for confirmation

3 Paperform Free-text interface and very customizable. Starting at 12.52 $USD

Question 3 (20 points)

Please open ‘Annex 3_Expenditure Report’ and follow the Instructions in Tab 1 or below:

1. Change the page orientation of the document to landscape. X -Addressed

2. Bold the headings in A2:AH2 and increased the font size to 11. X Addressed

3. Change the width of Column AB and AH to 40 points X Addressed

4. AutoFit the content in columns B through AA. X Not addressed

5. Insert one row below Row 1. In cell A2, key in the text “Expenditure Report 2018” X Addressed

6. Merge and center the title (‘CC 95729 /95722’) in cell A1 across columns A through C. X Addressed

7. Insert an AutoSum Formula in cell S177. X Addressed

8. Place a double bottom border in cell S117. X Addressed

9. In cell S178 insert Average Formula for data in S4:S176. X Addressed

10. In cell A180 insert a COUNTIF function to calculate how many entries are in the report for Period ‘1’ (Column L). X Addressed

11. In cell B185 insert a SUMIF formula to calculate the expenditure in USD (Column S) for Period ‘1’ (Column L). X Addressed

12. In cell B186 and B187 do the same (insert SUMIF formula) for Period ‘2’ and ‘3’. X

13. Format numbers in cells B185, B186 and B187 to show NO decimals and with a ’thousand separator’. X Addressed

14. Key in ‘January’ in cell A185, ‘February’ in cell A186 and ‘March’ in cell A187. X Addressed

15. Insert a ‘Table’ using the values $A$185:$B$187 – your table does not have headers. X Addressed

16. Rename your table “Expenditure Q12018”. X Addressed

17. Rename Column 1 of the table ‘‘Month’ and Column 2, ‘Expenditure’ X Addressed

18. Create one new Tab in the excel sheet and rename it as ‘Chart’. X Addressed

19. Change ‘Chart’ Tab Color to standard ‘dark red’. X Addressed

20. In Chart Tab insert a ‘Cluster Column Chart’ using the data from “Expenditure Q1-2021” table. In the horizontal axis you should have the months. addressed

21. Change the Chart Title to ‘Expenditure Q1-2021’ addressed

22. Add an Vertical Axis title and rename it ‘USD’ Not addressed.

23. Add a Data Table inside the Chart. Not addressed

Please remember to save your changes and summit the excel file (Annex 3) at the end of your test.

Thank you for completing the test.

In case you have any questions please check FAQ about UN recruitment or feedback me to feedback@uncareer.net or

Steven White, CEO Uncareer.net

𝐂𝐡𝐚𝐧𝐠𝐞 𝐘𝐨𝐮𝐫 𝐋𝐢𝐟𝐞 𝐍𝐨𝐰: 𝐏𝐨𝐰𝐞𝐫𝐟𝐮𝐥 𝐓𝐞𝐜𝐡𝐧𝐢𝐪𝐮𝐞𝐬 𝐡𝐨𝐰 𝐭𝐨 𝐠𝐞𝐭 𝐚 𝐣𝐨𝐛 𝐢𝐧 𝐭𝐡𝐞 𝐔𝐧𝐢𝐭𝐞𝐝 𝐍𝐚𝐭𝐢𝐨𝐧𝐬 𝐍𝐎𝐖!