Director Data Science Interview Questions

453 director data science interview questions shared by candidates

excel test prior to the interview : Please complete the following test in the time given. Tasks 1. Make the table look more professional and presentable. 2. Using a formula and or/written text, highlight some differences between Areas 1 and 7 3. Create an extra column and row showing average values for the data. 4. Set a conditional format which highlights any number under 700 in red. 5. Sort the data by the July-23 totals descending. 6. Using the column created in Task 3 as a reference, show values in the table that are 'above average' or 'below average'. 7. Insert a column between Columns F & G to show the difference in the values in Columns F & G. 8. Create a graph of the data. 9. Demonstrate the use of the Count or Subtotal function 10. Add the following password 'Cl0ckwise' which users will then need to input to edit Sheet1.
avatar

Data Science Manager

Interviewed at Royal College of General Practitioners

3.4
May 6, 2024

excel test prior to the interview : Please complete the following test in the time given. Tasks 1. Make the table look more professional and presentable. 2. Using a formula and or/written text, highlight some differences between Areas 1 and 7 3. Create an extra column and row showing average values for the data. 4. Set a conditional format which highlights any number under 700 in red. 5. Sort the data by the July-23 totals descending. 6. Using the column created in Task 3 as a reference, show values in the table that are 'above average' or 'below average'. 7. Insert a column between Columns F & G to show the difference in the values in Columns F & G. 8. Create a graph of the data. 9. Demonstrate the use of the Count or Subtotal function 10. Add the following password 'Cl0ckwise' which users will then need to input to edit Sheet1.

Viewing 21 - 30 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 453 interview questions and reports from Director data science interviews. Prepare for your interview. Get hired. Love your job.