This article provides a detailed guide on how to add and use the Google spreadsheet question (test) in an assessment. The spreadsheet test helps to evaluate a candidate's skill and proficiency with:
i) Excel Fundamentals
ii) Data Analysis and Interpretation
iii) Knowledge of Formulas and Functions
iv) Performing calculations and Manipulating data using Tables
The first step is to create a new assessment by clicking on the Create Assessment button and give your assessment a name.
Move on to the next tab 'Tests', and add relevant tests to your assessment by using the filters given.
The third step is the 'Questions' tab where you can click on 'Custom' and select 'Spreadsheet'
Add all details to the spreadsheet question and click 'Add' to save changes.
Please note: When you add the spreadsheet link, a copy or clone of it will automatically be created when the candidate attempts this question. This means your original link remains unchanged and for each candidate, a clone of the same link is created giving them the option to enter their responses. Additionally, these responses are saved in each candidate's respective performance report.
By default a score of 5 is allotted for this question which you have the flexibility to modify according to your requirement.
You can also click on 'Preview' if you wish to know how the question would look at the candidate side.
Given below is a preview of the question.
The last step is to select relevant 'Settings' for your assessment. Once done, ensure to click on 'Next' and 'Save' for all changes to get saved.
Now you can go ahead and invite candidates for the assessment.
a) Here is how the cloned spreadsheet link that would be displayed for each candidate. You will notice that the candidate's email ID appears in the sheet name indicating that a clone of the original spreadsheet link has been done.
b) Referring to your question, the candidate will then enter their responses in the excel sheet.
c) Once a candidate completes the assessment, you can view the response of the candidate in your workspace dashboard by clicking on 'View Spreadsheet'.
d) Additionally in the downloadable PDF report, you will find the hyperlink to the view the candidate response.
We've covered the steps to add the spreadsheet question and also outlined how the question would look when the candidate is taking the assessment providing an overall understanding of how the spreadsheet test question functions.
If you have any further questions or need assistance, feel free to reach out to our support team at [email protected].