image: img/spreadsheet-templates-interview-questions.jpg folder: human-resources-and-legal category: template

const data1 = [
    ['What online resources do you use to help you do your job?', '2', 'Opinion', 'General', 'Problem Solving', '2'],
    ['How do you keep your technology skills current?', '3', 'Opinion', 'General', 'General', '5'],
    ['Do you prefer to work alone or in a team?', '4', 'Behavorial', 'General', 'Team Work', '1'],
    ['From a web software developer\'s perspective, which sites do you admire and why?', '3', 'Opinion', 'Web Development', 'General', '4'],
    ['How to optimize the assets of a website?', '5', 'Factual', 'Web Development', 'Technical Knowledge', '5'],
    ['A project needs to be deployed in a month, but the code, written by a previous developer, is messy and non-functional. Do you rewrite or start from scratch? Why and what does it depend on?', '5', 'Hypothetical', 'General', 'Problem Solving', 1],
    ['What are the benefits and the drawbacks of working in an Agile environment?', '5', 'Logic', 'Engineering', 'Stakeholder Management', '4'],
    ['We have a need to use technology that you are not familiar with. Would you start learning it or would you outsource/need outside help?', '3', 'Behavorial', 'General', 'Stakeholder Management', '3'],
    ['Given this hypothetical scenario, which do you believe is the most suitable database to be used?', '5', 'Factual', 'Database', 'Problem Solving', '2'],
    ['Describe the different types of indexes.', '2', 'Factual', 'Database', 'Technical Knowledge', '1']
]

const config = {
    tabs: true,
    toolbar: true,
    worksheets: [{
            minDimensions: [, 10],
            worksheetName: 'IT Interview Questions',
            data: data1,
            columns: [{
                    type: 'notes',
                    title: 'Name',
                    width: '200px',
                },
                {
                    type: 'rating',
                    title: 'Level',
                    width: '100px',
                    color: 'red'
                },
                {
                    type: 'dropdown',
                    title: 'Type',
                    width: '150px',
                    source: ['Behavorial', 'Opinion', 'Logic', 'Hypothetical', 'Factual'],
                    options: {
                        newOptions: true,
                    }
                },
                {
                    type: 'dropdown',
                    title: 'Area',
                    width: '150px',
                    source: ['Engineering', 'Web Development', 'Database', 'General'],
                    options: {
                        newOptions: true,
                    }
                },
                {
                    type: 'dropdown',
                    title: 'Competencies',
                    width: '110px',
                    source: ['Problem Solving', 'Communication', 'Leadership', 'Stakeholder Management', 'Team Work', 'General', 'Technical Knowledge'],
                    options: {
                        newOptions: true,
                    }
                },
                {
                    type: 'record',
                    title: 'Reviewed by',
                    worksheetId: 'reviewers',
                    width: '110px',
                },
            ]
        },
        {
            worksheetName: 'Reviewers',
            worksheetId: 'reviewers',
            minDimensions: [4,4],
            columns: [
                {
                    type: 'text',
                    title: 'Name',
                    width: '250px'
                },
                {
                    type: 'dropdown',
                    title: 'Area',
                    width: '300px',
                    multiple: true,
                    source: ['Engineering', 'Web Development', 'Database', 'Mobile Development', 'General'],
                    options: {
                        newOptions: true,
                    }
                },
            ],
            data: [
                {
                    id: 1,
                    data: [
                        'Letha Braun',
                        'Web Development'
                    ],
                },
                {
                    id: 2,
                    data: [
                        'Ford Koepp',
                        'Engineering;Database'
                    ],
                },
                {
                    id: 3,
                    data: [
                        'Brooks Effertz Jr.',
                        'General'
                    ],
                },
                {
                    id: 4,
                    data: [
                        'Jeanette Johns',
                        'Mobile Development'
                    ],
                },
                {
                    id: 5,
                    data: [
                        'Winston Romaguera',
                        'Mobile Development;Engineering'
                    ],
                },
            ]
        },
    ]
}