EDA Viva Questions

Which of the following is the correct way to ensure the ID column acts as a primary key in Excel?

• Apply Conditional Formatting

• Sort IDs in ascending order

• Apply a filter

• Use Remove Duplicates on ID

Which feature is used to remove duplicate rows from a dataset in Excel?

• Sort

• Data Validation

• AutoSum

• Remove Duplicates

When importing a .csv file into Excel, which delimiter is commonly used?

• Semicolon

• Space

• Colon

• Comma

Which tool allows you to copy the style of one cell to another?

• Conditional Formatting

• Data Validation

• Fill Handle

• Format Painter

If you want dates in the format 28-Jul-2025, which option should be chosen?

• General → Number Format

• Text Format

• Time Format

• Custom Date Format (DD-MMM-YYYY)

Which of the following formulas correctly calculates the average of cells B2 to B21?

• =MEAN(B2:B21)

• =AVG(B2:B21)

• =SUM(B2:B21)/B2

• =AVERAGE(B2:B21)

What will the formula =IF(B2>=50, "Pass", "Fail") return if the value in B2 is exactly 50?

• Fail

• Error

• Blank

• Pass

In Conditional Formatting, if you want to highlight duplicate values, which is correct?

• Home → Sort & Filter → Filter → Duplicates

• Data → Remove Duplicates → Duplicate Highlight

• Insert → Conditional Formatting → Duplicate

• Home → Conditional Formatting → Highlight Cells Rules → Duplicate Values

Suppose you want to automatically generate IDs like URK24CS1201, URK24CS1202… Which Excel formula can be used?

• =TEXT(ROW(A1),"0000")

• =ROW(A1)&"URK24CS"

• =CONCAT("URK24CS",ROW(A1))

• ="URK24CS"&TEXT(ROW(A1)+1200,"0000")

Which of the following best explains the purpose of applying “Number Formatting” in Excel?

• To change the data itself

• To remove decimal values permanently

• To sort values in ascending order

• To standardize the display format of numeric data (currency, percentage, fraction, etc.)