7 Steps to get a job in the United Nations

โ€‹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:

  • Data export
  • Multiple users (50 plus)
  • Easy to use
  • Results shown in charts
  • Integrates with SharePoint and/or Salesforce (desirable)
  • 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


    ๐——๐—ถ๐˜€๐—ฐ๐—ผ๐˜ƒ๐—ฒ๐—ฟ ๐—›๐—ผ๐˜„ ๐˜๐—ผ ๐—š๐—ฒ๐˜ ๐—ฎ ๐—๐—ผ๐—ฏ ๐—ถ๐—ป ๐˜๐—ต๐—ฒ ๐—จ๐—ก! ๐—ฅ๐—ฒ๐—ฎ๐—ฑ ๐—ผ๐˜‚๐—ฟ ๐—ก๐—˜๐—ช ๐—ฅ๐—ฒ๐—ฐ๐—ฟ๐˜‚๐—ถ๐˜๐—บ๐—ฒ๐—ป๐˜ ๐—š๐˜‚๐—ถ๐—ฑ๐—ฒ ๐˜๐—ผ ๐˜๐—ต๐—ฒ ๐—จ๐—ก ๐˜„๐—ถ๐˜๐—ต ๐˜๐—ฒ๐˜€๐˜ ๐˜€๐—ฎ๐—บ๐—ฝ๐—น๐—ฒ๐˜€ ๐—ณ๐—ผ๐—ฟ ๐—จ๐—ก๐—›๐—–๐—ฅ, ๐—ช๐—™๐—ฃ, ๐—จ๐—ก๐—œ๐—–๐—˜๐—™, ๐—จ๐—ก๐——๐—ฆ๐—ฆ, ๐—จ๐—ก๐—™๐—ฃ๐—”, ๐—œ๐—ข๐—  ๐—ฎ๐—ป๐—ฑ ๐—ผ๐˜๐—ต๐—ฒ๐—ฟ๐˜€!

    ๐‚๐ก๐š๐ง๐ ๐ž ๐˜๐จ๐ฎ๐ซ ๐‹๐ข๐Ÿ๐ž ๐๐จ๐ฐ: ๐๐จ๐ฐ๐ž๐ซ๐Ÿ๐ฎ๐ฅ ๐“๐ž๐œ๐ก๐ง๐ข๐ช๐ฎ๐ž๐ฌ ๐ก๐จ๐ฐ ๐ญ๐จ ๐ ๐ž๐ญ ๐š ๐ฃ๐จ๐› ๐ข๐ง ๐ญ๐ก๐ž ๐”๐ง๐ข๐ญ๐ž๐ ๐๐š๐ญ๐ข๐จ๐ง๐ฌ ๐๐Ž๐–!