Novotech Clinical Analyst Interview Questions and Answers

Create a pivot table to show the count of rows from a given dataset.

• Use the pivot function in Excel or similar software to create the pivot table.

• Select the dataset and choose the row/column fields to display the count of rows.

• You can also add filters or additional fields to customize the pivot table.

• Example: Pivot table showing the count of patients by diagnosis category.

Use VBA coding to remove NA values from a dataset

• Loop through the dataset and check for NA values

• Replace NA values with empty strings or other appropriate values

• Use VBA functions like IsEmpty or IsNull to identify NA values