Novotech Interview Questions and Answers

I am a detail-oriented and organized individual with strong analytical skills and a passion for numbers.

• Detail-oriented and organized

• Strong analytical skills

• Passion for numbers

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